strings lost in a series of replace statements

[guineamation]

I have a series of "replace" statements inserting strings stored in variables inside a long "Insert" sentence into a database. The first two statements insert the values correctly after replacing the characters, the rest insert nothing, as if lost the values.

 

[onpnt]

can you give some of the details in regards to the replace functions and the coding involved? We have nothing really to on with what you provided.

____________________________________________________
_{The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-2924}

http://www.onpntwebdesigns.com

 

[guineamation]

Below is the function, and this line: replace (solution3, "'", "''&quot&"','"&_, seems to not insert anything though there's text in the form that sends a string to it.

c.execute "insert into phd values('"&_
request.form("id&quot&"','"&_
request.form("model&quot&"','"&_
request.form("problemdate&quot&"','"&_
replace (problem, "'", "''&quot&"','"&_
request.form("prosuby&quot&"','"&_
request.form("solution1date&quot&"','"&_
replace (solution1, "'", "''&quot&"','"&_
request.form("sol1suby&quot&"','"&_
request.form("solution2yesno&quot&"','"&_
request.form("solution2date&quot&"','"&_
replace (solution2, "'", "''&quot&"','"&_
request.form("sol2suby&quot&"','"&_
request.form("solution3yesno&quot&"','"&_
request.form("solution3date&quot&"','"&_
replace (solution3, "'", "''&quot&"','"&_
request.form("sol3suby&quot&"','"&_
request.form("solution4yesno&quot&"','"&_
request.form("solution4date&quot&"','"&_
request.form("solution4&quot&"','"&_
request.form("sol4suby&quot&"','"&_
request.form("solution5yesno&quot&"','"&_
request.form("solution5date&quot&"','"&_
request.form("solution5&quot&"','"&_
request.form("sol5suby&quot&"')"

 

[onpnt]

replacing the values with hard coded values it works fine.
you need to do some debugging to track down this error really. don't use the request collection in the sql statement and declare variables for now. then debug them by reponse.writing them out. your not getting values somewhere and I can't see why the replace function would be causing it. unless I'm missing something simple.
eg: debug
Response.Write "Debug --> " & replace (problem, "'", "''&quot

also test the SQL for proper formatting. a missing '," may do it without a error.
Check the first couple FAQ in this forum for debugging procedures and help on syntax problems also

____________________________________________________
_{The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-2924}

http://www.onpntwebdesigns.com

 

[guineamation]

Thanks. The strange thing is that it works perfectly fine once or twice and then the variables seem to loose their content. After I wrote my previous mail, i've tested it again and even the variables that functioned before suddenly lost the strings. what could cause a variable to lose its content.

 

[DreXor]

reassigning the variable can cause it .. check for conditionals that might define or change the variable contents