INSERT INTO Not working

All Forums >> [Web Development] >> ASP and Database

Message

drlaffoon -> INSERT INTO Not working (1/13/2006 18:42:00)

When i use the following code i get a dwr operator error.

When I manual complete the SQL Statement with values it works.

fp_sQry="INSERT INTO ARCHIVE_SO ( OffenderID, LastName, FirstName, MiddleName, Address, AptNo, City, State, Zip, Offense, RegisterDate, OffenseDate, CntyOffen, Felony, Misdemeanor, VictimAge, Notes, Case_Sub, DOB, Photo, MatchType, Country, New, Longitude, Latitude, BOLongitude, BOLatitude, Display ) VALUES ( ::OffenderID:: , '::LastName::' , '::FirstName::' , '::MiddleName::' , '::Address::' , '::AptNo::' , '::City::' , '::State::' , '::Zip::' , '::Offense::' , '::RegisterDate::' , '::OffenseDate::' , '::CntyOffen::' , '::Felony::' , '::Misdemeanor::' , '::VictimAge::' , '::Notes::' , '::Case_Sub::' , '::DOB::' , '::Photo::' , '::MatchType::' , '::Country::' , '::New::' , ::Longitude:: , ::Latitude:: , ::BOLongitude:: , ::BOLatitude:: , '::Display::' )"
fp_sDefault="OffenderID=0&LastName=&FirstName=&MiddleName=&Address=&AptNo=&City=&State=&Zip=&Offense=&RegisterDate=&OffenseDate=&CntyOffen=&Felony=&Misdemeanor=&VictimAge=&Notes=&Case_Sub=&DOB=&Photo=&MatchType=&Country=&New=&Longitude=0&Latitude=0&BOLongitude=0&BOLatitude=0&Display=&archiveid=0"
fp_sNoRecords="Record updated in table."
fp_sDataConn="sexoffenders"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&archiveid=3&OffenderID=3&LastName=202&FirstName=202&MiddleName=202&Address=202&AptNo=202&City=202&State=202&Zip=202&Offense=202&RegisterDate=202&OffenseDate=202&CntyOffen=202&Felony=202&Misdemeanor=202&VictimAge=202&Notes=202&Case_Sub=202&DOB=202&Photo=202&MatchType=202&Country=202&New=202&Longitude=5&Latitude=5&BOLongitude=5&BOLatitude=5&Display=202&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID

trying to create a way to archive record in the database before someone edits them

Thanks for any help,

Dallas

BeTheBall -> RE: INSERT INTO Not working (1/13/2006 19:42:59)
Weclome to OutFront. See if the suggestions here are any help: http://www.frontpagewebmaster.com/m-175524/tm.htm Otherwise, please post the exact text of the error message you are seeing.

drlaffoon -> RE: INSERT INTO Not working (1/13/2006 21:57:58)
Database Results Wizard Error Unable to find operator in query string. Query string currently is INSERT INTO ARCHIVE_SO ( OffenderID, LastName, FirstName, MiddleName, Address, AptNo, City, State, Zip, Offense, RegisterDate, OffenseDate, CntyOffen, Felony, Misdemeanor, VictimAge, Notes, Case_Sub, DOB, Photo, MatchType, Country, New, Longitude, Latitude, BOLongitude, BOLatitude, Display ) VALUES ( ::OffenderID:: , '::LastName::' , '::FirstName::' , '::MiddleName::' , '::Address::' , '::AptNo::' , '::City::' , '::State::' , '::Zip::' , '::Offense::' , '::RegisterDate::' , '::OffenseDate::' , '::CntyOffen::' , '::Felony::' , '::Misdemeanor::' , '::VictimAge::' , '::Notes::' , '::Case_Sub::' , '::DOB::' , '::Photo::' , '::MatchType::' , '::Country::' , '::New::' , ::Longitude:: , ::Latitude:: , ::BOLongitude:: , ::BOLatitude:: , '::Display::' )

drlaffoon -> RE: INSERT INTO Not working (1/13/2006 21:59:54)
Thanks for the welcome sorry to have just pasted the code in without a thank you. Dallas Database Results Wizard Error Unable to find operator in query string. Query string currently is INSERT INTO ARCHIVE_SO ( OffenderID, LastName, FirstName, MiddleName, Address, AptNo, City, State, Zip, Offense, RegisterDate, OffenseDate, CntyOffen, Felony, Misdemeanor, VictimAge, Notes, Case_Sub, DOB, Photo, MatchType, Country, New, Longitude, Latitude, BOLongitude, BOLatitude, Display ) VALUES ( ::OffenderID:: , '::LastName::' , '::FirstName::' , '::MiddleName::' , '::Address::' , '::AptNo::' , '::City::' , '::State::' , '::Zip::' , '::Offense::' , '::RegisterDate::' , '::OffenseDate::' , '::CntyOffen::' , '::Felony::' , '::Misdemeanor::' , '::VictimAge::' , '::Notes::' , '::Case_Sub::' , '::DOB::' , '::Photo::' , '::MatchType::' , '::Country::' , '::New::' , ::Longitude:: , ::Latitude:: , ::BOLongitude:: , ::BOLatitude:: , '::Display::' )

drlaffoon -> RE: INSERT INTO Not working (1/13/2006 22:04:01)
When I write the query like this it will insert into the table, it just seems gag if I try to use the vars from another page via post INSERT INTO ARCHIVE_SO ( OffenderID, LastName, FirstName, MiddleName, Address, AptNo, City, State, Zip, Offense, RegisterDate, OffenseDate, CntyOffen, Felony, Misdemeanor, VictimAge, Notes, Case_Sub, DOB, Photo, MatchType, Country, New, Longitude, Latitude, BOLongitude, BOLatitude, Display ) VALUES ( 101, 'laffoon' , 'FirstName' , 'MiddleName' , 'Address' , 'AptNo' , 'City' , 'State' , 'Zip' , 'Offense' , 'RegisterDate' , 'OffenseDate' , 'CntyOffen' , 'Felony' , 'Misdemeanor' , 'VictimAge' , 'Notes' , 'Case_Sub' , 'DOB' , 'Photo' , 'MatchType' , 'Country' , 'New' , -39.2645, 10.2564, -19.13265, 10.2563, 'Display' )

Spooky -> RE: INSERT INTO Not working (1/13/2006 22:41:03)
New is a reserved word , so use [new]

BeTheBall -> RE: INSERT INTO Not working (1/14/2006 11:28:30)
quote: When I write the query like this it will insert into the table, it just seems gag if I try to use the vars from another page via post INSERT INTO ARCHIVE_SO ( OffenderID, LastName, FirstName, MiddleName, Address, AptNo, City, State, Zip, Offense, RegisterDate, OffenseDate, CntyOffen, Felony, Misdemeanor, VictimAge, Notes, Case_Sub, DOB, Photo, MatchType, Country, New, Longitude, Latitude, BOLongitude, BOLatitude, Display ) VALUES ( 101, 'laffoon' , 'FirstName' , 'MiddleName' , 'Address' , 'AptNo' , 'City' , 'State' , 'Zip' , 'Offense' , 'RegisterDate' , 'OffenseDate' , 'CntyOffen' , 'Felony' , 'Misdemeanor' , 'VictimAge' , 'Notes' , 'Case_Sub' , 'DOB' , 'Photo' , 'MatchType' , 'Country' , 'New' , -39.2645, 10.2564, -19.13265, 10.2563, 'Display' ) Wouldn't the above fail if the reserved word was the culprit?

Spooky -> RE: INSERT INTO Not working (1/14/2006 12:25:12)
Hmm - and those actual values (or different values?) as posted above will fail as form entries?

drlaffoon -> RE: INSERT INTO Not working (1/14/2006 12:42:05)

What I am trying to do is within the database editor of frontpage create a button that will allow users to archive a record into another table before they change the record and continue with the update query.

I did try and bracket [New] in the field list and this did not work however new is not bracketed on the page with the update query.

