It doesn't pay as well and doesn't smell as good either :)
On 10/7/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
> LOL...better stick with that Horse Whisperer gig ;-) (sorry...I held off as
> long as I could...but it's Friday) ;-)
>
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Develop
LOL...better stick with that Horse Whisperer gig ;-) (sorry...I held off as
long as I could...but it's Friday) ;-)
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
we
Problem solved, thanks! Part of my problem was I'm forced to use a
remote manager that wasn't refreshing the files when saved on the
local machine, so my broken copy kept being uploaded rather than with
changes suggested by everyone who replied. I probably just learned 3
or 4 techniques to do it
> Still requiring the use of WDDX, though?
No because it would only be a simple data type if only using the column
value
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTEC
you can't use a query object as a value in an INSERT query
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
~
ectricedgesystems.com
> > > - Original Message -
> > > From: "Rob Redford" <[EMAIL PROTECTED]>
> > > To: "CF-Talk"
> > > Sent: Friday, October 07, 2005 11:41 AM
> > > Subject: Re: How Do I Get The Results of This Que
e Systems Group Inc.
> > phone: 250.480.0642
> > fax: 250.480.1264
> > cell: 250.920.8830
> > e-mail: [EMAIL PROTECTED]
> > web: www.electricedgesystems.com
> > - Original Message -----
> > From: "Rob Redford" <[EMAIL PROTECTED]>
> >
So far, nothing works and I continue to get the same exact error.
This is the code I used, and you can also see we are trying to read
this value from the cookie and then insert it into a different DB
table. If someone has a better way, I'm all ears. We're using CFMX
6.1, by the way.
___
Original Message -
> From: "Rob Redford" <[EMAIL PROTECTED]>
> To: "CF-Talk"
> Sent: Friday, October 07, 2005 11:41 AM
> Subject: Re: How Do I Get The Results of This Query Into a Cookie?
>
>
> >I tried this and it doesn't work, but am I
I tried this and it doesn't work, but am I even on the right track?
BEGIN TRANSACTION
UPDATE LinkShareMaxID SET LinkShareUID = LinkShareUID +
1
SELECT LinkShareUID FROM LinkShareMaxID
COMMIT TRANSACTION
1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
- Original Message -
From: "Rob Redford" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Friday, October 07, 2005 11:41 AM
Subject: Re: How Do I Get The Results of This Query Into a Coo
SEARIALIZE:
STICK IN COOKIE
DESERIALIZE
Ta daand sorry about thje wrong names for WDDX stuff...it's a tag and
not a set of functions (been a while)
Cheers
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1
I tried this and it doesn't work, but am I even on the right track?
BEGIN TRANSACTION
UPDATE LinkShareMaxID SET LinkShareUID = LinkShareUID +
1
SELECT LinkShareUID FROM LinkShareMaxID
COMMIT TRANSACTION
Never mind. Didn't see the SELECT portion of that query.
-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Friday, October 07, 2005 1:26 PM
To: CF-Talk
Subject: RE: How Do I Get The Results of This Query Into a Cookie?
Cookies can only contain strings,
OK...I read the posting, but I'm relatively new to this and I'm not
sure how to adapt the CF docs example for what I need. Can you give me
an example?
On 10/7/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
> >I was trying to dump the whole query in, since it only returns a
> > single record with a
WDDX is a quick solution to your
> problem, but WDDX is verbose.
Yep...it's a huge waste of space alrightmore verbose than XML!!
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [E
ssage-
From: Rob Redford [mailto:[EMAIL PROTECTED]
Sent: Friday, October 07, 2005 1:08 PM
To: CF-Talk
Subject: How Do I Get The Results of This Query Into a Cookie?
The reasons for this are not important, but I need to get the result
of the following query into a cookie:
, but WDDX is verbose.
TK
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Friday, October 07, 2005 2:17 PM
To: CF-Talk
Subject: Re: How Do I Get The Results of This Query Into a Cookie?
You need to take the result set from the query and serialize it using
CF2WDDX
>I was trying to dump the whole query in, since it only returns a
> single record with a single field. What's the best way to handle it
> in that case?
see my posting...trust me ;-)
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.06
I was trying to dump the whole query in, since it only returns a
single record with a single field. What's the best way to handle it
in that case?
On 10/7/05, Charlie Griefer <[EMAIL PROTECTED]> wrote:
> what's the code you're using to create the cookie?
>
> if you're trying to dump the whole que
You need to take the result set from the query and serialize it using
CF2WDDX and stick the serialized packet in the value of the cookie (you'll
need to use WDDX2CF to de-serialize and read it later). Note that there are
limits to how much data you can stuff in a cookieso if it's more than
what's the code you're using to create the cookie?
if you're trying to dump the whole query object into a cookie, won't
work. regardless of whether or not there's only 1 record/1 column
returned, a query is still a complex object.
On 10/7/05, Rob Redford <[EMAIL PROTECTED]> wrote:
> The reasons
>The results of the query (I thought) return a simple integer, but I
>get the following error message:
>
>
>Complex object types cannot be converted to simple values.
I think it would return a resultset that should be captured by cfprocresult as
a query object. A
The reasons for this are not important, but I need to get the result
of the following query into a cookie:
BEGIN TRANSACTION
UPDATE LinkShareMaxID SET LinkShareUID = LinkShareUID + 1
SELECT LinkShareUID FROM LinkShareMaxID
COMMIT TRANSACTION
The results of
24 matches
Mail list logo