|
| |
|
|
drlaffoon
Posts: 21
Joined: 1/13/2006
Status: offline
 |
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
< Message edited by BeTheBall -- 1/14/2006 11:26:29 >
|
|
|
|
BeTheBall
Posts: 6359
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
drlaffoon
Posts: 21
Joined: 1/13/2006
Status: offline
|
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
Posts: 21
Joined: 1/13/2006
Status: offline
|
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
Posts: 21
Joined: 1/13/2006
Status: offline
|
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' )
| |
|
|
|
BeTheBall
Posts: 6359
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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?
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
drlaffoon
Posts: 21
Joined: 1/13/2006
Status: offline
|
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>
< Message edited by BeTheBall -- 1/14/2006 13:10:51 >
| |
|
|
|
BeTheBall
Posts: 6359
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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") &"' )"
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
drlaffoon
Posts: 21
Joined: 1/13/2006
Status: offline
|
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
| |
|
|
|
drlaffoon
Posts: 21
Joined: 1/13/2006
Status: offline
|
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
Posts: 6359
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
drlaffoon
Posts: 21
Joined: 1/13/2006
Status: offline
|
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
Posts: 21
Joined: 1/13/2006
Status: offline
|
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
Posts: 21
Joined: 1/13/2006
Status: offline
|
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
Posts: 6359
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
drlaffoon
Posts: 21
Joined: 1/13/2006
Status: offline
|
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
Posts: 21
Joined: 1/13/2006
Status: offline
|
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
Posts: 21
Joined: 1/13/2006
Status: offline
|
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
Posts: 6359
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
drlaffoon
Posts: 21
Joined: 1/13/2006
Status: offline
|
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
Posts: 21
Joined: 1/13/2006
Status: offline
|
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
| |
|
|
|
drlaffoon
Posts: 21
Joined: 1/13/2006
Status: offline
|
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
Posts: 21
Joined: 1/13/2006
Status: offline
|
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
Posts: 21
Joined: 1/13/2006
Status: offline
|
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
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 