update /insert help - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

update /insert help

Author

Topic

darkmooink
Starting Member

5 Posts

Posted - 2006-07-01 : 17:36:27

i have a tabel called dance and i have routieens that update and insert into the tabel but for some reason they dont work, can anyone help?
here is my code

<% 
   Set DBCon = Server.CreateObject("ADODB.Connection")
   DBCon.Provider = "sqloledb"
   ConStr = "Server=192.168.1.**;Database=chriss database;UID=****;PWD=************"
   
   DBCon.Open ConStr 
%>
<% SQLQuery = "UPDATE dance SET dn_title = '"&request("Dn_title")&"', dn_fdate = '"&request("month")&"/"&request("year")&" 01:01:01', dn_music_a = '"&request("Dn_music_a")&"', dn_music_s = '"&request("dn_music_s")&"', dn_type = '"&request("dn_type")&"', dn_count = '"&request("dn_count")&"', dn_startcount = '"&request("dn_startcount")&"', dn_wall = '"&request("dn_wall")&"', dn_tag = '"&request("dn_tag")&"', dn_restart = '"&request("dn_restart")&"', dn_on = '" & request("dy") & "/" & request("mont") & "/"&request("yr")&" "&request("hou")&":"&request("min")&":"&request("sec")&"', dn_graph = '"&request("dn_graph")&"', WHERE dn_id = "&request("id")&"" %>
<% response.write SQLQuery%> <!-- to check it works and it dose -->

nr
SQLTeam MVY

12543 Posts

Posted - 2006-07-01 : 23:31:04

Do you execute the statement?

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

darkmooink
Starting Member

5 Posts

Posted - 2006-07-03 : 10:27:00

thanks that is what i was missing
god im such an amature

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources