RE: Case Sensitivity in SQL Queries

try this in your order by Select firstname, lastname, UPPER(lastname) AS ordName FROM ... ORDER BY ordName -or- this might even work Select . ORDER BY UPPER(LastName) HTH, Robert Hinojosa Senior WebDeveloper [EMAIL PROTECTED] www.hencie.com 972-671-0011 ext.284 -Original

RE: Passing hidden fields

there is a tag in the gallery called CF_formpass that will do what you want. Robert -Original Message- From: Roque,Carlos [mailto:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 11:32 AM To: CF-Talk Subject: Passing hidden fields I have a four page form with about 15 fields on each

RE: Interesting Java/CF Article

If you haven't played with it, I've found it is missing all the extensibility that CF has to offer. Especially in the lack of support for Custom Tags, RegEx's, WDDX, COM. Plus it lacks attributes on a whole slew of tags. Otherwise, its fun to play with. It's free. Robert -Original

RE: dynamically naming variables

cfset "product#id#" = aNumber Robert -Original Message- From: Jay Brushett [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 20, 2000 9:54 AM To: CF-Talk Subject: dynamically naming variables Hi, I need to use the Evaluate function to dynamically name variables in a cfloop.

RE: cfscript rules of thumb

Don't use CFSCRIPT for large pieces of code. Debugging inside a CFSCRIPT tag is horrible. You can use CFSCRIPT for setting more than 3 variables in a row. Much faster than cfsets. SWITCH/CASE Statements -- break works in CFSCRIPT. My two shiny nickels. Robert Hinojosa Senior WebDeveloper

RE: List w/ delims

I use a carraige return and line feed all the time as a delimiter. Why doesn't that break? Robert Hinojosa Senior WebDeveloper [EMAIL PROTECTED] www.hencie.com 972-671-0011 ext.284 -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000

RE: deallocate

So why doesn't this work. cfoutput#isStruct(variables)#/cfoutput I don't believe that the variables scope is actually a structure. I once read that you could connect to a COM object to access all variables, the same way that Studio's Debugger would connect to active variables. Robert Hinojosa

RE: CFFILE - writing a CF template REDUX

set value='Reset'/td/tr /table /cfoutput /body /html" cftry cffile action="WRITE" output="#r_HTML#" nameconflict="overwrite" file="#stForm.FormSaveLocation#" cfcatch type="Any" The File did not get written properly. cfoutput

RE: ? - /

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C05A48.7F825C2E Content-Type: text/plain; charset="iso-8859-1" How do you handle web statistics with that forma

RE: CSV-to-Query

r) /cfloop /cfif cfcatch type="any" cfabort showerror="There was a problem working with your .csv file, br ensure that you have created a .csv file with the following fields. br bEmailTo,FirstName,LastName/b br #cfcatch.message#" /cfcatch /cftry HTH,

RE: Display Files in a Dir

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C05408.D47EE472 Content-Type: text/plain; charset="iso-8859-1" Take a look at cfdirectory in any reference. Robert

RE: Exam

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C023FB.F287EB72 Content-Type: text/plain; charset="iso-8859-1" Can I get those rules? TIA, Robert Hinoj

RE: CF TEST

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C023FC.15EBD362 Content-Type: text/plain; charset="iso-8859-1" www.cfspot.com -Original Message- From: James Smith

RE: # rule? [CF-Talk]

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C02338.645D00B2 Content-Type: text/plain; charset="iso-8859-1" Read this

RE: [CF-Talk] OT: Subject lines

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C02349.EE023722 Content-Type: text/plain; charset="iso-8859-1" I prefer the [Cf-Talk] as the suffix. Robert -Original

RE: Verifying the existence of a file on the server

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C01F45.CE0B01EA Content-Type: text/plain; charset="iso-8859-1" cfset image = evaluate(DE("E:\PathToImage" ID ".jpg"))) cfif

RE: 2 hours from now -

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C01DC5.52FC58EA Content-Type: text/plain; charset="iso-8859-1" try this DateAdd(h,2,theDate) HTH, Robert -Original

RE: Numeric Field

t;mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A]/FONT BRFONT SIZE=3D2Sent: Monday, September 11, 2000 4:36 PM/FONT BRFONT SIZE=3D2To: [EMAIL PROTECTED]/FONT BRFONT SIZE=3D2Subject: Numeric Field/FONT /P BR PFONT SIZE=3D2How exactly would I write this query, my table name = being FOOD and

RE: Numeric Field

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C019CC.8AAEC54A Content-Type: text/plain; charset="iso-8859-1" Try This UPDATE Products

RE: Importing a text file

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C019D6.3AD9C07E Content-Type: text/plain; charset="iso-8859-1" use single quotes. #Replace('#f1_element#','"','','ALL')# HTH

RE: Replacing a value in the list form.fieldnames

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C019DD.E44CBCB8 Content-Type: text/plain; charset="iso-8859-1" cfset formField = Listgetat(Form.fieldnames, count) CFSET