RE: Problems verifying integers

Depending on the version of ColdFusion the OWASP ESAPI is included. You could use the isValidInteger function of that. It even lets you specify a minValue and maxValue. If you have CF8.01 or higher you have ESAPI. It may be an older version, but you can always upgrade the esapi as well by

Coldfusion MS acess question

Hi All - I am have a strange problem with a query which works directly on MS Access but fails when used inline in Coldfusion. I am using SELECT datepart(q, datecolumn), column1, column2 FROM table When I remove the datepart in coldfusion, it works fine.

Re: Coldfusion MS acess question

but fails when used inline in Coldfusion. Please define fails. - No record returned? - wrong data? - error thrown? ~| Order the Adobe Coldfusion Anthology now!

Re: Coldfusion MS acess question

but fails when used inline   Can you elaborate on fails?  Is the cfquery is throwing an error? If so post the full error message ~| Order the Adobe Coldfusion Anthology now!

Re: Coldfusion MS acess question

datepart(q, datecolumn), column1, column2 It might be that the query has no name for the datepart column. Try datepart(q, datecolumn) AS quarter, column1, column2 ~| Order the Adobe Coldfusion Anthology now!

Re: Coldfusion MS acess question

datepart(q, datecolumn), column1, column2 It might be that the query has no name for the datepart column. Try datepart(q, datecolumn) AS quarter, column1, column2 The error says Too few parameters. Expected 1. I did use an alias for the column, but it does not help

Re: Coldfusion MS acess question

Did you verify the column name is correct? Any difference if you use single quotes instead of double?     ie  datePart( 'q' , theColumnName ~| Order the Adobe Coldfusion Anthology now!

RE: Coldfusion MS acess question

datepart(q, datecolumn) AS quarter, column1, column2 Did you verify the datecolumn is a properly defined as a date field in the data base and does not have 'null' values? Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P :

Re: Coldfusion MS acess question

Too few parameters. Expected 1 This is supposed to mean that one of le column names is not found in the table. Why don't you post the whole query here? ~| Order the Adobe Coldfusion Anthology now!

Re: Coldfusion MS acess question

Too few parameters. Expected 1 This is supposed to mean that one of le column names is not found in the table. Why don't you post the whole query here? ~| Order the Adobe Coldfusion Anthology now!

Re: Coldfusion MS acess question

Too few parameters. Expected 1 This is supposed to mean that one of le column names is not found in the table. Why don't you post the whole query here? The query works fine in MS Access, but creating problems in ColdFusion. Instead I have decided to use ColdFusion quarter function to achieve

SHA 28 CHARACTER 40 CHARACTER CF8

Using Hash expression with SHA according to docs it is to return a 28 character string. When I run this, it returns a 40 character string. From Documentation. SHA: Generates a 28-character string using the Secure Hash Standard SHA-1 algorithm specified by Nation Institute of Standards and

Re: SHA 28 CHARACTER 40 CHARACTER CF8

I think that is a mistake.  The CF9 docs say 40 characters or 160-bit as hex http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7c52.htm ~| Order the Adobe Coldfusion Anthology now!

Re: SHA 28 CHARACTER 40 CHARACTER CF8

According to the comments here, 28 is the size in base64 (not the default encoding hex) http://cfquickdocs.com/cf7/?newVersion=1getDoc=Hash#Hash   -Leigh ~| Order the Adobe Coldfusion Anthology now!

RE: REST on Pre CF 10?

Sean Corfield's FW/1 can also do REST using URL Routes https://github.com/seancorfield/fw1 https://github.com/seancorfield/fw1/wiki/Developing-Applications-Manual (search for URL Route) andy -Original Message- From: Matt Quackenbush [mailto:quackfu...@gmail.com] Sent: Monday,