Here is a question for people who have knowledge in Storedprocedures
and SQL 7.0 backing.

I am using CFSTOREDPROC and passing my variables into it without a problem.
My Stored Proc in SQL is using the Order by clause.

This does not work.. Any idea on another solution?
I have used the query analyzer and it stated Order By is not support by SQL.

What gives?


----- Original Message -----
From: "Dick Applebaum" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 25, 2000 9:26 AM
Subject: Re: Form Field Validation - No Spaces


> <cfif Len(Trim(Form.Field1))>
>    ...contains data
> <cfelse>
>    ... spaces only
> </cfif>
>
>
> At 8:13 AM -0500 5/25/2000, Andrew C. Davis wrote:
> >I have a form that has fields that, when validated, allow the user to
> >enter "spaces".  I want to be able to check for fields that contain only
> >spaces and then inform the user that they must enter text.  How do I do
> >this?
> >
> >Andrew C. Davis ([EMAIL PROTECTED])
> >TAMMIS Website Administrator / Systems Administrator
> >Metrica, Inc. * San Antonio, TX
>
>---------------------------------------------------------------------------
---
> >Archives: http://www.eGroups.com/list/cf-talk
> >To Unsubscribe visit
> >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal
> >k or send a message to [EMAIL PROTECTED] with
> >'unsubscribe' in the body.
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to