Recent content by offdarock

I realize now it wont work with access so I settled by using <cftransaction> and selext MAX()

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.

www.offdarock.com

oh....I just seen this tag for the first time today...Oh well....

it it possible to use the <cfregistry> to modify the registry then check for the modification befor allowing access

Actually I got it working about 6 pm today...thanks a million for your help....and drop by the site sometime.....

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...Now ya lost me.......

<form action="basicSurveyProcessor.cfm" method="post" name="continue" enctype="multipart/form-data"> <table width="775" border="0" cellspacing="0" cellpadding="0" align="center"> <tr bgcolor="#CCCCCC"> <td>Question</td> <td width="62" valign="top">Yes</td> <td width="58"...

yes

Wow, you explained it better than I could...lol...yes that exactly what Ia m doing

I already got it removed....still gets the error

Yes, I am using the values in several places...