RE: [KCFusion] Finding country based off of e-mail address

2002-04-10 Thread Ryan Hartwich
For cheap and easy, using the ISO extensions will probably work reasonably well (most of the time). You could combine it with some web browser hints, like what language is supported by the browser. This is sent to the server in the header string. If you really need quality, there are online subs

[KCFusion] Finding country based off of e-mail address

2002-04-10 Thread Chris Stallo
Does anyone know if there is a way to determine based off of a person's e-mail address what country that e-mail address originated from? I've got the list of the ISO country names and thought about checking to see if the address ends in like .br for Brazil or .ar for Argentina, etc, but I wasn't

RE: [KCFusion] Query of query not working

2002-04-10 Thread Keith Purtell
Hmmm, a fancy SQL solution, eh? I've never tried that but it looks promising. Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipie

RE: [KCFusion] Query of query not working

2002-04-10 Thread Keith Purtell
That solved my problem. Thanks! Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privile

RE: [KCFusion] Query of query not working

2002-04-10 Thread Bakken, Kory J
Unless I am missing something, you're not inserting records into the previous query, hence your query should just be a normal query. -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 12:21 PM To: KCFusion (E-mail) Subject: [KCFusion] Query o

Re: [KCFusion] Query of query not working

2002-04-10 Thread Adaryl Wakefield
or how bout INSERT INTO DetailTable (Id, SeqId, Qty, InvId) SELECT Id, SeqId, Qty, InvId FROM WorkingTable WHERE Id = '#form.Id# > - Original Message - From: "Keith Purtell" <[EMAIL PROTECTED]> To: "KCFusion (E-mail)" <[EMAIL PROTECTED]> Sent: Wednesday, April 10, 2002 12:20 PM Subject:

RE: [KCFusion] Query of query not working

2002-04-10 Thread Greg . L . Gorman
Do you really need the query of query? Why not just cfloop over the query: INSERT INTO DetailTable (Id, SeqId, Qty, InvId) VALUES ('#GetRecs.Id#','#GetRecs.SeqId#','#GetRecs.Qty#','#GetRecs.InvId#')

[KCFusion] Query of query not working

2002-04-10 Thread Keith Purtell
Since we run CF5, I occasionally use the query-a-query feature. However the following code is not working. The first query runs just fine, but the query that follows either never runs or generates an error message "Insert not supported". As long as valid data is in the structure (query object) ret