this sems like it should work but i just cant find the error, i keep getting is this
[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]
Too few parameters. Expected 1.
I checked the reserved db names but I just cant find it. I even did a standard db
insert
Hello Dave,
Are your sure your getting to the insert query? Can you orderby a column
that is not in your select query? I don't see any glaring issues with the
insert. 11 fields, 11 updates no missing quotes??
Kind Regards,
Mike Randolph
At 11:51 PM 5/29/2003 -0400, you wrote:
cfquery
this sems like it should work but i just cant find the error,
i keep getting is this
[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
Microsoft Access Driver] Too few parameters. Expected 1.
I checked the reserved db names but I just cant find it. I
even did a standard db
Hello Dave,
This error normally or historically would be a typo in on of the field
names. So if the other idea is WRONG, carefully check your field names.
Kind Regards,
Mike Randolph
At 11:51 PM 5/29/2003 -0400, you wrote:
this sems like it should work but i just cant find the error, i keep
caused by alias 'FRID' in query
definition's SELECT list.
- Original Message -
From: Mike Randolph [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, May 29, 2003 11:58 PM
Subject: Re: extra eyes on this insert
Hello Dave,
Are your sure your getting to the insert query? Can
: Re: extra eyes on this insert
Hello Dave,
This error normally or historically would be a typo in on of the field
names. So if the other idea is WRONG, carefully check your field names.
Kind Regards,
Mike Randolph
At 11:51 PM 5/29/2003 -0400, you wrote:
this sems like it should work
rmfly2
VENDORERRORCODE -3005
SQLSTATE HY000
- Original Message -
From: Dave Watts [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, May 30, 2003 12:07 AM
Subject: RE: extra eyes on this insert
this sems like it should work but i just cant find
PROTECTED]
Sent: Thursday, May 29, 2003 11:58 PM
Subject: Re: extra eyes on this insert
Hello Dave,
Are your sure your getting to the insert query? Can you orderby a column
that is not in your select query? I don't see any glaring issues with the
insert. 11 fields, 11 updates no missing
ok that fixes the circular error but i still get the other
- Original Message -
From: Mike Randolph [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, May 30, 2003 12:16 AM
Subject: Re: extra eyes on this insert
Hello Dave,
Try renaming ...the second fridto FFrid
Thanks all!
- Original Message -
From: Mike Randolph [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, May 30, 2003 12:16 AM
Subject: Re: extra eyes on this insert
Hello Dave,
Try renaming ...the second fridto FFrid they cant be the same name.
Cheers,
Mike
How about...
SELECT max(FRID) AS maxFRID FROM fr
-Original Message-
From: Dave Lyons [mailto:[EMAIL PROTECTED]
Sent: Friday, 30 May 2003 4:15 p.m.
To: CF-Talk
Subject: Re: extra eyes on this insert
this is what i get
Error Executing Database Query.
[MERANT
: Matthew Walker [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, May 30, 2003 12:17 AM
Subject: RE: extra eyes on this insert
How about...
SELECT max(FRID) AS maxFRID FROM fr
-Original Message-
From: Dave Lyons [mailto:[EMAIL PROTECTED]
Sent: Friday, 30 May 2003 4:15 p.m
: Friday, 30 May 2003 5:12 p.m.
To: CF-Talk
Subject: Re: extra eyes on this insert
yeah I didn't know that they had to be different names. In the example
that
I have it had them listed as the same names, grrr
but I got it to work.
this was actually for a site that I accidentally erased last
~ i used queryparam on this one and man can u tell a difference in speed!
I had no idea:)
- Original Message -
From: Matthew Walker [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, May 30, 2003 1:20 AM
Subject: RE: extra eyes on this insert
Man, that looks cold. There's ice
]
Sent: Friday, 30 May 2003 5:12 p.m.
To: CF-Talk
Subject: Re: extra eyes on this insert
yeah I didn't know that they had to be different names. In the example
that
I have it had them listed as the same names, grrr
but I got it to work.
this was actually for a site that I
]
Sent: Thursday, May 29, 2003 10:20 PM
Subject: RE: extra eyes on this insert
Man, that looks cold. There's ice floating on the water. BTW I wasn't
making
fun of your banner earlier with the I think there should be a
CF-programmers-struggling... comment. I was just reflecting on myself
16 matches
Mail list logo