[WEB4LIB] An Employment app.

Jim Harold jharold at dec.cdie.org
Fri Apr 2 09:41:21 EST 1999


A co-worker offers some insight ....

>>> Beth  James 04/02/99 09:40AM >>>

If I am reading what he wrote correctly, he said that he was using CF Studio to configure an datasource.  This is incorrect.  You set up the datasource in your ODBC option under the control panel and then reference this datasource in your query calls in CF:

<CFQUERY NAME="QueryName" DATASOURCE="DSNName">
    SELECT * FROM TableName
</CFQUERY>

You use the query to get information from the database.  You must always set up your datasource in the ODBC option before you do anything with a database.

In order to get data into a database (after setting up your datasource); you set up your form normally and use a <CFINSERT> (there are other methods also) to insert your form data into your table.

<CFINSERT DATASOURCE="WebPages" TABLE="TableName">

Is this enough information???

Beth



More information about the Web4lib mailing list