Thanks for continuing to helping below is the whole code for the insert

<!--webbot bot="DatabaseRegionStart" s-columnnames="archiveid,OffenderID,LastName,FirstName,MiddleName,Address,AptNo,City,State,Zip,Offense,RegisterDate,OffenseDate,CntyOffen,Felony,Misdemeanor,VictimAge,Notes,Case_Sub,DOB,Photo,MatchType,Country,New,Longitude,Latitude,BOLongitude,BOLatitude,Display" s-columntypes="3,3,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,5,5,5,5,202" s-dataconnection="sexoffenders" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="FALSE" b-listseparator="FALSE" i-ListFormat="0" b-makeform="FALSE" s-RecordSource s-displaycolumns s-criteria s-order s-sql="INSERT INTO ARCHIVE_SO ( OffenderID, LastName, FirstName, MiddleName, Address, AptNo, City, State, Zip, Offense, RegisterDate, OffenseDate, CntyOffen, Felony, Misdemeanor, VictimAge, Notes, Case_Sub, DOB, Photo, MatchType, Country, [New], Longitude, Latitude, BOLongitude, BOLatitude, Display ) VALUES ( ::OffenderID:: , '::LastName::' , '::FirstName::' , '::MiddleName::' , '::Address::' , '::AptNo::' , '::City::' , '::State::' , '::Zip::' , '::Offense::' , '::RegisterDate::' , '::OffenseDate::' , '::CntyOffen::' , '::Felony::' , '::Misdemeanor::' , '::VictimAge::' , '::Notes::' , '::Case_Sub::' , '::DOB::' , '::Photo::' , '::MatchType::' , '::Country::' , '::New::' , ::Longitude:: , ::Latitude:: , ::BOLongitude:: , ::BOLatitude:: , '::Display::' )" b-procedure="FALSE" clientside SuggestedExt="asp" s-DefaultFields="OffenderID=0&LastName=&FirstName=&MiddleName=&Address=&AptNo=&City=&State=&Zip=&Offense=&RegisterDate=&OffenseDate=&CntyOffen=&Felony=&Misdemeanor=&VictimAge=&Notes=&Case_Sub=&DOB=&Photo=&MatchType=&Country=&New=&Longitude=0&Latitude=0&BOLongitude=0&BOLatitude=0&Display=&archiveid=0" s-NoRecordsFound="Record updated in table." i-MaxRecords="1" i-GroupSize="0" u-dblib="../../../_fpclass/fpdblib.inc" u-dbrgn1="../../../_fpclass/fpdbrgn1.inc" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" Tag="BODY" startspan BOTID="0" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.</font></td></tr></table>" --><!--#include file="../../../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="INSERT INTO ARCHIVE_SO ( OffenderID, LastName, FirstName, MiddleName, Address, AptNo, City, State, Zip, Offense, RegisterDate, OffenseDate, CntyOffen, Felony, Misdemeanor, VictimAge, Notes, Case_Sub, DOB, Photo, MatchType, Country, [New], Longitude, Latitude, BOLongitude, BOLatitude, Display ) VALUES ( ::OffenderID:: , '::LastName::' , '::FirstName::' , '::MiddleName::' , '::Address::' , '::AptNo::' , '::City::' , '::State::' , '::Zip::' , '::Offense::' , '::RegisterDate::' , '::OffenseDate::' , '::CntyOffen::' , '::Felony::' , '::Misdemeanor::' , '::VictimAge::' , '::Notes::' , '::Case_Sub::' , '::DOB::' , '::Photo::' , '::MatchType::' , '::Country::' , '::New::' , ::Longitude:: , ::Latitude:: , ::BOLongitude:: , ::BOLatitude:: , '::Display::' )"
fp_sDefault="OffenderID=0&LastName=&FirstName=&MiddleName=&Address=&AptNo=&City=&State=&Zip=&Offense=&RegisterDate=&OffenseDate=&CntyOffen=&Felony=&Misdemeanor=&VictimAge=&Notes=&Case_Sub=&DOB=&Photo=&MatchType=&Country=&New=&Longitude=0&Latitude=0&BOLongitude=0&BOLatitude=0&Display=&archiveid=0"
fp_sNoRecords="Record updated in table."
fp_sDataConn="sexoffenders"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&archiveid=3&OffenderID=3&LastName=202&FirstName=202&MiddleName=202&Address=202&AptNo=202&City=202&State=202&Zip=202&Offense=202&RegisterDate=202&OffenseDate=202&CntyOffen=202&Felony=202&Misdemeanor=202&VictimAge=202&Notes=202&Case_Sub=202&DOB=202&Photo=202&MatchType=202&Country=202&New=202&Longitude=5&Latitude=5&BOLongitude=5&BOLatitude=5&Display=202&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="63361" -->

