database update issue

[Path9898]

greetings.
I am having an issue with a piece of code, I was hoping someone can show me where I am going wrong. Basically I select 9 rows of data out of a table that have the same item number, but each row has a unique GUIDs, then I loop through the data to display it on a webpage. This all works fine.

The issues comes when I try to submit all the data (changed or not) back into the table. My submit code is below


strcreative_id = Request.Form("c reative_id")
strcreative_run time = Request.Form("c reative_runtime ")
strcreative_sta te = Request.Form("c reative_state")
strcreative_tex t_data = Replace(Request .Form("creative _text_data"),"' ","''")
strcreative_tex t_effects = Request.Form("c reative_text_ef fects")
strcreative_ima ge_name = Request.Form("c reative_image_n ame")
strcreative_gui d = Request.Form("c reative_guid")

' Build our SQL String
strSQL = ""
strSQL = strSQL & "UPDATE tbl_advert_setu p_creatives "
strSQL = strSQL & "SET creative_runtim e ='" & strcreative_run time & "'"
strSQL = strSQL & ", "
strSQL = strSQL & "creative_s tate ='" & strcreative_sta te & "'"
strSQL = strSQL & ", "
strSQL = strSQL & "creative_text_ data ='" & strcreative_tex t_data & "'"
strSQL = strSQL & ", "
strSQL = strSQL & "creative_text_ effects ='" & strcreative_tex t_effects & "'"
strSQL = strSQL & ", "
strSQL = strSQL & "creative_image _name ='" & strcreative_ima ge_name & "'"
strSQL = strSQL & "Where creative_guid = '" & strcreative_gui d & "';"

Response.Write strSQL

%>


The Response.Write produces this:

UPDATE tbl_advert_setu p_creatives SET creative_runtim e ='30, 60, 23, 60, 240, 33, 90, 22, 60', creative_state ='1, 1, 0, 1, 1, 0, 1, 1', creative_text_d ata ='tires, today only!!, Buy some today...please. , 75006, Obamas Transition Chief., Everyone is reviewing can.', creative_text_e ffects ='Stretch, Stretch, Inset', creative_image_ name ='2.jpg, 3.jpg, 5.jpg, 1.jpg'While creative_guid = '{B53BA5B7-6971-4442-9A0F-83EAF27E2F0E}, {8E123F5C-25BB-4CCD-A443-77C9D0961002}, {53D1FB08-2998-49CB-8D78-D128FAAF6232}, {693BD709-C65D-438F-AC3F-817C849B2ECE}, {9C7B4C1E-A466-4854-BDCE-250661639490}, {27448802-E779-4AFE-A147-41410CEE81A9}, {FF4F7F87-1FB2-4902-8055-2F688920A014}, {8CBF7404-2CDC-42DC-9DE1-8AEDA0B148DB}, {4440412C-951C-46BF-8935-F401D850815B}, {BEF028CB-DAF3-470E-B18D-DD9806DD9B04}';

How do I get the data back into each specific row of my db? It is trying to stuff all 9 rows of data back into the first row. The creative_guid column is a unique identifier.
I guess I need some sort of update loop statement, but can’t figure it out. when i add "Do while not Rs.EOF" to the update (above strcreative_id = Request.Form("c reative_id")) it says "Operation is not allowed when the object is closed. " the RS is not closed as best as i can tell.

thanks for any help.

P

[Nicodemas]

What's being entered into the database was expected. If what you are seeing on the actual web page is different, there is a script between what you extract from the database and what you print to the response buffer that is removing that apostrophe - perhaps another replace()?