<div>
sorry, when i said &quot;developing a component,&quot; I meant a component that other developers could use... something you would post for download for instance that has to be DB independent.
</div>


sorry, when i said "developing a component," I meant a component that other developers could use... something you would post for download for instance that has to be DB independent.

<div>
Is this working in MySQL too.<br />
Can i make the insert, and on the same page get the art_id that was generated and than pass this with a session to the next page?
</div>


Is this working in MySQL too.
Can i make the insert, and on the same page get the art_id that was generated and than pass this with a session to the next page?

<div>
Thank you for your help.<br />
regards<br />
Panos
</div>


<div>
the full code for mySQL would be (note the last line of the cfquery):<br />
<br />
&lt;cfquery name=&quot;insertTest&quot; datasource=#dsn#&gt;<br />
INSERT into test1,test2<br />
VALUES ('#form.test1#','#form.tes<wbr />t2#');<br />
SELECT last_insert_id() AS newID<br />
&lt;/cfquery&gt;<br />
<br />
then you would do:<br />
&lt;cfset session.variableName = insertTest.newID /&gt;<br />
if you wanted it in a session.
</div>


the full code for mySQL would be (note the last line of the cfquery):

<cfquery name="insertTest" datasource=#dsn#>
INSERT into test1,test2
VALUES ('#form.test1#','#form.test2#');
SELECT last_insert_id() AS newID
</cfquery>

then you would do:
<cfset session.variableName = insertTest.newID />
if you wanted it in a session.

<div>
<div class="content wysiwyg-content">
Hello experts.<br />
I have a table with 3 columns<br />
art_ID (primary key)<br />
test1<br />
test2<br />
<br />
Now with a query:<br />
&lt;cfquery datasource=#dsn#&gt;<br />
INSERT into test1,test2<br />
VALUES ('#form.test1#','#form.tes<wbr />t2#')<br />
&lt;/cfquery&gt;<br />
&lt;cflocation url=&quot;Detail.cfm&quot;&gt;.<br />
To get the values in the detailpage i need to get the art_ID value from the that insert<br />
<br />
<br />

</div>
</div>


Hello experts.
I have a table with 3 columns
art_ID (primary key)
test1
test2

Now with a query:
<cfquery datasource=#dsn#>
INSERT into test1,test2
VALUES ('#form.test1#','#form.test2#')
</cfquery>
<cflocation url="Detail.cfm">.
To get the values in the detailpage i need to get the art_ID value from the that insert




After insert pass the value from the primary key in session to the next page

A web server refers to the software that helps to deliver web content that can be accessed either through the Internet or through an intranet. The primary function of a web server is to store, process and deliver web pages to clients. The communication between client and server takes place using the Hypertext Transfer Protocol (HTTP). The most common use of web servers is to host websites, but there are other uses such as gaming, data storage, running enterprise applications, handling email, FTP, etc.

Web Servers

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.