DateSent = "Now()"
er, won't that insert the string "Now()" into your db?
Why not use a date field in your DB?
On 25/11/06, Will Tomlinson <[EMAIL PROTECTED]> wrote:
>
> > DateSent = "Now()"
> And you might also think about using CreateODBCDate() for this.
>
> Will
>
>
~
> DateSent = "Now()"
I think I figured it out, or at least it works. Maybe someone can tell me if
I am right.
In the invocation of the function I had it like...
I changed it to
Doug
- Original Message -
From: "Doug Brown" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Saturday, November 25, 2006 2:28
thanks dave.
but I got it...it was earlier on in the code :)
dummy me.
-Original Message-
From: Dave Francis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 18, 2004 10:49 AM
To: CF-Talk
Subject: RE: what am I doing wrong (#'s question)
Did you try separating out request.nextR
Did you try separating out request.nextRecord?
ie #request.nextRecord# then you'll know if it's
the index or the data
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 18, 2004 10:13 AM
To: CF-Talk
Subject: RE: what am I doing wrong (#&
thanks ben.
read my last post.
it was, as I said, a brain fart.
thanks!
tony
-Original Message-
From: Ben Doom [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 18, 2004 10:25 AM
To: CF-Talk
Subject: Re: what am I doing wrong (#'s question)
Does it error the first time through the
Does it error the first time through the loop? Or after a while?
How is i generated?
What is the specific error generated?
--Ben Doom
Tony Weeg wrote:
>
>
>
> #get.yourNameHere[i]#
>
>
>
> still gives me same error.
>
> so, its not the #get.yourNameHere[i]#
>
>
> l
Tony Weeg wrote:
>
>
>
> #get.yourNameHere[i]#
>
>
>
> still gives me same error.
>
> so, its not the #get.yourNameHere[i]#
>
>
> line, it's the other part.
Ok there's nothing wrong in this bit of code. Like Phil just asked, can
you post some more code and the whole of
man.
ill shut up.
as I said, brain fart.
it was something else, a line or two up :)
hee.
cya.
good Tuesday.
later.
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 18, 2004 10:16 AM
To: CF-Talk
Subject: RE: what am I doing wrong (#'s que
TED]
> Sent: Tuesday, May 18, 2004 10:07 AM
> To: CF-Talk
> Subject: RE: what am I doing wrong (#'s question)
>
> Did you dump get??
>
> > -Original Message-
> > From: Tony Weeg [mailto:[EMAIL PROTECTED]
> > Sent: dinsdag 18 mei 2004 15:59
> &
didn't think so.
so, do I need some " (Apostrophe's) there or something?
tony
-Original Message-
From: Philip Arnold [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 18, 2004 10:20 AM
To: CF-Talk
Subject: RE: what am I doing wrong (#'s question)
> From: Tony
> From: Tony Weeg
>
> just need the correct poundage for the
> get.companyIdNumber[request.nextRecord]
>
> to parse right.
Your # usage is correct on that line
Since it's within a CFIF, then you don't need any at all
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[U
CF-Talk
Subject: Re: what am I doing wrong (#'s question)
>
> #get.yournamehere#
Don't you need an array referent for get.yournamehere[]?
--Ben Doom
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Can you post more of your code?
Need to see if your look is going "too far"
> -Original Message-
> From: Tony Weeg
>
> what the heck am I doing wrong?
>
> brain fart on the:
>
> get.companyIdNumber[request.nextRecord]
>
> part of this...
>
>
>
>
> get.companyIdNumber[request.nextR
yes.
but im good on that...
just need the correct poundage for the
get.companyIdNumber[request.nextRecord]
to parse right.
that's all.
tw
-Original Message-
From: Ben Doom [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 18, 2004 10:09 AM
To: CF-Talk
Subject: Re: what am I doing
Original Message:
> From: "Tony Weeg"
> #get.yournamehere#
As someone already suggested, it's probably this line. You're not telling which row you're accessing "get.yournamehere" from.
(and, also as suggested, close your option tag :) )
Scott
---
Scott Brady
http://w
ascal Peters [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 18, 2004 10:07 AM
To: CF-Talk
Subject: RE: what am I doing wrong (#'s question)
Did you dump get??
> -Original Message-
> From: Tony Weeg [mailto:[EMAIL PROTECTED]
> Sent: dinsdag 18 mei 2004 15:59
> To: CF-Tal
>
> #get.yournamehere#
Don't you need an array referent for get.yournamehere[]?
--Ben Doom
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Did you dump get??
> -Original Message-
> From: Tony Weeg [mailto:[EMAIL PROTECTED]
> Sent: dinsdag 18 mei 2004 15:59
> To: CF-Talk
> Subject: what am I doing wrong (#'s question)
>
> what the heck am I doing wrong?
>
> brain fart on the:
>
> get.companyIdNumber[request.nextRecord]
>
WHOOHOO!!! that did the trick Thanks a bunch!
EP!
- Original Message -
From: "Craig Dudley" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 21, 2003 9:41 AM
Subject: RE: What am I doing WRONG!?!?!
It is most likely long t
It is most likely long text retrieval option in the data source setup.
Go into cf administrator and edit the data source.
I had this issue the 1st time I upgraded a Cf5 box to MX, none of them
access data sources would retrieve memo text fields.
Fortunately, it only takes 2 seconds to fix.
-
check your ODBC drivers. make sure you have the latest ones... especially since you
upgraded to MX where JDBC is now an issue.
hth,
mike
-Original Message-
From: Ernie Pena [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 10:01 AM
To: CF-Talk
Subject: What am I doing WRONG!?!
Never mind, figured it out..
thanks
DB
- Original Message -
From: "Douglas L. Brown" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 12, 2001 8:05 PM
Subject: What am I doing wrong here?
> I am trying to populate the ID field of this table with t
Conferring w/ Justin and "Stolen" from Mike Dinowitz's HOF style guide:
Code - There are a number of code issues that should be examined. Most of
them have to be written up in separate articles due to the depth of
information. Until these articles are out, here's the basics.
Every app should have
> names, etc., when setting them in the Application.cfm file? Is it
> or ? Judging by the responses, I would assume that
The best way is to something like
.
.
.
~Justin MacCarthy
---
> I'm not sure .. anyone else have an opinion?
Since it was fairly easy to do - I ran loads of timing tests on the
difference between CFSet and CFParam.
CFParam runs about 1.1-1.2 times slower than a CFSet - BUT as has been
mentioned, using Application scoping speeds up the access loads - it's j
This whole thread is getting a little off the orginal question, which was,
sort of, what's the best way set 'constant' variables, such as DSNs, company
names, etc., when setting them in the Application.cfm file? Is it
or ? Judging by the responses, I would assume that is
faster, but it seams a
Todd,
>
> Any idea which is faster?
>
CFSET is faster of course, but i think that you'll find that cfparam is
faster than :
> > The flags
> > could be stored in a fast access location rather than a variable look
> up/variable verification in memory somewhere.
>
> Such as?
>
I think y
al whitepapers could be found on CF ?)
Best regards always,
Nelson
>
> Todd Ashworth
>
> > Todd Ashworth wrote:
> >
> > > I'm not sure .. anyone else have an opinion?
> > >
> > > Todd Ashworth
> > >
> > > - Original Messag
AIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Tuesday, July 04, 2000 7:46 AM
> > Subject: Re: What am I doing wrong?
> >
> > > Hi Todd,
> > >
> > > >If you use in the Application.cfm file, the gets
executed
> > > >
;
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, July 04, 2000 7:46 AM
> Subject: Re: What am I doing wrong?
>
> > Hi Todd,
> >
> > >If you use in the Application.cfm file, the gets executed
> > >every time a page is loaded, regardless if the variable already
I'm not sure .. anyone else have an opinion?
Todd Ashworth
- Original Message -
From: Kym Kovan <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 04, 2000 7:46 AM
Subject: Re: What am I doing wrong?
> Hi Todd,
>
> >If you use in the Ap
Hi Todd,
>If you use in the Application.cfm file, the gets executed
>every time a page is loaded, regardless if the variable already has its
>value or not. If you use default="mydsn">, the variable is only set if it doesn't already exist. I
>would guess this provides a slight performance incr
y
add up under heavy use.
Todd Ashworth
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 04, 2000 1:33 AM
Subject: Re: What am I doing wrong?
> >The ## around the DSN are valid, especially if the #dsn# is a variable
that
> &g
>The ## around the DSN are valid, especially if the #dsn# is a variable that
>contain the real DSN. This variable could be set just about anywhere, but
>is usually done in the Application.cfm (or other similar file) using the
>syntax:
>
I do the same, but I have always used .
Are there any
2000 1:15 AM
Subject: Re: What am I doing wrong?
> hello
>
> i am new in cold fusion programming but i check your code and in my
> opnion there is only one syntax error and taht is datasource="#dsn#"
> you can use without hash sign(#) e.g datasource="dsn" if you do t
hello
i am new in cold fusion programming but i check your code and in my
opnion there is only one syntax error and taht is datasource="#dsn#"
you can use without hash sign(#) e.g datasource="dsn" if you do this
your error meghit be remove.
Thanks
Farhan
-
m: Lisa Greenberg <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Monday, July 03, 2000 12:28 PM
Subject: Re: What am I doing wrong?-solved
>
>--D82B2777473DE9569A6A5589
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7
--D82B2777473DE9569A6A5589
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
I gather from your statement that it isn't legal to use a where clause. One solution I
thought of is to wrap this insert in a cfif statement. Thanks for your help
--Lisa
Jeff Bea
Lisa,
A semicolon is not needed in a CF SQL statement
and also you really have an SQL UPDATE cmd since
you have a WHERE clause. So, you either need to
change the INSERT to UPDATE or remove the WHERE
clause. Also, remove the ;
Jim
-Original Message-
From: Lisa Greenberg [mailto:[EMAI
You don't want to use a where clause in an insert statement, if you are
updating data, you want to use a update statement.
-Jeff
Lisa Greenberg wrote:
>
> I am trying to insert data into a table and get the
> following errors. I provided the semicolon, yet I still get
> the errors. What am I
41 matches
Mail list logo
