Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: sql and hash confusion

by bichonfrise74 (Vicar)
on Mar 19, 2009 at 21:28 UTC ( [id://751881]=note: print w/replies, xml ) Need Help??


in reply to sql and hash confusion

I don't think you need a hash to convert your data into something that can be inserted into a database... Please see below or I just didn't understand what you were trying to do.
#!/usr/bin/perl use strict; while( <DATA> ) { s/,/\","/g; chomp; print "INSERT INTO dbo.RESULTS values (\"$_\");\n"; } __DATA__ 1/5/2009 3:55:30 PM,Login,18.490683,SearchLoad,15.012853,SearchCount,0 +:0.392878,SearchResults,16.048765,SearchSave,6.629372,SearchDelete,9. +614098,SearchDetails

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://751881]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (7)
As of 2024-04-26 09:34 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found