Search results for query: *

I understand what you guys mean. I think its the best way as well but i did leave out that this program is a batch job that is run nightly. Only one instance per night is run so i guess either way wouldnt hog the system. this job is "restartable" so if it poops out half way through they can...

I have a c++ program that makes a one column change to one table. Now this change could happen for 10,000 entries at a time but here's what I'm getting at. Do you think its more efficient to keep track of all the unique id's of entries i need to change, then at the end add a thousand at a time...

fish, thank you for the help but i guess i didnt explain enough. I am using an application that leaves a log file behind with all of its sql statements. The insert statements in this log are not formatted in correct sql syntax. basically i want my program to do this... 1. i give the perl...

thanks stevexff, I also found that i could use the same column_info call and leave the $column argument as undef. if you do that you get a hash of all the columns and their attributes.

One more question, How can i go about asking for a specific table and getting back a list of all of its columns in perl? thanks for all your help.

that definitely works but im having trouble understanding the sth object and its available methods. is there an online resource i can use for these questions i have about sth???

I'm writing a script that will generate insert statements for database tables. The only thing holding me back from making this work is finding out what types the columns are. If i know what type they are i can correctly format the values in my insert statement. is there a way to get the type...

yeah, thats what i thought initially i was going to do but thought maybe there was a more efficient way. Thank you for your help!

@x = ("in the", "skipping along"); @y = ("we walk in the park", "we walk in the dark", "we walk holding hands", "we walk skipping along"); I need to create an if statement that basically does this to search the y array... if (if any whole element in the x array is within any element on the y...

Im trying to move around parts of a string a get rid of some of it too. Below is an example... $str = "a b c d e f g VALUES(h i j k l m n) Bound Values: o|p|q|r|s|t|u|"; What i need to do is move the o|p|q|r|s|t|u| into the parenthsis after "VALUES" and then erase the stuff after it. I know...