this is what I got....
select Scope_Identity() as newRec;
I get this error
Microsoft][ODBC Microsoft Access Driver] Characters found after end of SQL statement
Iv tried different options, no semi colens, adding semi colons avter the values being added etc???
I am using an access database but we will be porting everything to SQL soon (I hope)
I've been searching for info on scope Identity() but coming up with very little....anymore clues on how to use it
I have to write a record to the database the I need a 100% surefire to grab the primary key and continue to my next page. where I will update that database based on my primary key and some extra gathered info.
If you select no - yes - no then you only go to technical support...you will collect more data on the Technical support page...then you will be forwarded to the finish.cfm page.
on the finish.cfm page there is a <textarea> box for you to reply with extra comments....then everytheing gets...
Ok...I must have brain freez here somewhere
I added this to my page
<cfparam name="session.question1" default="#form.question1#">
<cfparam name="session.question2" default="#form.question2#">
<cfparam name="session.question3" default="#form.question3#">
then this
<cfif session.question1 is...
this is what I am trying to do
first page I have 6 questions
the first 3 questions decide what other pages are displayed. it could be all 3 pages displayed or two or just one...
the other 3 questions are just basic info that I want to carry through the other aforementioned pages to the the...
I set my cookies on this page based on feedback form
<cfcookie name="question1" value="#form.question1#">
<cfcookie name="question2" value="#form.question2#">
<cfcookie name="question3" value="#form.question3#">
then on a subsequent page I try to access them
<cfif cookie.question2 is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.