Access variable in other form

[potinenip]

Hi,<br><br>UserID is assigned by SQL server when each new user enters his data. I want to get the UserID assigned by server into another form .<br>I want to get the UserID into another form where i am inserting the details of AboutProperty.cfm in A table HomesOrLands. In Table HomesOrLands i have UserID as a field which can't be null.<br>So i have to get UserID from Sellers table and insert in HomesOrLands.<br>Can someone help me on this.<br>If i am not clear i can clarify my question again.&nbsp;&nbsp;<br><br>Praveen

 

[SnakeHollywood]

You need to select the record you have just inserted to get the value.<br>If you do this all inside a CFTRANSACTION then you will get the correct value.<br><br>&lt;cftransaction&gt;<br>&lt;cfquery&gt;<br>your insert query<br>&lt;/cfquery&gt;<br>&lt;cfquery name=&quot;blah&quot;&gt;<br>SELECT max(userID) as lastID<br>FROM table<br>&lt;/cfquery&gt;<br>&lt;/cftransaction&gt;<br><br>now you can pass this value to another page.<br> <p>Russ Michaels<br><a href=mailto:russ@satachi.com>russ@satachi.com</a><br><a href=

http://www.satachi.com>Satachi

Internet Development</a><br>For my personal book recommendations visit

http://www.satachi.com/books.html<br>

<br>

 

[potinenip]

Thanks for ur suggestion.