<p><!--webbot bot="PurpleText" PREVIEW="This is the UPDATE query." --></p>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside Tag="BODY" startspan preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" --><!--#include file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="9297" -->

</body>

</html>

BeTheBall -> RE: INSERT INTO Not working (1/14/2006 13:20:17)
Let's try this. First get rid of the extra FP code. We call this process the Spooky Diet and there is a handy macro for doing it. See here: http://www.frontpagewebmaster.com/m-279509/tm.htm One of the reasons to run the diet is to enable you to edit the red, asp code. Without the diet, FP will undo your changes. Once you have successfully dieted the code, try this as your INSERT statement: fp_sQry="INSERT INTO ARCHIVE_SO ( OffenderID, LastName, FirstName, MiddleName, Address, AptNo, City, State, Zip, Offense, RegisterDate, OffenseDate, CntyOffen, Felony, Misdemeanor, VictimAge, Notes, Case_Sub, DOB, Photo, MatchType, Country, [New], Longitude, Latitude, BOLongitude, BOLatitude, Display ) VALUES ( "& Request("OffenderID") &" , '"& Request("LastName") &"' , '"& Request("FirstName") &"' , '"& Request("MiddleName") &"' , '"& Request("Address") &"' , '"& Request("AptNo") &"' , '"& Request("City") &"' , '"& Request("State") &"' , '"& Request("Zip") &"' , '"& Request("Offense") &"' , '"& Request("RegisterDate") &"' , '"& Request("OffenseDate") &"' , '"& Request("CntyOffen") &"' , '"& Request("Felony") &"' , '"& Request("Misdemeanor") &"' , '"& Request("VictimAge") &"' , '"& Request("Notes") &"' , '"& Request("Case_Sub") &"' , '"& Request("DOB") &"' , '"& Request("Photo") &"' , '"& Request("MatchType") &"' , '"& Request("Country") &"' , '"& Request("New") &"' , "& Request("Longitude") &" , "& Request("Latitude") &" , "& Request("BOLongitude") &" , "& Request("BOLatitude") &" , '"& Request("Display") &"' )"

drlaffoon -> RE: INSERT INTO Not working (1/14/2006 19:10:44)
Database Results Wizard Error Description: Syntax error in INSERT INTO statement. Number: -2147217900 (0x80040E14) Source: Microsoft JET Database Engine This is the error i'm getting now. I'm going to go over the insert into statement a little better but I thought I would pass this back. Thanks for the macro however. this will make changing my site much simpler. Dallas

Spooky -> RE: INSERT INTO Not working (1/14/2006 20:09:03)
Imediately after that line ( as above ) do this fp_sQry=".........etc..... your line ..." ' new line response.write fp_sQry response.end

drlaffoon -> RE: INSERT INTO Not working (1/16/2006 10:21:52)
OK I think I see where this is going. I thought with a post it posted all form field data. Do I have to create hidden fields to pass this data for every fields I want to archive to another table? Thanks, Dallas

BeTheBall -> RE: INSERT INTO Not working (1/16/2006 10:25:48)
Yep. The form field values are only available to the page the form posts to. If you in turn do a second post, you would need to place the previous values back into form fields.

drlaffoon -> RE: INSERT INTO Not working (1/16/2006 10:28:10)
Forgot results of Spooky's request INSERT INTO ARCHIVE_SO ( OffenderID, LastName, FirstName, MiddleName, Address, AptNo, City, State, Zip, Offense, RegisterDate, OffenseDate, CntyOffen, Felony, Misdemeanor, VictimAge, Notes, Case_Sub, DOB, Photo, MatchType, Country, New, Longitude, Latitude, BOLongitude, BOLatitude, Display ) VALUES ( 2 , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , , , , , '' )

drlaffoon -> RE: INSERT INTO Not working (1/16/2006 10:36:16)
I have a details page with an edit button. What I would like to do is every time someone clicks the edit button it would archive the current record before taking them to the edit.asp. Right now I have just added a button to the edit.asp called archive that someone has to click to get the record to archive. Back to the query then. with what I would like to do with the auto archive do you have any suggestions about what pages sould post what information or can you point me in the general direction. Also I'm assuming the when I add all the form fields to the hidden post and remove the two lines Spooky had me add for reference that the query should work. Is that what it looks like to you? Thanks for all your help, Dallas

drlaffoon -> RE: INSERT INTO Not working (1/16/2006 11:52:51)
Query works! Thanks for the help. If you could point me in the direction of: I have a details.asp page with an edit button. What I would like to do is every time someone clicks the edit button it would run the archive.asp then bedirected to the edit.asp. The update.asp function already works fine. details.asp--->archive.asp--->edit.asp--->update.asp Thanks Dallas

BeTheBall -> RE: INSERT INTO Not working (1/16/2006 11:57:58)
Let me ask you this. What if the user clicks Edit, gets to the edit page and then changes his mind. Would you still want the record archived? I would assume no. So, I would put the hidden fields on the same page as the edit form. Populate them from the database just like you will to the visible form fields. Then when the form is submitted, submit to a third page where on you will insert two DRWs, one to perform the insert to Archives and another to update the record in the live table. Each of those two DRWs will require a custom query.

drlaffoon -> RE: INSERT INTO Not working (1/16/2006 15:45:26)
quote: ORIGINAL: BeTheBall Let me ask you this. What if the user clicks Edit, gets to the edit page and then changes his mind. Would you still want the record archived? I would assume no. So, I would put the hidden fields on the same page as the edit form. Populate them from the database just like you will to the visible form fields. Then when the form is submitted, submit to a third page where on you will insert two DRWs, one to perform the insert to Archives and another to update the record in the live table. Each of those two DRWs will require a custom query. I given this some thought and agree except I have a couple of problems I think. 1. The records from the main table are not in the archive table. so would setting it up your way only archive the changes that are made. I know that I can auto archive the system to get it started but there are also add.asp pages to add new offenders to the main table. 2. Yes I would like to not archive the record if no changes are made to the system. Currently the edit.asp page calls the update.asp page that has the query to update the main table. I assume the INSERT INTO query can be added to the statement.

drlaffoon -> RE: INSERT INTO Not working (1/16/2006 16:52:22)
Also for now until some structure can be worked out I would like the insert.asp to redirect back to edit.asp. for now there is just a button on edit.asp to archive the record. I am recieving an error on this statement: Response.Redirect("edit.asp?OffenderID=Request.Form("OffenderID")")

drlaffoon -> RE: INSERT INTO Not working (1/16/2006 17:27:35)
Figured out Redirect ended up like This: <% offid = Request.Form("OffenderID") Response.Redirect ("edit.asp?OffenderID="& offid) %> However there is no notice that the record was updated. Is there a way to show the "Record Archived" statement for 5 seconds before it redirects back to the edit page. I found the Delay(5) sample but it executes before the Record Archive is displayed. Thanks, Dallas

BeTheBall -> RE: INSERT INTO Not working (1/16/2006 19:24:53)
quote: 1. The records from the main table are not in the archive table. so would setting it up your way only archive the changes that are made. No. When you insert you are inserting the values from the hidden fields, not the visible ones. Therefore, it will be the unchanged data that is inserted into the archive table. Just add a second DRW to update.asp that will do the insert.

drlaffoon -> RE: INSERT INTO Not working (1/16/2006 19:35:24)
quote: ORIGINAL: BeTheBall quote: When you insert you are inserting the values from the hidden fields, not the visible ones. Therefore, it will be the unchanged data that is inserted into the archive table. Just add a second DRW to update.asp that will do the insert. Will the hidden field need different varnames? What would the code for just one hidden field look like on the edit page. also the details.asp page before the edit.asp page only passes the OffenderID to the edit page. Thanks for your help so far.

drlaffoon -> RE: INSERT INTO Not working (1/16/2006 21:32:48)
<% offid = Request.Form("OffenderID") %> <% MYMESSAGE = Server.URLEncode("Adding New Product....Please Wait") %> <% Response.Redirect ("delay.asp?DELAY_TIME=3&DELAY_MESSAGE=" & MYMESSAGE & "&REDIRECT_URL=edit.asp?OffenderID=& "offid"") %> This works when it is like below REDIRECT_URL=edit.asp?OffenderID=1") %> Need to use var ant thoughts

Spooky -> RE: INSERT INTO Not working (1/16/2006 21:54:32)
"&REDIRECT_URL=edit.asp?OffenderID="& offid) %>

drlaffoon -> RE: INSERT INTO Not working (1/17/2006 2:47:41)
Thanks Spooky now I just need to start working auto archiving only when a record is changed. please see the conversation below. Thanks again Dallas quote: quote: ORIGINAL: BeTheBall quote: When you insert you are inserting the values from the hidden fields, not the visible ones. Therefore, it will be the unchanged data that is inserted into the archive table. Just add a second DRW to update.asp that will do the insert. Will the hidden field need different varnames? What would the code for just one hidden field look like on the edit page. also the details.asp page before the edit.asp page only passes the OffenderID to the edit page. Thanks for your help so far.

drlaffoon -> RE: INSERT INTO Not working (1/17/2006 16:21:44)
If I wanted to add the date the record was archived to the database would I add it to this string? Under field names I would add DateArchived after Display: example Display, DateArchived) And where I'm not sure what will work is under values: Example: "& Request("Display") &" , '"& CurrentDate()&"' )" or Example: "& Request("Display") &" , '"& GetDate()&"' )" Should have probable thought of this before I got this far along. Thanks for getting me in the right direction Dallas fp_sQry="INSERT INTO ARCHIVE_SO ( OffenderID, LastName, FirstName, MiddleName, Address, AptNo, City, State, Zip, Offense, RegisterDate, OffenseDate, CntyOffen, Felony, Misdemeanor, VictimAge, Notes, Case_Sub, DOB, Photo, MatchType, Country, New, Longitude, Latitude, BOLongitude, BOLatitude, Display ) VALUES ( "& Request("OffenderID") &" , '"& Request("LastName") &"' , '"& Request("FirstName") &"' , '"& Request("MiddleName") &"' , '"& Request("Address") &"' , '"& Request("AptNo") &"' , '"& Request("City") &"' , '"& Request("State") &"' , '"& Request("Zip") &"' , '"& Request("Offense") &"' , '"& Request("RegisterDate") &"' , '"& Request("OffenseDate") &"' , '"& Request("CntyOffen") &"' , "& Request("Felony") &" , "& Request("Misdemeanor") &" , '"& Request("VictimAge") &"' , '"& Request("Notes") &"' , '"& Request("Case_Sub") &"' , '"& Request("DOB") &"' , '"& Request("Photo") &"' , '"& Request("MatchType") &"' , '"& Request("Country") &"' , '"& Request("New") &"' , "& Request("Longitude") &" , "& Request("Latitude") &" , "& Request("BOLongitude") &" , "& Request("BOLatitude") &" , '"& Request("Display") &"' )"

drlaffoon -> RE: INSERT INTO Not working (1/17/2006 17:23:19)
Never Mind I got it. added this to my query , '"& Request("Display") &"' , '"& ArchiveDate &"' )" and this to the code ArchiveDate = Date() Thanks

Page: [1]

0.1103516