Dissappearance of Query Variables

2002-09-03 Thread Jordon Saardchit 

Ok, this get even wierder.  I have a resultset that returns 1 record.  When
dumping the query, I see all the fields and the correct values, but now I
get an UNDEFINED ELEMENT on queryname.RecordCount.  Anyone else see any
strange stuff with cfmx and queries?

Jordon

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Referencing Query Object

2002-09-03 Thread Jordon Saardchit 


{call procedure( #argument1#, #argument2#, #argument3# )}





Source above... its a simple no brainer which works on older versions of CF
using the same datasource.  I've double checked the result set from the over
and over again.  I can't figure it out.  Here is the Error I recieve:

Error Occurred While Processing Request
Element RETURNID is undefined in NEWQUERY.

-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 03, 2002 5:14 PM
To: CF-Talk
Subject: Re: Referencing Query Object


> Has anyone seen anything funky when reference elements in
> query objects
> using stored procs, MSSQL 2000?  I've double checked the
> result set numerous
> times, and verified the field i'm referencing is indeed
> returned, however
> everytime I try to reference the field in CF, I get an
> undefined element
> error?  Any help would be much appreciated it.

I'd have to see the cf code to really offer helpful advice...

Did you recently upgrade to MX?
And are you using  or  ?


Isaac
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Referencing Query Object

2002-09-03 Thread Jordon Saardchit 

Has anyone seen anything funky when reference elements in query objects
using stored procs, MSSQL 2000?  I've double checked the result set numerous
times, and verified the field i'm referencing is indeed returned, however
everytime I try to reference the field in CF, I get an undefined element
error?  Any help would be much appreciated it.

Jordon

__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF & Palm PQAs

2000-06-26 Thread Jordon Saardchit 

Are you using and Coldfusion style loops to build content in your files???
If so, then remember you are building strings of source which will
dramatically increase filesize (pending on the size of the loop).  Example
being creating a bunch of  tags from a query result set.  File saved
will be MUCH smaller than the file read.

-Original Message-
From: Bryan Batchelder [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 26, 2000 10:48 AM
To: '[EMAIL PROTECTED]'
Subject: CF & Palm PQAs


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01BFDF96.9EAB1530
Content-Type: text/plain;
charset="iso-8859-1"

I am using CF to write the server side portions of a palm PQA (basically a
small web app).  Right now I am trying to optimize some pages and here is
what happens:

1.  I run the requested page in internet explorer.  I save it to a
file.  I then load this static page in the palm web clipping app and it is
903 bytes.

2.  When I run the requested (dynamic) page through the web clipping
app, it is almost twice as large.1600 bytes.  These pages are identical
as far as the end result output!

I am keeping in mind that the proxy server that Palm.net uses does
do compressionso is there any reason to think that a page served from CF
can't be compressed whereas a static page could?

I even tried renaming the static page with a .cfm and putting some
simple 's in there to see if it makes a differenceand it
doesn'tstill much smaller than the dynamic version.

The output from the dynamic page matches perfectly with the static
pagejust when loaded in the palm they are wildly different..


This is a big deal since the PalmVII only does ~2 kbps!

any help would be greatly appreciated

--Bryan


Bryan D. Batchelder   Work: 813-935-7100
Palm/Internet Developer   Home: 727-547-1322

ConnectWise, Inc. (www.ConnectWise.com)
2803 West Busch Blvd, Suite 204
Tampa, FL 33618


--_=_NextPart_001_01BFDF96.9EAB1530
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






CF & Palm PQAs



I am using CF to write the server side portions of a =
palm PQA (basically a small web app).  Right now I am trying to =
optimize some pages and here is what happens:

    1.  I =
run the requested page in internet explorer.  I save it to a =
file.  I then load this static page in the palm web clipping app =
and it is 903 bytes.

    2.  =
When I run the requested (dynamic) page through the web clipping app, =
it is almost twice as large.1600 bytes.  These pages are =
identical as far as the end result output!

    I am =
keeping in mind that the proxy server that Palm.net uses does do =
compressionso is there any reason to think that a page served from =
CF can't be compressed whereas a static page could?

    I even =
tried renaming the static page with a .cfm and putting some simple =
's in there to see if it makes a differenceand it =
doesn'tstill much smaller than the dynamic version.

    The output =
from the dynamic page matches perfectly with the static pagejust =
when loaded in the palm they are wildly different..


This is a big deal since the PalmVII only does ~2 =
kbps!


any help would be greatly appreciated


--Bryan



Bryan D. =
Batchelder   Work: =
813-935-7100
Palm/Internet Developer   Home: =
727-547-1322

ConnectWise, Inc. (www.ConnectWise.com)
2803 West Busch Blvd, Suite 204
Tampa, FL 33618





--_=_NextPart_001_01BFDF96.9EAB1530--

--
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.

CF/MS SQL Wierd Errod

2000-06-06 Thread Jordon Saardchit 

We're having a very strange error with one of our servers here, and we can't
quite seem to figure it out.  We have CF server 4.01 running with MS SQL
Server 7 (running on same server).  Every time we run a query through an
ODBC DSN setup through CF Admin, the server hits 100% CPU usage and will not
let go until we shutdown the CF service.  When we restart CF, we can hit CF
templates with no problems as long as there is no database activity.  Wierd
thing is, we change the same exact DSN to point to a different SQL server
(mirror of the one we're trying to use) and everything works fine, which
leads to possible DB corruption.  However, our DBA ran every diagnostic tool
he could and found no problems with the DB on our original server, so we are
at a loss for words.  Any ideas anyone? We need some resolution on this one
ASAP.  Thanks in advance.


-Jordon


--
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.

RE: WAP and WML...

2000-04-24 Thread Jordon Saardchit 

well, at the risk of sounding like a huge sales pitch,  the go2online.com
wireless site is done in coldfusion. www.go2online.com on yer wireless
phone.

-Jordon


-Original Message-
From: Gregory Weiss [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 24, 2000 8:49 AM
To: '[EMAIL PROTECTED]'
Subject: RE: WAP and WML...


Do either of you guys or anyone else have a list of good WAP/WML sites,
using or not using Cold Fusion.  I'd love to learn more about this
technology, and its obviously going to be important to everyone else soon as
well.  I'd like to make the first contribution:

http://www.anywhereyougo.com
http://www.bluetooth.com

These are excellent places to start, and obviously, any wireless
carrier/manufacturer is good as well (Nokia, Ericsson, Qualcomm, Motorola,
etc..)

Look forward to hearing from everyone.

Gregory L. Weiss
Web Development Project Leader
Trapezoid, Inc.
4107 Laguna Street
Coral Gables, Florida 33146
(305) 442-8060 x230
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>


-Original Message-----
From: Jordon Saardchit [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 13, 2000 2:59 PM
To: [EMAIL PROTECTED]
Subject: RE: WAP and WML...


nokia has a development SDK for WAP Applications as well.  You can try that
one too.

Jordon

-Original Message-
From: Ian Lurie [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 13, 2000 10:08 AM
To: '[EMAIL PROTECTED]'
Subject: WAP and WML...


I'm putting together a WML/email application using CF, and I've got a
question about compatability -

I'm using the Phone.com developer's kit and SDK to test my stuff. How do I
know if this app will work on phones that don't use Phone.com's service? Is
there a more generic SDK out there I can use?

May all be stupid questions, but thought I'd check...

TIA,

Ian Lurie

Portent Interactive
http://www.portentinteractive.com
Process, Design, Content

Market Matrix
http://www.marketmatrix.com
Secure Commerce for Your Business

Working together to create powerful, usable web solutions.

--
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.

--
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.

RE: How do I carry an Array over to another page? - HELP!!!!

2000-04-20 Thread Jordon Saardchit 

Pop the array into a Structure, serialize the structure with CFWDDX and pass
the WDDX packet to your next page.  Then deserialize the WDDXPacket on the
next page and voila.  You have your array.

-Jordon

-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 20, 2000 8:42 AM
To: CF-Talk
Subject: How do I carry an Array over to another page? - HELP


I have created the shipping methods for line items in Able Commerce Builder
and am trying to carry my array over to my next page.  Any ideas on what I
need to do?


   








When I come back from this Include, I can still see the array by telling it
to #Shipping_Cost_Array[1][1] for instance.  However when I go to
the next template.  It tells me the folowing error:

Error resolving parameter SHIPPING_COST_ARRAY

ColdFusion was unable to determine the value of the parameter. This problem
is very likely due to the fact that either:

You have misspelled the parameter name, or
You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE
tag.

The error occurred while evaluating the expression:


#Shipping_Cost_Array[1][1]#

Any help on this would be greatly appreciated.


H   Larry Juncker
 L  Senior Cold Fusion Programmer
  I Heartland Communications Group
  Internet Division


--
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.

RE: WAP and WML...

2000-04-13 Thread Jordon Saardchit 

nokia has a development SDK for WAP Applications as well.  You can try that
one too.

Jordon

-Original Message-
From: Ian Lurie [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 13, 2000 10:08 AM
To: '[EMAIL PROTECTED]'
Subject: WAP and WML...


I'm putting together a WML/email application using CF, and I've got a
question about compatability -

I'm using the Phone.com developer's kit and SDK to test my stuff. How do I
know if this app will work on phones that don't use Phone.com's service? Is
there a more generic SDK out there I can use?

May all be stupid questions, but thought I'd check...

TIA,

Ian Lurie

Portent Interactive
http://www.portentinteractive.com
Process, Design, Content

Market Matrix
http://www.marketmatrix.com
Secure Commerce for Your Business

Working together to create powerful, usable web solutions.

--
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.

RE: Extraneous end tag error message

2000-04-10 Thread Jordon Saardchit 

Had the same issue mising CFFORM with standard HTML form elements.  Either
use just the FORM tag, or change the SELECT tags to CFSELECT and you should
be fine. Thats how i resolved the issue


-Jordon


-Original Message-
From: Hubert Earl [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 10, 2000 4:54 PM
To: [EMAIL PROTECTED]
Subject: Extraneous end tag error message


This is a multi-part message in MIME format.

--=_NextPart_000_00DA_01BFA326.72E41C20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

I'm getting the following error message from the processing of an update =
template whose cf code takes the form shown further down the email: =20

"Just in time compilation error=20

An extraneous end tag  has been encountered at document =
position (222:1) to (222:9). End tags cannot be present in CFML =
templates without a matching start tag."


The relevant cf code of the template is:



blah, blah,



blah, blah,

 



 
#ModelYear#
 
=20


 

blah, blah





Despite what the error message says, there's only one  tag in =
the template.  Is it possible that the first  also closes off =
? =20

Sincerely,
---
Hubert Earl
ICQ#:  16199853

I develop & maintain web sites internationally.  I also build web =
applications using CGI scripts written in Perl.  I accept subcontracting =
work.

**Personal web site:  http://www.geocities.com/SiliconValley/Peaks/8702/
(please remember to view this with a sense of humour!)

**Business web page:  http://home.talkcity.com/MigrationPath/hearl/

--=_NextPart_000_00DA_01BFA326.72E41C20
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Hi,
 
I'm getting the following error message =
from the=20
processing of an update template whose cf code takes the form =
shown further=20
down the email:  
 

"Just in time compilation error=20
An extraneous end tag  has been encountered at =
document=20
position (222:1) to (222:9). End tags cannot be present in CFML =
templates=20
without a matching start tag."
 
The relevant cf code of the template=20
is:
 

 
blah, blah,
 

 
blah, blah,
 
 

 
     
  
 
 
blah, blah
 

 

 
Despite what the error message says, =
there's only=20
one  tag in the template.  Is it possible that the =
first=20
 also closes off=20
?  
 
Sincerely,
---Hubert EarlICQ#: =20
16199853
 
I develop & maintain web sites=20
internationally.  I also build web applications using CGI scripts =
written=20
in Perl.  I accept subcontracting work.
 
**Personal web site:  http://www.geocities.com/SiliconValley/Peaks/8702/">http://www.ge=
ocities.com/SiliconValley/Peaks/8702/(please=20
remember to view this with a sense of humour!)
 
**Business web page:  http://home.talkcity.com/MigrationPath/hearl/">http://home.talkci=
ty.com/MigrationPath/hearl/

--=_NextPart_000_00DA_01BFA326.72E41C20--


--
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.

RE: Detect if JS is Enabled

2000-04-10 Thread Jordon Saardchit 

damnit... i mean is NOT proprietary coldfusion... heh... looks like i got a
case of the mondays.

-Original Message-
From: Jordon Saardchit [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 10, 2000 11:53 AM
To: [EMAIL PROTECTED]
Subject: RE: Detect if JS is Enabled


A cookie is proprietary coldfusion its just info stored in the header.
Coldfusion just provides a way to access that info, as do other application
servers (eg, ASP).

-J

-Original Message-
From: Gregory Weiss [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 10, 2000 11:17 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Detect if JS is Enabled


That sounds like a good way to do it, but how do you read a cookie in CF
that was not written in CF.  I didn't know you could do that.

Can you set a cookie with an ASP page and read it in CF using the same
method?

Very interested to know.

Greg

-Original Message-
From: Nick McClure [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 10, 2000 2:08 PM
To: [EMAIL PROTECTED]
Subject: Re: Detect if JS is Enabled


What I sometimes do is set a cookie using JavaScript and then try to read
it with CF.

At 11:27 AM 4/10/2000 -0600, you wrote:
>This is a multi-part message in MIME format.
>
>--=_NextPart_000_002A_01BFA2DF.C0B8B380
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>Is there a way to detect (on the server side) if a client browser has =
>JavaScript enabled? I'm most concerned about Netscape 4.x. When =
>JavaScript is disabled in Netscape, it does more than disable =
>JavaScript. It also ignores the positioning of layers and the formating =
>of cascading style sheets (I do have cascascading style sheets enable in =
>my preferences).
>
>Anybody have any ideas?
>
>Jeff Braunstein
>Healthwell.com
>
>--=_NextPart_000_002A_01BFA2DF.C0B8B380
>Content-Type: text/html;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>
>Is there a way to detect (on the = server side)=20 if a client browser has
>JavaScript enabled? I'm most concerned about = Netscape=20 4.x. When
>JavaScript is disabled in Netscape, it does more than disable=20
>JavaScript. It also ignores the positioning of layers and the formating =
>of=20 cascading style sheets (I do have cascascading style sheets enable
>in my = preferences).
>
>Anybody have any ideas?
>
>Jeff Braunstein
>Healthwell.com
>
>--=_NextPart_000_002A_01BFA2DF.C0B8B380--
>
>---
---
>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.

--
Nick McClure[EMAIL PROTECTED]
Technical Director  606.245.9656
squareFish Mediawww.squareFish.com


--
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.



--
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.

RE: Detect if JS is Enabled

2000-04-10 Thread Jordon Saardchit 

A cookie is proprietary coldfusion its just info stored in the header.
Coldfusion just provides a way to access that info, as do other application
servers (eg, ASP).

-J

-Original Message-
From: Gregory Weiss [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 10, 2000 11:17 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Detect if JS is Enabled


That sounds like a good way to do it, but how do you read a cookie in CF
that was not written in CF.  I didn't know you could do that.

Can you set a cookie with an ASP page and read it in CF using the same
method?

Very interested to know.

Greg

-Original Message-
From: Nick McClure [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 10, 2000 2:08 PM
To: [EMAIL PROTECTED]
Subject: Re: Detect if JS is Enabled


What I sometimes do is set a cookie using JavaScript and then try to read
it with CF.

At 11:27 AM 4/10/2000 -0600, you wrote:
>This is a multi-part message in MIME format.
>
>--=_NextPart_000_002A_01BFA2DF.C0B8B380
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>Is there a way to detect (on the server side) if a client browser has =
>JavaScript enabled? I'm most concerned about Netscape 4.x. When =
>JavaScript is disabled in Netscape, it does more than disable =
>JavaScript. It also ignores the positioning of layers and the formating =
>of cascading style sheets (I do have cascascading style sheets enable in =
>my preferences).
>
>Anybody have any ideas?
>
>Jeff Braunstein
>Healthwell.com
>
>--=_NextPart_000_002A_01BFA2DF.C0B8B380
>Content-Type: text/html;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>
>Is there a way to detect (on the = server side)=20 if a client browser has
>JavaScript enabled? I'm most concerned about = Netscape=20 4.x. When
>JavaScript is disabled in Netscape, it does more than disable=20
>JavaScript. It also ignores the positioning of layers and the formating =
>of=20 cascading style sheets (I do have cascascading style sheets enable
>in my = preferences).
>
>Anybody have any ideas?
>
>Jeff Braunstein
>Healthwell.com
>
>--=_NextPart_000_002A_01BFA2DF.C0B8B380--
>
>---
---
>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.

--
Nick McClure[EMAIL PROTECTED]
Technical Director  606.245.9656
squareFish Mediawww.squareFish.com


--
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.


--
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.

RE: getting fields of a table(sql)

2000-04-07 Thread Jordon Saardchit 

Much easier Joe after you query, call query variable
'queryname.ComlumnList'.  Will give you a comma delimited list of the
queries column names

-J

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 07, 2000 2:05 PM
To: [EMAIL PROTECTED]
Subject: getting fields of a table(sql)



Hello All,
  Is there a way/sql statement that would get me all
the fields in the table? and store it in a variable ?

something like

so now x will have the values of the fields in the table.

Appretiate all comments, thanks inadvance!
Joe



This message has been scanned for viruses using Sophos.
The opinions stated in this message do not necessarily
represent the opinions of e-MDs, its management or staff.

--
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.



-
Sent using MailStart.com ( http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!


--
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.

RE: vs.

2000-04-07 Thread Jordon Saardchit 

Best way to do it would be in a Stored Procedure, wrapped in a SQL
transaction.

-J

-Original Message-
From: Jim Taylor [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 07, 2000 7:56 AM
To: Cf-Talk@Houseoffusion. Com
Subject:  vs. 


Let me try this again please.

Is this the best way to handle a 2 table insert ?





INSERT INTO Users (Users.UserID,Users.Password)
VALUES ('#Form.UserID#', '#Form.Password#')




INSERT INTO Users,UserDetails
(UserDetails.FirstName,UserDetails.LastName,UserDetails.Company,UserDetails.
Address1,Address2,UserDetails.City,UserDetails.State,UserDetails.Country,Use
rDetails.Zip,UserDetails.PhoneHome,UserDetails.PhoneWork,UserDetails.PhoneFa
x,UserDetails.Email)
VALUES ('#Form.FirstName#', '#Form.LastName#', '#Form.Company#',
'#Form.Address1#', '#Form.Address2#', '#Form.City#', '#Form.State#',
'#Form.Country#', '#Form.Zip#', '#Form.PhoneHome#', '#Form.PhoneWork#',
'#Form.PhoneFax#', '#Form.Email#')










Jim Taylor

ICQ 47640391


--
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.

RE: Duplicate Values in a query

2000-03-30 Thread Jordon Saardchit 

eliminate the duplicates from the SQL side the DISTINCT keyword.

SELECT DISTINCT blah
  FROM tableBlah
 WHERE columnBlah = moreBlah

-J

-Original Message-
From: Lincoln Manning [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 30, 2000 1:26 PM
To: [EMAIL PROTECTED]
Subject: Duplicate Values in a query


I would like to find a way to isolate duplicate values that I get from a
query.  Can someone help me?  I tried to put all the values into a list,
but I am not sure how to only get the duplicate values.


--
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.

RE: Extracting elements from a data string

2000-03-30 Thread Jordon Saardchit 

Your Best Bet to grab everything in the middle is once you already have
pulled the first and last elements from the space delimited list, do this:




Whatever is in between the first and last elements will be stored as
variable 'middleName'

-Original Message-
From: Chris Evans [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 30, 2000 7:25 AM
To: [EMAIL PROTECTED]
Subject: RE: Extracting elements from a data string






That only works if you have three elements in your list, though.  If you can
have records with more than one middle initial, you'll have to do some
string manipulation to pull out the middle of the list.

Chris Evans
[EMAIL PROTECTED]
http://www.fuseware.com



-Original Message-
From: Robert Ward [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 30, 2000 1:32 AM
To: '[EMAIL PROTECTED]'
Subject: Extracting elements from a data string


Hi all,

We have a data field called #name#

Trouble is it contains all elements of the name, ie: First_Name Initials
Last_Name
(Note:  only about 30% have middle initials)

We would like to extract
- the first word as their first name,
- the last word as their last_name
- and anything in between as their Initials

Anyone go a method to do this?

Thanks in advance

Rob

--
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.


--
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.

RE: SQL question

2000-03-28 Thread Jordon Saardchit 

Ii'm not 100% sure of what it is you are trying to do.  Are you looking to
pull all the information in 'tblData' that corresponds to the uid in
tblSomeInfo If so, you do this.

SELECT d.*
  FROM tblSomeInfo s, tblData d
 WHERE s.uid = [whichever uid you are looking for] AND s.uid = d.uid

That will return all the information in tblData that coresponds to the
Information in tblSomeInfo.  However, it is an unnecessary process.  If you
already know the uid of what you are looking for, just do a select statement
on tblData.  Perhaps You can tell me what information it is you are starting
with, and then what info you want from the table structure as a result of
your Query.

-J

-Original Message-
From: Chris Porter [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 28, 2000 4:31 PM
To: [EMAIL PROTECTED]
Subject: SQL question


hey guys, here's what i'm trying to do.. maybe some of you sql guru's out
there can help. basically, i've got a field in a record that states the
number of records in another table that i want to view & i need a sql query
to gather those rows.

heres the schema

tblSomeInfo tblData

| uid   |   value  ||- uid  -|-- value -|
|--||---3|---out|
---1|-5||---1|---test---|
---2|-3||---2|--- me ---|
---3|-7||---3|---out|
|---4|--- i |
|---5|--need|
|---6|---help---|


the idea is that after this query, depending on which uid in some info,
only the number of records stored in value will be returned. for instance,
assuming it's uid=1, only 5 records would be returned from tblData. or if
uid=2, only 3 records would be returned.

any ideas on how this can be done?
thnx
-chris




--
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.

RE: looping through a mailing list

2000-03-28 Thread Jordon Saardchit 

Yer wasting a lot of processing power in coldfusion unnecessarily.  You
should build a where clause that replicates the conditions you are searchinf
for in your CFIF, that way you just loop over the result set and send the
email to every single record.  SQL Will handle that much faster than Cold
Fusion will.

Jordon


-Original Message-
From: Chris Giminez [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 28, 2000 1:40 PM
To: [EMAIL PROTECTED]
Subject: looping through a mailing list


This is for a real estate web site where the realtor will add their own
property. When new property
is added, I want it to check a data table of subscribers who are interested
in a property fitting
certain criteria, such as price, number of bedrooms, bathrooms, etc.

I thought I had this figured out, but am not getting the desired results.

Here's my code:
**


SELECT  *
FROM notify
ORDER BY  date_subscribed








Send email to #notify_list.first_name#
#notify_list.last_name#





Don't send email #notify_list.first_name#
#notify_list.last_name#




**

I currently have just 3 subscrbers in the notify table for testing and the
above code gives me this
result.

*
Send email to joe testerTest PersonChris Giminez
Don't send email joe testerTest PersonChris Giminez
Don't send email joe testerTest PersonChris Giminez
*
It's somehow evaluating to true and false for each person.

I know I'm close to getting this. If someone could enlighten me I would be
most grateful.

Thanks!

Chris Giminez
Owner - Cyber Scriber Web Site Design
831-728-4469
ICQ# 2628000






--
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.

RE: Easiest way to get a text file into a List?

2000-03-28 Thread Jordon Saardchit 

Read in the file and set it to a variable.  Then Loop over a
"carriage-return" delimited list (ASCI Chr 13 I believe, could be wrong) and
parse each email address as you see fit.

Jordon


-Original Message-
From: Andrea Wasik [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 28, 2000 7:50 AM
To: [EMAIL PROTECTED]
Subject: Easiest way to get a text file into a List?


I have a text file that I need to get into a list or an array so I can
compare it to the results of a query. Anyhow how can I read in that file and
turn it into a list? The file is made up of email addresses, one per line,
no comma delimiters, just carriage returns.

Thanks

Andrea


.
iWon.com http://www.iwon.com why wouldn't you?

.


--
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.

RE: Cookie problem

2000-03-24 Thread Jordon Saardchit 

It sounds something like your list delimiter is not being read correctly in
your ListGetAt function.  However, if i'm correct, coldfusion by default (if
you don't specify a delimiter) uses a comma, so essentially you should be
fine.  Just in case, try specifying the delimiter in your function:

#ListGetAt(cookie.register,1,',')#



-Original Message-
From: Vinicius Caldeira Carvalho [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 24, 2000 9:11 AM
To: Cftalk
Subject: Cookie problem


I have a cookie called register and I put these values on it:



Ok, then I retreive the data using ListGetAt(), but if the name contains 2
strings like Vinicius Carvalho, the Listgetat(cookie.register, 1) retreives
only Vinicius and not Vinicius Carvalho. What's wrong?

By the way, is this the only way to set a value to a cookie (lists)?
[]'s
Vinicius Carvalho


--
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.

RE: CFMAIL

2000-03-24 Thread Jordon Saardchit 

use the MIMEATTACH="[filepath]" attribute in CFMAIL.

-Jordon

-Original Message-
From: mirza baig [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 24, 2000 1:59 PM
To: [EMAIL PROTECTED]
Subject: CFMAIL


I have a file called agreement.cfm that is
automatically generated. This file is like a sales
receipt and the data in it is filled in by it calling
(CFINCLUDE) other files.

How do I send an email with this file as an
attachment.
Please help.

Thanks>
Mirza

__
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com

--
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.

RE: Variable in stored procedures

2000-03-24 Thread Jordon Saardchit 

absolutely... except, in your case, you'd need the syntax:

create procedure test
@tablename nvarchar(255),
@columname nvarchar(255)
AS

EXEC ('select ' + @columname + 'from ' + @tablename)


That'll do it for ya.

-Jordon

-Original Message-
From: Chris Lott [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 24, 2000 4:06 PM
To: CF-TALK
Subject: Variable in stored procedures


Is there a way to use tsql variables as tablenames and columnames in stored
procedures using SQL Server 7? i.e.:

create procedure test
@tablename nvarchar(255),
@columname nvarchar(255)
as
select @columnname from @tablename

(which doesn't work) etc?
--
Chris


--
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.

RE: CFIF Problem with OR

2000-03-24 Thread Jordon Saardchit 

Your syntax is incorrect.  right now you're telling it to evaluate the block
of code if ID is anything.  Look at it this way... if ID is 43, it is STILL
NOT 1... which means your code will execute.  Change them to ANDs.

Jordon

-Original Message-
From: Michel Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 24, 2000 11:48 AM
To: [EMAIL PROTECTED]
Subject: CFIF Problem with OR


Hi there!

What is wrong with this statement?



I also tried:



It executes what's inside even if ID is 43

Any ideas?


--
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.