sql error!! arghh!!

Results 1 to 2 of 2

Thread: sql error!! arghh!!

  1. #1
    mikesta Guest

    Default sql error!! arghh!!

    strRemote = request.servervariables("REMOTE_ADDR")<BR>strDateT ime = Now()<BR>strSQL = "INSERT INTO siteLogging VALUES (" <BR>strSQL = strSQL & strRemote & "," <BR>strSQL = strSQL & strDateTime & "," <BR>objConn.execute(strSQL)<BR><BR>my script gives me an error that the SQL string is invalid.. that it doesnt work.. what is the corrent syntax for asp-&#062;sql???<BR><BR>please help!

  2. #2
    Join Date
    Dec 1969

    Default RE: sql error!! arghh!!

    U need to specify column name for which u r inserting the values.<BR><BR>i.e. <BR><BR>insert into table_name(column_name1,column_name2) values(0,1)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts