Problems after update

[Gatorajc]

I am having a really annoying problem. I have a record in a database that I can see through an asp page just fine. I update it through another asp still fine it updates with no problems but when I go back to view that record I can not see the record even though it is in the database. Here is the code but I do not think its the code because it updates fine.

sqlString = "update dailydata"
sqlString = sqlString & " Set Dte = '" & datefield & "'"
sqlString = sqlString & ", tblDept_DeptID = '" & department & "'"
sqlString = sqlString & " WHERE DataID = '" & DataID & "'"

SET RS = Conn.Execute( sqlString )

Maybe my SQL is off. Doubt it but who knows.


AJ

 

[sleipnir214]

Output the query your string concatenations produce. Does it look right?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Gatorajc]

Looks fine

update dailydata Set Dte = '2004-7-17', tblDept_DeptID = 'Client/Server'WHERE DataID = '195'

Except for the quote around the 195 but I am not updating that because it is the PK

AJ

 

[Gatorajc]

Never mind.

Got this from someones signature. Applies here me being the user.

USER, n.: The word computer professionals use when they mean "idiot." - Dave Barry

I was inserting a character value into one of the colums that was an int and it was changing it to 0. Well when I ran my query which pulls from different tables there is no corresponding 0 which leaves me looking like an idiot.

Thanks for the time sleipnir214 got me thinking in another direction.

AJ