after insert the new record in the mdb file,how to get the ID number ?
<cfquery name="updata" datasource="test">
insert (name,name2) values('#name#','#name2#')
</cfquery>
<cfoutput query="u...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_11229477...
Zones:
Cold...Date Answered: 09/24/2000 Rating: 7.2 Views: 0
Using this bit of code, kindly supplied by KobiK, is there a way to extend the selection to other fields from the search form - i.e. to select by location, then price and then by number of rooms fo...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_20074867...
Zones:
Cold...Date Answered: 02/09/2001 Rating: 5.8 Views: 0
Anyone see anything wrong with the following:
<CFQUERY NAME="InsertintoBasket" DATASOURCE="dsn1">
INSERT INTO BasketItems (#form.UserID#,#form.SessionID#,#form.itemID#,#form.Quantity#,#Sub...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_20131214...
Zones:
Cold...Date Answered: 07/17/2003 Rating: 7.6 Views: 0
Hi.
I know how to do a join where there is a common field between two tables, like this:
<CFQUERY DATASOURCE="artsoutheast" name="getExhibition">
SELECT exhibitions.*, venue_information.*
FR...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_20236945...
Zones:
Cold...Date Answered: 12/04/2001 Rating: 6.8 Views: 0
I need to output certain data depending upon the week. I have a table named 'DateRange' with the following fields:
DateRange_ID
DateRangeBegin
DateRangeEnd
The DateRangeBegin is the startin...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_20241580...
Zones:
Cold...Date Answered: 01/11/2002 Rating: 7.0 Views: 0
I have used the Show tables and show databases
without any problems inside the cfquery tag from
non linux machines, running coldfusion mysql and IIS server.
But I have never seen the same code w...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_20551547...
Zones:
Cold...Date Answered: 03/21/2003 Rating: 5.6 Views: 0
Can one use aggregate functions in an sql query on a query with a dbtype query? Here is a my promblem code:
<CFQUERY name="getapps" DATASOURCE="gradstudy">
SELECT ID, decision, status
FR...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_20598829...
Zones:
Cold...Date Answered: 05/04/2004 Rating: 7.2 Views: 0
I'm building a search for the database and it's working OK,
but when I search for Coffee Filters, it brings up nothing.
When I search for coffee filters (matches the actual case of the file) , ...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_20611662...
Zones:
Cold...Date Answered: 12/29/2003 Rating: 3.6 Views: 0
Hi,
I'm very new to all this so maybe this is simple but I've searched this site and haven't found an answer.
I have a cfm page that adds users to a database. Obviously don't want duplicate u...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_20629015...
Zones:
Cold...Date Answered: 05/29/2003 Rating: 7.0 Views: 0
I'm trying to build a coldfusion database search form that searches for records based on a specific time stamp in a column called "Date" in a SQL server database. The time stamps look like 2003-09-...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_20761436...
Zones:
Cold...Date Answered: 05/06/2004 Rating: 8.4 Views: 0
