Re: 2 /'s

2001-04-18 Thread Brandon Paolin

if you're using the old formurl2attributes custom tag, then you need to either specify 
the
full app url
(form action=http://www.domain.com/index.cfm)
or
set the displaybase to "no" in the custom tag
()
or
get the new formurl2attributes tag!

- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 11:35 AM
Subject: RE: 2 /'s


>
> the form returns the page i want but with an unusual url
> all my locations are relative and i'm running it locally.  the results come back 
>under
>
> 127.0.0.1//index.cfm
>
> any ideas?
>
> 
> Contact
> We love feedback about our site and opinions on other sites.  Use the form below 
>to
tell us what you like about our site, service, or any other
> site or service for that matter.  We want to give you the best of the web and if we
haven't already done it or something like it, there's no doubt we
> can.
> 
> function validate(arg1){
>  if(!arg1.email.value || arg1.email.value==''){
>  alert("Please enter an email address");
>  arg1.email.focus();
>  return false;
>  }
> }
> 
> 
> Your Email:
> 
> 
> Message Body:
> 
> 
> 
>
>
>
>
> "Adkins, Randy" <[EMAIL PROTECTED]> on 04/18/2001 09:38:54 AM
>
> Please respond to [EMAIL PROTECTED]
>
> To:   CF-Talk <[EMAIL PROTECTED]>
> cc:
>
> Subject:  RE: 2 /'s
>
>
> Paste your form tag so we can isolate it for you
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 18, 2001 10:20 AM
> To: CF-Talk
> Subject: 2 /'s
>
>
> why does an additional / appear in the url after i submit a form?
>
> when i submit from 127.0.0.1/index.cfm?action=contact
> to
> index.cfm w/ 
>
> if get the page i want but it's under the url
> 127.0.0.1//index.cfm
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: previous/next in sql

2001-04-04 Thread Brandon Paolin

i can't use a cursor cause its a dynamic query,
and i couldn't have a sql "if" statement within the "where" clause, to check if a value
was 0 or not

something like:
where 0=0
if (@stateId<>0)
and stateId=@stateId

- Original Message -
From: "Russ Conway" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 3:38 PM
Subject: RE: previous/next in sql


> > alright, i'm trying to create a "previous/next" statement so that
> > my query only grabs 6 records at a time.
>
> How about using a cursor and submitting the ID of the last record processed
> as a parameter to the stored procedure? Then just loop through the results
> until you hit the ID passed to the procedure and return the next 6 rows.
>
> Russell Conway
> HallofSports.com, Inc.
> 351 West 22nd Street
> New York, NY 10011
> P (646) 638-2500
> F (646) 638-3444
> http://www.hallofsports.com
> .. . . where the legends live on
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



previous/next in sql

2001-04-04 Thread Brandon Paolin

alright, i'm trying to create a "previous/next" statement so that my query only grabs 
6 records at a time.

but first off, i have an order by statement that reads:

order by 
datediff(dd,expirationDate,getdate())/abs(datediff(dd,expirationDate,getdate())),businessName

so i can't just grab where the id field is greater than the last one outputted.

then i tried creating it in a cursor in sql, but its a dynamic query,
and i couldn't have a sql "if" statement within the "where" clause, to check if a 
value was 0 or not

something like:
where 0=0
if (@stateId<>0)
and stateId=@stateId


i might be missing something, or maybe someone has a better idea, but what i'd really 
like to do (if it can be done)
is grab 6 records, and within sql, be able to specify the row number of the outputted 
queryso then i can put where (row number) > 6
for the next set of records.




Brandon Paolin
Programmer
AVERICOM Communications
856-874-1133 ext. 321
1931 Olney Avenue * Suite 600
Cherry Hill, NJ 08003
http://www.avericom.com


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: custom CFERROR pages, what's your solution?

2001-01-29 Thread Brandon Paolin

for all your database querys, you can use try/catching

- Original Message -
From: "Greg Wolfinger" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 26, 2001 11:58 PM
Subject: Re: custom CFERROR pages, what's your solution?


> > what i do is create sites with no errors...then i never have to user
> > cferror.
>
> Until hackers do a DNS attack on your db and your db server overloads and
> choaks.
> - Original Message -
> From: "Brandon Paolin" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, January 26, 2001 4:30 PM
> Subject: Re: custom CFERROR pages, what's your solution?
>
>
> > what i do is create sites with no errors...then i never have to user
> > cferror.
> > :)
> >
> > - Original Message -
> > From: "Mike Amburn" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Friday, January 26, 2001 1:22 PM
> > Subject: custom CFERROR pages, what's your solution?
> >
> >
> > > using CFERROR, you can create a custom error page. however, you can't
> > > perform any CF logic within that page. if you had to include some
logic,
> > > the only method i can think of is to capture the error data in form
> > > inputs and use javascript to submit the form to another page that
> > > included the CF.
> > >
> > > has anyone else thought of a (better) method where you can use CFERROR
> > > but also present a page that uses CF logic?
> > >
> > > -mike
> > >
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: custom CFERROR pages, what's your solution?

2001-01-26 Thread Brandon Paolin

what i do is create sites with no errors...then i never have to user
cferror.
:)

- Original Message -
From: "Mike Amburn" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 26, 2001 1:22 PM
Subject: custom CFERROR pages, what's your solution?


> using CFERROR, you can create a custom error page. however, you can't
> perform any CF logic within that page. if you had to include some logic,
> the only method i can think of is to capture the error data in form
> inputs and use javascript to submit the form to another page that
> included the CF.
>
> has anyone else thought of a (better) method where you can use CFERROR
> but also present a page that uses CF logic?
>
> -mike
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: What Does OT Stand For?

2001-01-12 Thread Brandon Paolin

yeah, for example, this message subject should be:
OT: What Does OT Stand For?

- Original Message -
From: "Russel Madere" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 12, 2001 12:08 PM
Subject: RE: What Does OT Stand For?


> In the context of a mailing list or news group, it means Off Topic.
> Likewise, WOT means Way Off Topic, SOT means Slightly Off Topic, etc.
>
> By off topic, the post means he or she does not think it fully matches the
> purpose of the list (as defined by the charter or FAQ or whatever the
> creater published).  Sometimes an off topic thread can migrate on topic
> pretty quickly, or like what has often happened, it gets even further off
> topic until the list gets mad and flames the posters.
>
> Russel
>
> 
>   Russel Madere, Jr. Senior Web Developer
>   ICQ: 5446158   http://www.TurboSquid.com
>
> Some days you eat the bear; some days the bear eats you.
> 
>
>
> > -Original Message-
> > From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, January 12, 2001 09:32
> > To: CF-Talk
> > Subject: What Does OT Stand For?
> >
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CFerror and its

2001-01-12 Thread Brandon Paolin

you can't execute cf code on error pages.
what i do is put all the cfcode in hidden form variables, and onload submit
the form to another page that executes the cold fusion and emails me the
error code.

- Original Message -
From: "Andres" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 12, 2001 9:56 AM
Subject: CFerror and its


> Hello all,
> i have an application.cfm that calls a cf error tag like this:
>
>
>  name="myapp"
> clientmanagement="Yes"
> sessionmanagement="Yes"
> setclientcookies="Yes"
> sessiontimeout="#CreateTimeSpan(0, 0, mins_until_timeout, 0)#">
>
> 
>
> 
>
>
> The problem is that when a validation error occurs, the error page appears
> fine, but the CF inside the error template is not executed... it shown as
if
> it was a regular html page with all the cf showing.
>
> can someone tell me why this is happening and how i can correct the
> problem??
>
>
> thanks
>
> andres
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: TimeFormat Function

2001-01-11 Thread Brandon Paolin

#lcase(TimeFormat(now(),'tt'))#

- Original Message -
From: "Phoeun Pha" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 11, 2001 2:08 PM
Subject: TimeFormat Function


> you know the tt mask in the timeformat function?  well it always comes out
> Uppercase.  is there a mask that makes it come out lowercase?  I was
> thinking of using string functions to parse out the AM or PM and make them
> lowercase, but there must be a simpler way!
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists