I found an article which explained how to use "result" to get the last autonumber inserted into a database. This trick works in Coldfusion 8. It does not...
MySQL this time, but sometimes, I am using Access and would like to know how to do it then, too. Getting the max number of the id field seems risky in that two...
For MySQL try LAST_INSERT_ID() For Access.... try a different DB ;) There's no reason anyone should be using Access.. use MySQL or Postgres or Apache Derby or...
I've always did a select right after with a "when" used to make sure I have the users record and an ordered by id desc with a max rows of 1. Hasn't failed me...
While I definitely agree with you on that, sometimes our employers don't give us much of a choice. Eric _____ From: coldfusion-howto@yahoogroups.com ...
I have seen the use of an insert code and then you look where the insert code is to grab the id. Insert #insert_code# Select id Where insert code=#insert_code#...
The method I prefer is to use a named exclusive cflock tag to single-thread the insert and then get max. That way you don't have to worry if your select query...
Does anyone know how to create the option box on yahoo for mail, messenger, radio, etc. that is on the right side? If you roll over the mail for instance, it...
Hello, I have a new website I'm coding that I need some help on. Let me see if I can sum things up in a few points. 1. There's a large amount of code already...
Could the FORM variable used in the statement below have any problems when utilized in a heavily used multithreaded application? I am using a form post to...
That looks just fine and it's single-threading your session access but you want to increase your timeout. If it can't gain an exclusive lock on the session...
Hi All, We have urgent openings with Fortune 500 Company. *Requirement:* Coldfusion (Mumbai and Pune based candidates preffered) *Experience:* 2yrs *Location:*...
parul sinha
sinha.soni@...
Oct 8, 2008 2:53 pm
43767
Okay so you have this code that is supposed to count the characters in a textbox area, which I guess goes into a .cfc file and save it in the custom tags...
It sounds like he copied the UDF into the session scope (why?) and then it references the result of a query that was named "read". Something like: <cffunction...
I have a cf form where an email address is enered. If another address needs to be entered, they click a button and another input field popsup. I was given...
Thanks, I just put it out there as a component and then called it as a component and it works fine that way. I wasn't sure why he suggested "loading to a...
I have a form that submits to itself. My submit is the standard : <input type="submit" name="btnsubmit" value="Submit Your Order"> When the form is submitted,...
I have a form that submits to itself. My submit is the standard : <input type="submit" name="btnsubmit" value="Submit Your Order"> When the form is submitted,...
Use a hidden field instead. You can submit the page without ever using the submit button by putting your cursor inside a text field and hit the enter button....
Hello, I have a product table with multiple rows of similar products but with different prices. product table fields: brand, model, saleprice ... acer...
select p.brand, p.model, p.saleprice from product p where p.saleprice=(select max(saleprice) from product where brand=p.brand and model=p.model) -John ... ...
Thanks John. Just tried using your query. I have 20000 rows of data and the page is timing out. SB ... From: John Bartlett To: coldfusion-howto@yahoogroups.com...
You'll need to create indexes on your fields. ... From: "SB" <srimantab@...> To: <coldfusion-howto@yahoogroups.com> Sent: Monday, October 13, 2008 1:23...
Got it to work now! Thanks John ... From: SB To: coldfusion-howto@yahoogroups.com Sent: Monday, October 13, 2008 9:23 PM Subject: Re: [coldfusion-howto] Help...
Got it to work! Thanks. ... From: John Bartlett To: coldfusion-howto@yahoogroups.com Sent: Monday, October 13, 2008 9:32 PM Subject: Re: [coldfusion-howto]...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
