RE: mac address

[Steve Bernard]

I don't know if there is a custom tag that will do this but, you could use
CFEXECUTE with either 'nbtstat' or, if you have the NT Resource Kit,
'getmac'. 'nbtstat' returns a lot more information than just the MAC, which
means you'd have to parse the information, but 'getmac' returns only the
MAC(s) given the IP address, NetBios name, or host name. You could
optionally create a COM wrapper for it. Of course, Java, VB, and probably
WSH, have the capability to do this too, I just don't have code on hand.

Steve

-Original Message-
From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 1:56 PM
To: CF-Talk
Subject: mac address


Anyone know of a way to grab a client machines mac address?  Am looking for
a way to do it with Cold Fusion, scripting, ActiveX, or Java.  Any tips or
suggestions would be greatly appreciated.  Wanting to use the mac address
for security verification.

Bernd VanSkiver
[EMAIL PROTECTED]
ICQ #: 916324
~~
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

CFLOCATION limitations

[Mark Johnson]

There seems to be a rather large limmitation in the CFLOCATION TAG.

I was attempting to pass a WDDX packet in a CFLOCATION tag and noticed that
there is a limit to the number of characters that you can pass in a
cflocation tag.

Seems to be 1024.  Can anyone confirm that.  It sure is a pain since a
query_string can be so much longer than that.

Mark Johnson
---
Senior Cold Fusion Developer
Cardinal Communications


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

Cfloop Output Question

[KJis18]

Ok, what I want to do is output a query to two tables side by side.

Now i tried this but it doesn't quite work well.  Any suggestions?


SELECT *
FROM Table






 output table



 output table


Thanks

Kevin


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

OT, but strangely not OT

[Dylan Bromby]

I know some of you live this.

http://www.nettelligence.com/iahtwlwp.html


~~
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: Renaming a CF Server (NT/Win2K)

[Bud]

On 12/8/00, Laney, Eric penned:
>I need to replace my aging NT 4.0 / CF 4.0.1 Pro server with new hardware,
>Win2K Adv. Server, and CF 4.5.1.  At Verizon, we can only perform this kind
>of change during the late night hours.  So, to save time at night, I'd like
>to build the new server during the day, migrate the content, and then just
>swap the hardware that night.  No problem there.
>
>However, to maintain compliance with our company's server naming standards,
>I need to rename the new server once it's online so it will have the same
>name as the old server.  Has anyone done this before?  If so, has anyone run
>into any problems or quirks?  Forewarned is forearmed...

Hi Eric. If you don't get an asnwer to this here, try the WIN-NT 
list. Good resource.

To subscribe:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=WINNT-L
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

~~
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: Is there a way to access JavaScript variables through CF??

[Andrew]

could you say a little more about what it is you are trying to do exactly?


Andrew Hewitt
Web Application Developer
webworld studios, inc.
www.wwstudios.com
"I don't have a solution, but I admire your problem"


-Original Message-
From: Ryo Watanabe [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 1:44 PM
To: CF-Talk
Subject: Re: Is there a way to access JavaScript variables through CF??


nothing wrong, but i was wondering if there is an easy way to transfer those
JavaScript variables to CF variables.

-- Original Message --
From: Nick McClure <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Thu, 07 Dec 2000 15:24:58 -0500

>What is wrong with using the CGI environment variable?
>
>cgi.HTTP_USER_AGENT
>
>At 11:42 AM 12/7/2000 -0500, you wrote:
>>In order to get the client platform in JavaScript, navigator.platform can
>>be used.  Is there a way to assign those variables to CF variable?
>>
>>
>>
>
~~
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: Which message-board to get

[Bud]

On 12/9/00, W Luke penned:
>Do you have a URL for that Bud?

fusetalk.com
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

~~
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: Form Validation Question

[Stolpner, Richard J]

Maybe I'm missing the point of your question, but 
if I do understand what you're saying correctly, 
then I think the cause of your problem may be as 
simple as correcting the way you're nesting the 
double quotes in your code.





-Original Message-
From: Patricia Lee [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 11:55 AM
To: CF-Talk
Subject: RE: Form Validation Question


use len(trim(form.lastname))   If the textbox (You did mean textbox, not
text area, yes?  a text block is a single line field that can only accept
255 charachters, while a textarea is multiline and has no max character
restriction) is empty, this combination of functions returns 0 so your
cfif could look like this..

  
do something
 
don't



The secret is the trim function. it gets rid of all leading and trailing
zeros... and will make your function return 0 when it should.


> -Original Message-
> From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 08, 2000 10:04 AM
> To: CF-Talk
> Subject: Form Validation Question
> 
> 
> This is sort of confusion to explain, but I will try.
> 
> I'm attempting to validate a form using the example in 
> MASTERING COLD FUSION
> 4, pg 390, ex 15.4.
> 
> Of course the book example is ultra simple. 3 easy text 
> fields, submits to
> another script that validates by checking to see if value is 
> zero. This is
> Cold Fusion validation by the way, no Java Script. I would 
> have used, client
> side JavaScript but could not get  to give the 
> popup using the
> simple message attribute. I know there are other ways 
> w/JavaScript but I'm
> deep into this way and I think I am close.
> 
> So, submit the form and then the next script checks for zero 
> values. If a
> zero value is found, a "you messed up" message is generated 
> and the form
> field is re-presented to be fixed. All works well, except I'm 
> using a few
> textareas. If the textareas do not get filled out on the "fix 
> it page" and
> submitted, they are not giving an error since there is some 
> value in there.
> 
> 
> 
> 
>   
>   ">
> 
>VALUE=""#Form.Address#""> "  >
> 
> 
> 
> 
> But, with another Formfield,
> 
> 
>   
>   ">
>SIZE=30 MAXLENGTH=50
> VALUE=""#Form.lastName#""">
> 
> 
> the above can be submited over and over and will trigger the 
> zero value.
> 
> 
> What is wrong with my textareas so they make it past my 
> checking for zero
> values??
> 
> Here is the complete code from the page:
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>  VALUE=""#Form.firstName#""">
>  VALUE=""#Form.lastName#""">
> 
>  VALUE=""#Form.address#""">
>  VALUE=""#Form.age#""">
> 
>  VALUE=""#Form.city#""">
> 
> 
> 
>  VALUE=""#Form.PostalCode#""">
>  VALUE=""#Form.Country#""">
> 
> 
>  VALUE=""#HomePhone#""">
> 
>  VALUE=""#Framemodel#""">
> 
> 
> 
>  VALUE=""#size#""">
> 
>  VALUE=""#serial#""">
> 
> 
> 
>  VALUE=""#color#""">
> 
> 
> 
>  VALUE=""#income#""">
> 
>  VALUE=""#gender#""">
>  VALUE=""#ride_often#""">
> 
> 
> 
>  VALUE=""#ride_often#""">
> 
> 
> 
> 
> 
>  VALUE=""#if_contact#""">
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>   
>   ">
>MAXLENGTH=50 VALUE=""#Form.firstName#""">
> 
> 
> 
> 
> 
> 
>   
>   ">
>SIZE=30 MAXLENGTH=50
> VALUE=""#Form.lastName#""">
> 
> 
> 
> 
>   
>   ">
> 
>VALUE=""#Form.Address#""> "  >
> 
> 
> 
> 
> 
> 
>   
>   ">
>VALUE=""#Form.Age#""">
> 
> 
> 
> 
> 
>   
>   ">
>MAXLENGTH=50
> VALUE=""#Form.City#""">
> 
> 
> 
> 
> 
>   
>   ">
>MAXLENGTH=50 VALUE=""#Form.StateOrProvince#""">
> 
> 
> 
> 
> 
>   
>   ">
>MAXLENGTH=50 VALUE=""#Form.PostalCode#""">
> 
> 
> 
> 
>   
>   ">
>SIZE=30 MAXLENGTH=50
> VALUE=""#Form.Country#""">
> 
> 
> 
> 
> 
> 
> 
>   
>   
> 
>  greater than 0
> or Dot is 0)>
>   
>   ">
>MAXLENGTH=30 VALUE=""#Form.EmailAddress#""">
> 
> 
> 
> 
> 
>   
>   ">
>MAXLENGTH=12 VALUE=""#Form.HomePhone#""">
> 
> 
> 
> 
> 
> 
>   
>   ">
> 
>VALUE=""#Form.Framemodel#"" >
>
> 
>   Ti Crown Jewel
>   Crown Jewel
>   Independence
>   Planet Cross
>   Deluxe
>   Special
>   Club Racer
> ">
> 
> 
>   
> 
> 
> 
> 
> 
> 
> 
> 
> 
>   
>   ">
> 
> 
> 
> VALUE=""#Form.stockorcustom#"" >
>
>   Stock
>   Custom
> ">
> 
>   
> 
> 
> 
> 
> 
> 
> 
> 
>   
>   ">
>MAXLENGTH=50
> VALUE=""#Form.size#""">
> 
> 
> 
> 
>   
>   ">
>SIZE=30 MAXLENGTH=50
> VALUE=""#Form.serial#""">
> 
> 
> 
> 
>   
>   ">
>MAXLENGTH=50 VALUE=""#Form.dateofpurchase#""">
> 
> 
> 
> 
>   
>   ">
>MAXLENGTH=50
> VALUE=""#Form.color#""">
> 
> 
> 
> 
>   
>   ">
>MAXLENGTH=50 VALUE=""#Form.nameofd

CF and ClearCase

[Bryan Love]

I can pull .cfm pages from mapped drives no problem, but I CAN'T pull .cfm
pages from a drive mapped to ClearCase.  Any ideas??


Bryan Love ACP
[EMAIL PROTECTED]



~~
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: Food for thought...

[Clint Tredway]

I am glad most of you have a sense of humor. After I sent that, I thought,
that was an incomplete thought.

Thanks for the comments. Since there is not much intrest I will continue
with the secnd part of this.

Thanks and have a nice day.

Clint

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

Removing dupes from list

[Scott Mulholland]

If i have a list like:
 
2,10,3,1,2,9,9,2
 
what is the easiest way to parse out the dupes to make the list:
2,10,3,1,9
 
??
 
Thanks,
Scott


~~
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: Food for thought...

[Todd Ashworth]

Speaking of such products, I would just like to point out that
CommerceBlocks has to be one of the coolest CF development tools I have
seen.  It takes a lot of the work out of one of the most time consuming CF
tasks out there ... forms.  Just give it your database, answer some
questions, and it generates inert, update, delete, and search pages, all
complete with error checking, browser detection, good 'security' and even
style sheets.  I recomend that everyone give it a try!  Also, according to
the liscense agreement, you can make whatever you want with it and not pay
the ($70 I think), until you make money off of whatever you made.  Pretty
slick.

http://www.commerceblocks.com/

Todd Ashworth

P.S. No, I'm not associated with them .. they just have a really cool
product.

- Original Message -
From: "Brian L. Wolfsohn" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, December 08, 2000 1:22 PM
Subject: Re: Food for thought...


| At 10:26 AM 12/8/00 , you wrote:
| >Would any of you be interested in a product that could help streamline
your
| >development time and still allow you full control over your code?



~~
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: Food for thought...

[Andres]

If this is an app you created and wish to FREELY share your insights and
knowledge on your development, the answer is YES!

If you want to sell something... sorry, no buyers here. 

Try selling somewhere else!

-Original Message-
From: Ken Wilson [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 1:21 PM
To: CF-Talk
Subject: Re: Food for thought...


> Would any of you be interested in a product that could help streamline
your
> development time and still allow you full control over your code?


nah.
~~
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: ???

[Philip Arnold - ASP]

> How do I store menu images in  to make my pages load faster?

CF serves pages and has nothing to do with images (which are handled by the
HTTP server)

It's all down to the browser settings as to whether it reloads the images or
not, or JavaScript of you use 2-state buttons, then again - if you set your
browser to get images and pages every time, then it'll always look to the
browser

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**


~~
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: wddx --> SQL Server 7 ?

[Philip Arnold - ASP]

> 1. CFLOOP through structure in CF, doing insert statements (I won't do
> this: too many db calls from CF).

OK, so why not build a string with all of the Insert statements, and then
run the one query - SQL server won't even blink unless it's about 1000
inserts - just remember to separate the SQL commands with a ;

> 2. Use CF to create a large string, pass that to stored proc, parses and
> loop through with inserts. I can do this.

You could do - it'll mean a lot of logic in the Stored Proc, but as long as
you trust your code, then go for it 

> 3. Create wddx packet, send that to a stored proc somehow. This
> is what I'd like to do.

If you're sending one packet to a Stored Proc, then it's easy, it's the work
inside the proc that'll be the hard stuff!

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**


~~
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: Big companies using CF

[Philip Arnold - ASP]

I like the way you duped on some of the entries to make the list look longer


OK, and to put my 2 cents in this...
Reed Exhibition Companies UK run all of their sites on CF.

> Gotta put in my two cents:
>
> www.cirrus.com (Yep, Cirrus Logic)
> www.win2000mag.net (Now this is ironic. The Windows 2000 Magazine
> Network built on CF!)
> www2.sys-con.com (Here's another one. The JAVA developer's journal!)
> www.hitachi.com (Hitachi Corp.)
> www.nectech.com (NEC, as in monitors)
> www.stouffers.com (Stouffers. The frozen food company)
> www.matrox.com (The graphics cards)
> www.wavetech.com (The IT training guys)
> www.edmundscientific.com
> www.ami.com (American Megatrends, Inc.)
> software.mcafee.com (McAfee Software, the virus scan guys)
> www.careerbuilder.com (One of the largest job sites)
> www.buyphilips.com (From WebTV to light bulbs)
> www.senate.gov/senators
> www.mbta.com (Mass. Bay Transit Authority)
> www.nmha.org (The National Mental Health Association)
> www.crayola.com (You know, the crayons we write with.)
> www.nikonusa.com (NIKON...The cameras, etc. I think they're kind
> of big. ;) )
> www.bmwusa.com (BMW... Nice cars)
> www.gomez.com (If he's an online investor, he'll know this
> one...or should)
> media.web.aol.com  (AOL's press release site)
> home.verio.net (Verio..One of the big hosting companies)
> nasatechnology.nasa.gov (NASA site is all done in CF)
> amd.c-3.com (Advanced Micro Devices)
> www.onvia.com (If he's in commercial IT, he should know this one.)
> www.crayola.com (You know, the crayons we write with.)
> www.nikonusa.com (NIKON...The cameras, etc. I think they're kind
> of big. ;) )
> www.bmwusa.com (BMW... Nice cars)
> www.gomez.com (If he's an online investor, he'll know this
> one...or should)
> media.web.aol.com  (AOL's press release site)
> home.verio.net (Verio..One of the big hosting companies)
> nasatechnology.nasa.gov (NASA site is all done in CF)
> amd.c-3.com (Advanced Micro Devices)
> www.onvia.com (If he's in commercial IT, he should know this one.)
>
> These are just a very few.
> If you go into the popular search engines and search on '.cfm',
> you'll get tens of thousands of sites writen in CF.
>
> Don't forget to mention scalability and speed of development/deployment.

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**



~~
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: passing cfquery results to another page

[Larry C. Lyons]

"Hayes, David" wrote:


> Another option: you could cache the query so that the requery on the next
> page will pull the cached version.  This could certainly cause some
> problems; it will not be appropriate in many situations.
> 

I've seen queries go from multiple seconds (huge dataset) down to less
than 20 milliseconds using a cached query. The only time I've ever run
into problem with a cached query is when the user changes the data (via
update or delete). What other problems have you found.

regards,
larry
-- 
Larry C. Lyons
ColdFusion/Web Developer
EBStor.com
8870 Rixlew Lane, Suite 201
Manassas, Virginia 20109-3795
tel: (703) 393-7930 x253
fax: (703) 393-2659
http://www.ebstor.com
http://www.pacel.com
email: [EMAIL PROTECTED]

Chaos, panic, and disorder - my work here is done.
--

~~
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: Food for thought...

[Todd Ashworth]

| Would any of you be interested in a product that could help streamline
your development time and still
| allow you full control over your code?

You mean like crack? woohoo .. sign me up!!

Hmm, it seams to me that nothing can take the place of good coding practices
and solid programming methodologies =-p

Todd Ashworth



~~
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: PL/SQL

[mark_wimer]

In SQL server 7 (and mayber earlier) you can have dynamic sql. You build a
string, then execute it with sp_executesql.
Could this help? I assume there's something like this in pl/sql? Just a
thought.

Mark

[EMAIL PROTECTED]


Basically, we're working on a tool to generate the pl/sql script on the fly
so we
cant use a stored proc.  Any ideas?

-Original Message-
From: C Frederic Valone [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 9:54 AM
To: CF-Talk
Subject: Re: PL/SQL


We use cf and pl/sql stored procs extensively. What exactly are you trying
to do?

Jeff Britts wrote:

> Anyone have any luck running PL/SQL through ColdFusion?  The simple stuff
> seems to work ok, but if you throw it something complex it chokes.
>
>
> Jeff Britts
> ColdFusion Engineer
> e-Dialog
>
>
>
~~
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: Passing variables to a SQL7 stored procedure

[mark_wimer]

Andres,

Here's a snippet from one of my stored procs. I don't think you necessarily
need the brackets around datatypes, but I like to use them. Default values
are declared with the equals sign. These are all input  parameters except
the last one.

CREATE PROCEDURE [dbo].[proc_VisitInsertUpdate]
 @Action[varchar](10),
 @ViTransectID   [int],
 @ViDate[datetime],
 @ViAgentIDObs2 [int] = NULL,
 @ViAgentIDEnt   [int],
 @ViCountSeason [varchar](12) = 'Summer',
 @NewVisitID [int] output

.and here's part of a CF page that calls it:

 
 
 

and so on. I set the "Action" variable to help decide an action in the
stored proc. I always assumed the value would be "" in the stored proc if
that's what you passed. But you must include a procparam for it or the
stored proc won't work. Even if you're passing values in another form, all
the params need to be passed. e.g. :
 inside a stored
procedure?

i want to pass a value to a stored procedure, but the value, and the
variable that holds it, may not be passed all the time.
I want the stored procedure to assign a value of "" to the variable if no
value is passed to it. Then, depending on this variable, it needs to
perform
either one of two queries.

can someone give me pointers on how to do this??

thanks

andres leon
~~
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: Big companies using CF

[Larry C. Lyons]

Benjamin Fitts wrote:
> 
> Internal sites and extranets don't get a lot of traffic.

Victoria's Secret and AutoByTel don't get a lot of traffic? I don't know
how you define a lot of traffic but damn I'd love to get their "not a
lot of traffic."

-- 
Larry C. Lyons
ColdFusion/Web Developer
EBStor.com
8870 Rixlew Lane, Suite 201
Manassas, Virginia 20109-3795
tel: (703) 393-7930 x253
fax: (703) 393-2659
http://www.ebstor.com
http://www.pacel.com
email: [EMAIL PROTECTED]

Chaos, panic, and disorder - my work here is done.
--

~~
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: Best sites for CF Job Listings?

[Steve Reich]

There is always http://www.justcoldfusionjobs.com/  Though not CF
specific, I agree that monster.com, brainbuzz.com, and headhunter.net are
among the best.


"Michael" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> What are the best sites for CF job listings, also I am in upstate NY,
> (for Now)
>
> TIA
> Michael
>



~~
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: IIS plugin

[Garza, Jeff]

The plug-in is already there!

Try setting your log file format to W3C Extended Log File format Click the
properties button, then choose the Extended Properties tab.  You'll see a
series of checkboxes to select.  Pick the Cookies box.

HTH

Jeff Garza
Web Developer
Spectrum Astro, Inc.
480-892-8200

[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Eric Dawson [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 11:05 AM
To: CF-Talk
Subject: IIS plugin


where can I find an IIS plugin that allows a cookie to written to the IIS 
log files.

Eric
~~
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: IIS plugin

[Nick McClure]

I don't think you need a plugin.

It is usually an option that you can select from the logging menu.

At 12:04 PM 12/8/2000 -0600, you wrote:
>where can I find an IIS plugin that allows a cookie to written to the IIS
>log files.
>
>Eric
>
~~
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: Best place to buy CF Studio?

[Nick McClure]

Check out Ebay, you can usually find copies there for a pretty good price. 
If you would prefer to stay away from auctions I would go to buy.com, they 
usually have the best price on allaire products

At 12:54 PM 12/8/2000 -0500, you wrote:
>Hi All,
>I need to purchase a couple of copies of CF Studio. Any online vendors you
>would recommend?
>
>James
>
>
>
~~
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: ODBC errors with MS Access after MDAC 2.6

[Eron Cohen]

Drew,

See the following ColdCut I wrote in the Teratech
ColdCut database.  It tells you how to deal with
misbehaved MDAC installs.  Hope it helps you!

Eron

http://www.teratech.com/coldcuts/cutdetail.cfm?cutid=89



-Original Message-
From: Steve Pierce [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 12:04 PM
To: CF-Talk
Subject: RE: ODBC errors with MS Access after MDAC 2.5


The update was to MDAC 2.5, not 2.6. My fault for
getting the numbers mixed
up. But the CF code broke after upgrading to MDAC 2.5.
Also for more
background the server is running NT4 SP6a, Website
2.5.8 and CF Enterprise
4.0.2. The CF code worked fine with MDAC 2.4, it was
after upgrading to MDAC
2.5 that this one CF template started throwing a PCode
error.

 - Steve




-Original Message-
From: Dru Whitledge [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 07, 2000 10:13 PM
To: CF-Talk
Subject: ODBC errors with MS Access after MDAC 2.6


After upgrading to MDAC 2.6 (contains ODBC) at my ISP
I am now experiencing
memory errors for MS Access queries that once ran
without a problem (and
still do on my MDAC 2.1 server).

The CF server provides the following error message --
(and of course stops
execution)

CMemoryException: unknown cause

 PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag

Has anyone else had this problem? Anyone aware of any
fixes? As I started
into this I had assumed that the new MDAC 2.6 upgrade
simply tightened up
some requirment for correct SQL syntax -- now I'm not
so sure.

One query I'm rebuilding seems to fail on a adding a
simple concatenation
to create an alias field -- (field1) & (field2) AS
Field3 while (field1) AS
Field3 works fine. That's hard to workaround.

Thanks,

Dru
~~
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

Complex expressions w/ cfswitch

[Bud]

Howdy all.

OK, easy enough to do a simple expression using cfswitch.



Some Code


Some Other Code


Default Code



Which is basically if action is "this" do this, if action is "that" 
do that. What about doing a more complex expression. Like if action 
is "this" and isdefined('that')? Is there a way to use complex 
expressions with cfswitch? Examples?

Thanks! :-D
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

~~
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: Bulk imports into database

[Jann VanOver]

This is a SQL command -- it depends on which DBMS you're using.  It has no
dependance on CF except that CF pass the info to the DBMS correctly.

-Original Message-
From: Michael Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 6:05 AM
To: CF-Talk
Subject: Re: Bulk imports into database


Does this command only work with 4.5?
I am using 4.0.


- Original Message - 
From: "paul smith" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, December 04, 2000 9:17 PM
Subject: Re: Bulk imports into database


> I use the following for BULK INSERTs
> 
>  PASSWORD="#pass#">
> BULK INSERT Victor
> FROM 'D:\FR\FileResource\101-200.csv'
> WITH
> (
> FIELDTERMINATOR=',',
> ROWTERMINATOR='
> '
> )
> 
> 
> Very fast!
> 
> best,  paul
> 
> At 03:06 PM 12/4/00 -0600, you wrote:
> >Actually, Enterprise Manager is just a front-end to SQL Server, and
> >you'd want to automate the "back end", not the "front end".
> >
> >For SQL Server, take a look at "BULK INSERT" (look in the Books
> >Online).  It allows you to take a text file containing your data, and
> >bulk insert that data (duh) into a table you specify.  The syntax is a
> >bit trickier than that, but fairly simple.
>
~~
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: loops, queries, ug...

[Bryan Love]

You can't nest cfoutputs if they both have query attributes.  You can run
this in one query with a table join and output using grouping.


Bryan Love ACP
[EMAIL PROTECTED]



-Original Message-
From: Andres [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 9:41 AM
To: CF-Talk
Subject: RE: loops, queries, ug...


did you try something like this


SELECT *
FROM subnets
order by subnetid




#subnetid#


SELECT *
FROM subnetinfo
WHERE subnetid = #subnetid#



subnet ifo here...






-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 10:23 AM
To: CF-Talk
Subject: loops, queries, ug...


I'm confused!

I have 2 tables in the same database, one table has a list of
subnets(subnets), and the other will contain information on each
subnet(subnet_info).  The subnet in the subnets table is the unique id in
that table, which has a one to many relationship with the subnet in the
subnet_info table.

What I want to do is present a table that would present a subnet, then it's
corresponinding IP's and Info, then repeat for each subnet.  Something like:

208.208.208
IP = 1
Name = boxname
Description = what this box does

208.208.209
ect...

I'm not sure of the best method to do this.  I tried building a query on the
subnet table, then in the  of that query, loop through another
query on the subnet_info table... but it doesn't work.  Any ideas for me how
to do this?

TIA,
Pete
~~
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: List w/" " delims

[Bryan Love]

For the record:
You can use more than one symbol for a list delimiter if you assign it to a
variable first:


mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 9:38 AM
To: CF-Talk
Subject: RE: List w/" " delims


Maybe the "*" character is throwing it off.  Sorry, I might have given you a
bad example.

This is some code I have that works.  I set up an array and then convert it
to a list...



I can then pick items from that list, using a #location# index.







Jeff Britts
ColdFusion Engineer
e-Dialog


-Original Message-
From: Robyn Follen [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 9:58 AM
To: CF-Talk
Subject: RE: List w/" " delims


I've tried to user multiple characters as a list delimiter, but whenever I
then try to iterate through the list, specifying my delimiter, it doesn't
work.  E.g., When I have the following code,




#listElement#



I get:

o
ne 
t
wo 
th
ree

because it takes each item in the list of delimiters and checks for them
individually.  Has anyone any insight on how to loop through something with
a particular combination of characters for a delimiter?

Any help would be appreciated,
Robyn


-Original Message-
From: Jeff Britts [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 8:29 AM
To: CF-Talk
Subject: RE: List w/" " delims


You CAN use multiple characters as list delimiters...eg. "|*|".

I do it frequently to cut down on the chances that one of my list items
contains a delimiter.

Jeff Britts
ColdFusion Engineer
e-Dialog



-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 07, 2000 2:21 PM
To: CF-Talk
Subject: Re: List w/" " delims


Keep in mind that list delimiters can only be 1 character.

-- 
Billy Cravens
[EMAIL PROTECTED]


Eric Fickes wrote:
> 
> Got a List question for you.
> 
> I've got a text file that I need to parse and it's " delimited list, in a
> way.  The list format is this.
> 
> "Full Name" "Email Address" "Group List" "Login Name"
> "Demo user for startup" "" " 1;" "Demo"
> 
> I was hoping to somehow use " " as a delimeter, but that's not working.
> When I do that it takes out the spaces in the column names. I'd like to
take
> 
> "Full Name" "Email Address" "Group List" "Login Name"
> 
> and turn it into
> 
> Full Name,Email Address,Group List,Login Name
> 
> Any ideas?
> 
> E
> 
>
~~
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: "Undcocumented Feature" (Copyright MS) in Coldfusion 4.5 isdefine d() function

[Jennifer]

At 04:40 PM 12/8/00 +, you wrote:
>This appears to be an error in ColdFusion's isdefined("") function
>- the parameter is syntactically valid - I am outputting it successfully on
>the line above...
>
>==
>Error Diagnostic Information
>
>An error occurred while evaluating the expression:
>
>
>
>isdefined("request.XMLPacket.BOOKINGSERVICE.SLOTLIST.slot[#currentslot#].att
>ributes.sequencenumber.Value")
>
>
>
>Error near line 104, column 8.
>
>
>
>Parameter 1 of function IsDefined which is now
>"request.XMLPacket.BOOKINGSERVICE.SLOTLIST.slot[1].attributes.sequencenumber
>..Value" must be a syntactically valid variable name

I'm not sure that having "attributes" in there is syntactically valid since 
that's a variable scope.


~~
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: Passing variables to a SQL7 stored procedure

[Bob Silverberg]

When you declare the input parameter, assign it a value, like so:

CREATE PROC myProc
@Param1 char(10) = ''
AS
SELECT ...

Bob

-Original Message-
From: Andres [mailto:[EMAIL PROTECTED]]
Sent: December 8, 2000 12:01 PM
To: CF-Talk
Subject: Passing variables to a SQL7 stored procedure


What is the equivalent of  inside a stored
procedure?

i want to pass a value to a stored procedure, but the value, and the
variable that holds it, may not be passed all the time.
I want the stored procedure to assign a value of "" to the variable if no
value is passed to it. Then, depending on this variable, it needs to perform
either one of two queries.

can someone give me pointers on how to do this??

thanks

andres leon
~~
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: Passing variables to a SQL7 stored procedure

[Bryan Love]

This could get a little tricky, but there are many ways to do it...

To default a value in a stored proc you simply put and equals sign and a
value after if:

Create procedure Order...
storeID int,
userID int,
productID int = 0

This way if you only pass in storeID and userID then productID will be
created and defaulted to 0 (as shown below):

EXECUTE Order 1,1

The only catch is that you MUST declare the defaulted values LAST in the
stored proc or you'll have problems (I think you can see why)

Good luck!

Bryan Love ACP
[EMAIL PROTECTED]



-Original Message-
From: Andres [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 9:01 AM
To: CF-Talk
Subject: Passing variables to a SQL7 stored procedure


What is the equivalent of  inside a stored
procedure?

i want to pass a value to a stored procedure, but the value, and the
variable that holds it, may not be passed all the time.
I want the stored procedure to assign a value of "" to the variable if no
value is passed to it. Then, depending on this variable, it needs to perform
either one of two queries. 

can someone give me pointers on how to do this??

thanks

andres leon
~~
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: Passing variables to a SQL7 stored procedure

[Adkins, Randy]

You can look up CFPROCPARAM for passing parameters

-Original Message-
From: Andres [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 12:01 PM
To: CF-Talk
Subject: Passing variables to a SQL7 stored procedure


What is the equivalent of  inside a stored
procedure?

i want to pass a value to a stored procedure, but the value, and the
variable that holds it, may not be passed all the time.
I want the stored procedure to assign a value of "" to the variable if no
value is passed to it. Then, depending on this variable, it needs to perform
either one of two queries. 

can someone give me pointers on how to do this??

thanks

andres leon
~~
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: "Undcocumented Feature" (Copyright MS) in Coldfusion 4.5 isde fine d() function

[Bryan Love]

You cannot reference arrays in the ISDEFINED function :)


Bryan Love ACP
[EMAIL PROTECTED]



-Original Message-
From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 8:40 AM
To: CF-Talk
Subject: "Undcocumented Feature" (Copyright MS) in Coldfusion 4.5
isdefine d() function


This appears to be an error in ColdFusion's isdefined("") function
- the parameter is syntactically valid - I am outputting it successfully on
the line above...

==
Error Diagnostic Information

An error occurred while evaluating the expression: 


 
isdefined("request.XMLPacket.BOOKINGSERVICE.SLOTLIST.slot[#currentslot#].att
ributes.sequencenumber.Value")



Error near line 104, column 8.



Parameter 1 of function IsDefined which is now
"request.XMLPacket.BOOKINGSERVICE.SLOTLIST.slot[1].attributes.sequencenumber
...Value" must be a syntactically valid variable name
~~
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: "Undcocumented Feature" (Copyright MS) in Coldfusion 4.5 isde fine d() function

[Dan Haley]

I don't know whether it is an error or a bug or expected behavior, but have
learned that it doesn't work.  The way to get around it is to not use the
array type notation "[#currentslot#]" that you are using.

Instead of:
isdefined("request.XMLPacket.BOOKINGSERVICE.SLOTLIST.slot[#currentslot#].att
ributes.sequencenumber.Value")

use:
isdefined("request.XMLPacket.BOOKINGSERVICE.SLOTLIST.slot.#currentslot#.attr
ibutes.sequencenumber.Value")

Dan


-Original Message-
From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 8:40 AM
To: CF-Talk
Subject: "Undcocumented Feature" (Copyright MS) in Coldfusion 4.5
isdefine d() function


This appears to be an error in ColdFusion's isdefined("") function
- the parameter is syntactically valid - I am outputting it successfully on
the line above...

==
Error Diagnostic Information

An error occurred while evaluating the expression: 


 
isdefined("request.XMLPacket.BOOKINGSERVICE.SLOTLIST.slot[#currentslot#].att
ributes.sequencenumber.Value")



Error near line 104, column 8.



Parameter 1 of function IsDefined which is now
"request.XMLPacket.BOOKINGSERVICE.SLOTLIST.slot[1].attributes.sequencenumber
...Value" must be a syntactically valid variable name
~~
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: PL/SQL

[Dan Haley]

Can you pass the PL/SQL to a stored procedure and use the dbms_sql package
to execute it?  I know I've executed simple SQL statements - like truncate
which you can't do right in PL/SQL for some reason - but I don't know how
complex you can do with dbms_sql.

Dan

-Original Message-
From: Jeff Britts [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 8:39 AM
To: CF-Talk
Subject: RE: PL/SQL


Basically, we're working on a tool to generate the pl/sql script on the fly
so we
cant use a stored proc.  Any ideas?

-Original Message-
From: C Frederic Valone [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 9:54 AM
To: CF-Talk
Subject: Re: PL/SQL


We use cf and pl/sql stored procs extensively. What exactly are you trying
to do?

Jeff Britts wrote:

> Anyone have any luck running PL/SQL through ColdFusion?  The simple stuff
> seems to work ok, but if you throw it something complex it chokes.
>
>
> Jeff Britts
> ColdFusion Engineer
> e-Dialog
>
>
>
~~
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

Query me this ...

[Todd Ashworth]

I need a tad bit of SQL help.

I have these tables:

CLASS_DESCRIPTION
 class_description_id (pk)
 num_slots
 min_age
 max_age
 cost
 location

CLASS_NAME_DESCRIPTION
 class_name_description_id (pk)
 class_name
 class_description_id (fk for CLASS_DESCRIPTION)

DAYS_TIMES
 days_times_id (pk)
 days
 times

CLASS_SCHEDULE
 class_schedule_id (pk)
 class_name_description_id (fk for CLASS_NAME_DESCRIPTION)
 start_time (fk for DAYS_TIMES)
 end_time (fk for DAYS_TIMES)

CLASS_GROUP
 class_group_id (pk)
 class_schedule_id_list (comma delimited list of fk for CLASS_SCHEDULE)
 start_date
 end_date

The structure flows as such:

NAMES + CLASS_DESCRIPTION = NAMES_CLASS_DESCRIPTION
NAMES_CLASS_DESCRIPTION + DAYS_TIMES = CLASS_SCHEDULE
CLASS_SCHEDULE + DAYS_TIMES * 7 days = CLASS_GROUP

I need to qrite a query, or group of queries, that will take a single value
passed to the query page (class_group_id) and extract all of the information
from the related tables.  I am trying to figure out a way to do this as
effciently as possible.  Can someone help me before my head explodes?

Todd Ashworth



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

Done ("if/else" CFSCRIPT)...

[Michael Thomas]

Hmm maybe I should of tried this myself before I asked the question. ^_^

I got it everything that I wanted done. Thanx anyways.
~~
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: CFFILE and IE 5.0 on a Mac doesn't work

[Joshua Miller]

I don't suppose you could pass along this proceedure ... I tried using:








And I get an error saying that the filefield doesn't contain a valid file
for upload... I'm proabably way off on this though.

Joshua Miller
Web Development
Eagle Technologies Group, Inc.
Business Solutions for the Next Generation
www.eagletgi.com 
[EMAIL PROTECTED] 


-Original Message-
From: Rob Keniger [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 07, 2000 8:44 PM
To: CF-Talk
Subject: Re: CFFILE and IE 5.0 on a Mac doesn't work


on 8/12/00 6:06 AM, Craig A. Zingerline at
[EMAIL PROTECTED] wrote:

> I'm wondering if anyone has found a workaround to the following
> situation...we are using CFFILE to upload .gif and .jpg files to our
server.
> The scripts work fine on Netscape and IE on a PC, but only work with
> Netscape on a Macintosh.  The mac OS is 9.0 and we are using IE 5.0.  I
have
> a couple of links with relevant information below, but have not been able
to
> find (nor do I know) if a workaround to this problem exists.  We get the
> following error code:

What I have found is that IE 5 Mac appends control characters (I think
CR/LF) to the end of values passed through form fields when you are using
multipart/form-data encoding. If you are using a field to specify the file
name then this could be the problem. I wrote a procedure for a site that had
this problem that did a user-agent check and stripped the rightmost two
characters if it was Mac IE. Seemed to work OK.

--

Rob Keniger

big bang solutions


~~
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: LA CFUG (was Re: CF outputing SQL Server int field with decimal's?)

[Kinley Pon]

Thanks David...hope to meet you there.

Kinley Pon
Westcar Consulting Group, Inc.
mailto: [EMAIL PROTECTED]


-Original Message-
From: David Shadovitz [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 1:04 AM
To: CF-Talk
Subject: LA CFUG (was Re: CF outputing SQL Server int field with decimal's?)

I'm not Sandra, but...
Check the Southern California CFUG's web site, www.sccfug.org.  The LA
branch meets on the first Tuesday of the month in the offices of Event411
in Marina Del Rey.
-David

On Thu, 07 Dec 2000 16:33:09 -0800 "Kinley Pon" <[EMAIL PROTECTED]>
writes:
> Hello Sandra,
>
> You mentioned an LA CFUG.  Is this the Los Angeles CFUG?  If so,
> GREAT.  I
> was wondering if there was a user group here.  I live in Monterey
> Park.
> Where is meeting held and when?
>
> Justme
> Kinley
~~
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

"if/else" CFSCRIPT...

[Michael Thomas]

Can anyone show me a working example of an if/else statement in cfscript??? 
I do understand its just like working with javascript, however my use for it 
is a lil' bit trickier as it involves RegEx.

The most Ive done with CFSCRIPT before is just setting variables.

TIA,
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: BULK INSERT - Access or ODBC incompatibility?

[paul smith]

Here are some issues I ran into recently:

1. BULK INSERT has to run under a sysadmin account.  For my user, I setup a 
CFAS mapping to a template my user could not access.  The CFQUERY in THAT 
template had the BULK INSERT in it and have sysadmin access.

2. If you CFINCLUDE something like the following:


BULK INSERT jobsINITIAL
FROM '#File.ServerDirectory#\#FILE.ServerFile#'
WITH
(
FIELDTERMINATOR='|',
ROWTERMINATOR='
'
)


it will fail

You need to change ROWTERMINATOR='
'
to
ROWTERMINATOR='#chr(13)##chr(10)#'

HTH

best,  paul

PS> 3. You cannot have a Identity column in the table you're inserting to.
And the number and kind of columns in the table must exactly match that in 
the CSV file.  (I think BCP can work-around these - but I don't know its use)




At 12:23 PM 12/8/00 -0400, you wrote:
>Hi!
>
>I am using the SQL7's  "BULK INSERT", but I get the following error:
>
~~
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

OT:SQL Server uninstall

[Robert M. Saxon, Jr.]

Does anyone know where I can find complete uninstall instructions for the
desktop version of SQL Server 7?  I have DLL errors that are preventing me
from performing any DTS task.  After using the uninstall program and
reinstalling SQL Server, the problems persist.

Rob



~~
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: List w/" " delims

[Dave Watts]

> I use a carraige return and line feed all the time as a 
> delimiter. Why doesn't that break?

When you specify multiple characters within the DELIMITERS attribute, CF
uses any one of those as a delimiter, rather than using them together as a
single delimiter. Here's an example:




#i#


If CFLOOP treated the value in the DELIMITERS argument as a single
delimiter, your output would be:

1:2
3;4

Instead, though, it's:

1
2
3
4

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

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

OT:SQL uninstall

[Robert M. Saxon, Jr.]

Does anyone know where I can find complete uninstall instructions for the
desktop version of SQL Server 7?  I have DLL errors that are preventing me
from performing any DTS task.  After using the uninstall program and
reinstalling SQL Server, the problems persist.

Rob




~~
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: loops, queries, ug...

[Jason Powers]

You might want to do this in a single query which will do a LEFT OUTER JOIN
between your base table(subnets) and your info table(subnet_info).  That
way, if you order by subnet, you can do a  to loop over your subnets, and a  inside of that
to loop over the properties of each subnet.  

Jason Powers
Fig Leaf Software
202-797-5440


-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 10:23 AM
To: CF-Talk
Subject: loops, queries, ug...


I'm confused!

I have 2 tables in the same database, one table has a list of
subnets(subnets), and the other will contain information on each
subnet(subnet_info).  The subnet in the subnets table is the unique id in
that table, which has a one to many relationship with the subnet in the
subnet_info table.

What I want to do is present a table that would present a subnet, then it's
corresponinding IP's and Info, then repeat for each subnet.  Something like:

208.208.208
IP = 1
Name = boxname
Description = what this box does

208.208.209
ect...

I'm not sure of the best method to do this.  I tried building a query on the
subnet table, then in the  of that query, loop through another
query on the subnet_info table... but it doesn't work.  Any ideas for me how
to do this?

TIA,
Pete
~~
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: Food for thought...

[Hoffman, Joe (CIT)]

No

-Original Message-
From: Clint Tredway [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 10:27 AM
To: CF-Talk
Subject: Food for thought...


Would any of you be interested in a product that could help streamline your
development time and still allow you full control over your code?
~~
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

mac address

[Bernd VanSkiver]

Anyone know of a way to grab a client machines mac address?  Am looking for
a way to do it with Cold Fusion, scripting, ActiveX, or Java.  Any tips or
suggestions would be greatly appreciated.  Wanting to use the mac address
for security verification.

Bernd VanSkiver
[EMAIL PROTECTED]
ICQ #: 916324


~~
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: Is there a way to access JavaScript variables through CF??

[Ryo Watanabe]

nothing wrong, but i was wondering if there is an easy way to transfer those 
JavaScript variables to CF variables.

-- Original Message --
From: Nick McClure <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Thu, 07 Dec 2000 15:24:58 -0500

>What is wrong with using the CGI environment variable?
>
>cgi.HTTP_USER_AGENT
>
>At 11:42 AM 12/7/2000 -0500, you wrote:
>>In order to get the client platform in JavaScript, navigator.platform can 
>>be used.  Is there a way to assign those variables to CF variable?
>>
>>
>>
>
~~
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: Food for thought...

[Peter Theobald]

Will it restore my hair-loss and give my pants cuffs too? :-)

At 09:26 AM 12/8/00 -0600, Clint Tredway wrote:
>Would any of you be interested in a product that could help streamline your
>development time and still allow you full control over your code?
>
>
~~
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: Process Time Variable WAS Re: Caching Queries......

[Bryan Love]

GetTickCount()


Bryan Love ACP
[EMAIL PROTECTED]



-Original Message-
From: defective david [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 07, 2000 8:50 PM
To: CF-Talk
Subject: Process Time Variable WAS Re: Caching Queries..


Ya know what'd be nice?

A variable that outputed the time it took to process the page from the
begining to the point you output the variable.

I currently do this with two lines of code, one's the first line of
applicaiton.cfm and the other is at the bottom of the output.

but still... a variable would be nice.

---
defective david
http://defective.net

- Original Message -
From: "David Shadovitz" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, November 26, 2000 8:43 PM
Subject: Re: Caching Queries..


> What is cf_timer?  Why not just print out CFQUERY.ExecutionTime ?
> -David
>
> On Mon, 27 Nov 2000 14:23:06 +1100 "Scott, Andrew" <[EMAIL PROTECTED]>
> writes:
> > I am a little confused on this, this is something I haven't dealt
> > with
> > much... So forgive me if I don't understand.
> >
> > Anyway I have done the following as a test.
> >
> > 
> >   > cachedwithin="#CreateTimeSpan(1,0,0,0)#">
> >   select * from bp_modules
> >  
> > 
> > 
> >   > cachedwithin="#CreateTimeSpan(1,0,0,0)#">
> >   select * from bp_modules
> >  
> > 
> >
> > The intersting thing is that, sometimes the second query returns the
> > time it
> > should have executed other times it returns 0ms like you would
> > expect a
> > cache to return This to me appears that either the logic of how
> > it works
> > is wrong in what I think it does, or that there is a bug in the
> > query
> > caching.
>
~~
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: loops, queries, ug...

[Hayes, David]

First, you need one query that joins the 2 tables.

SELECT subnets.subnetID, subnets.name(?), 
FROM subnets, subnet_info
WHERE subnets.ID = subnet_info.ID
ORDER BY name


Then, you can use the QUERY and GROUP attributes of  to output the
results.


Name

other fields





-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 9:23 AM
To: CF-Talk
Subject: loops, queries, ug...


I'm confused!

I have 2 tables in the same database, one table has a list of
subnets(subnets), and the other will contain information on each
subnet(subnet_info).  The subnet in the subnets table is the unique id in
that table, which has a one to many relationship with the subnet in the
subnet_info table.

What I want to do is present a table that would present a subnet, then it's
corresponinding IP's and Info, then repeat for each subnet.  Something like:

208.208.208
IP = 1
Name = boxname
Description = what this box does

208.208.209
ect...

I'm not sure of the best method to do this.  I tried building a query on the
subnet table, then in the  of that query, loop through another
query on the subnet_info table... but it doesn't work.  Any ideas for me how
to do this?

TIA,
Pete
~~
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: loops, queries, ug...

[John Allred]

Pete,

I think a simple group on the output is all you need. Query your tables
(using, e.g., name = "get_subnets"), then on the output section, add a
group parameter, as in:



I'm assuming the value in "subnets" is the IP number.

HTH,
--John




   
  
Peter Benoit   
  

twork.com>cc:  
  
  Subject: loops, queries, ug...   
  
12/08/2000 09:22   
  
AM 
  
Please respond to  
  
cf-talk
  
   
  
   
  




I'm confused!

I have 2 tables in the same database, one table has a list of
subnets(subnets), and the other will contain information on each
subnet(subnet_info).  The subnet in the subnets table is the unique id in
that table, which has a one to many relationship with the subnet in the
subnet_info table.

What I want to do is present a table that would present a subnet, then it's
corresponinding IP's and Info, then repeat for each subnet.  Something
like:

208.208.208
   IP = 1
   Name = boxname
   Description = what this box does

208.208.209
   ect...

I'm not sure of the best method to do this.  I tried building a query on
the
subnet table, then in the  of that query, loop through another
query on the subnet_info table... but it doesn't work.  Any ideas for me
how
to do this?

TIA,
Pete
~~
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: structures always serialized to WDDX the same way?

[Bryan Love]

cut and paste this wherever you can run it..













 
 



The structures are identicle

The structures are different



Bryan Love ACP
[EMAIL PROTECTED]



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 6:29 AM
To: CF-Talk
Subject: structures always serialized to WDDX the same way?


Does anyone know if structures that are serialized to WDDX are always
arranged the same way?  That is, if I create a structure, adding keys and
values in a certain order, then create another structure using the same code
(but not by doing a Duplicate or StructCopy), and serialize them both, will
the serialized versions string-compare as identical?  The docs say that
StructKeyList and StructKeyArray "do not return the keys in any particular
order", so I can imagine that the WDDX versions might be arranged
differently.

Any experience?

thanks

---
Martin Herbener
[EMAIL PROTECTED]
Kentucky Department of Education
~~
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: CF java object

[Bryan Love]

Calling a Java class is done using HTML and thus the location of the CF
machine is completely irrelevent.  You can call Java classes from anywhere.


Bryan Love ACP
[EMAIL PROTECTED]



-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 5:33 AM
To: CF-Talk
Subject: CF java object


can I call a java object on a remote machine? or does the object have to be
on
the same machine as CF?
~~
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

Renaming a CF Server (NT/Win2K)

[Laney, Eric]

I need to replace my aging NT 4.0 / CF 4.0.1 Pro server with new hardware,
Win2K Adv. Server, and CF 4.5.1.  At Verizon, we can only perform this kind
of change during the late night hours.  So, to save time at night, I'd like
to build the new server during the day, migrate the content, and then just
swap the hardware that night.  No problem there.

However, to maintain compliance with our company's server naming standards,
I need to rename the new server once it's online so it will have the same
name as the old server.  Has anyone done this before?  If so, has anyone run
into any problems or quirks?  Forewarned is forearmed...

Thanks,

Eric A. Laney
Systems Engineer
Verizon IT

"It is easy to be blinded to the essential uselessness of computers by the
sense of accomplishment you get from getting them to work at all." - Douglas
Adams




~~
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: Best sites for CF Job Listings?

[Gavin Myers]

I've had luck with techies.com
careerbuilder.com is nice because it searches a bunch of job websites (dice,
monster, hotjobs etc.)


-Original Message-
From: Michael [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 5:27 AM
To: CF-Talk
Subject: Best sites for CF Job Listings?


What are the best sites for CF job listings, also I am in upstate NY,
(for Now)

TIA
Michael
~~
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: Food for thought...

[Ken Wilson]

> Would any of you be interested in a product that could help streamline
your
> development time and still allow you full control over your code?


nah.


~~
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: Food for thought...

[Brian L. Wolfsohn]

At 10:26 AM 12/8/00 , you wrote:
>Would any of you be interested in a product that could help streamline your
>development time and still allow you full control over your code?

uh, no.. i hate being productive, and if i can do something in 10 hours, 
why in the world would i want to be able to accomplish the same thing in 
half the time ???  They might find out that don't really need me!!


oh i fergot:







~~
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: Food for thought...

[Jennifer]

At 09:26 AM 12/8/00 -0600, you wrote:
>Would any of you be interested in a product that could help streamline your
>development time and still allow you full control over your code?

This seems like a rhetorical question and I feel a marketing pitch coming 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

RE: Food for thought...

[Rich Wild]

> Would any of you be interested in a product that could help 
> streamline your
> development time and still allow you full control over your code?

no.

I like my bloatware.

---
Rich Wild
Senior Web Designer

---
e-mango.com ltd  Tel: 01202 587 400
Lansdowne Place  Fax: 01202 587 401
17 Holdenhurst Road
Bournemouth   Mailto:[EMAIL PROTECTED]
BH8 8EW, UK  http://www.e-mango.com
---
This message may contain information which is legally
privileged and/or confidential.  If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of e-mango.com ltd,
unless otherwise explicitly and independently indicated
by an authorised representative of e-mango.com ltd.
---




> -Original Message-
> From: Clint Tredway [mailto:[EMAIL PROTECTED]]
> Sent: 08 December 2000 15:27
> To: CF-Talk
> Subject: Food for thought...
> 
> 
> Would any of you be interested in a product that could help 
> streamline your
> development time and still allow you full control over your code?
> 
>
~~
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: Form Validation Question

[Bryan Love]

First of all you shouldn't be using the VALUE attribute for a textarea.  The
default value for a textarea is whatever you put BETWEEN the opening and
closing tags (in this case a space).  That space has length of 1 and
therefore will not be caught by the IF statement.  Use the TRIM function
which will strip off all leading and trailing white space from form entries.



or



BL

-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 7:04 AM
To: CF-Talk
Subject: Form Validation Question


This is sort of confusion to explain, but I will try.

I'm attempting to validate a form using the example in MASTERING COLD FUSION
4, pg 390, ex 15.4.

Of course the book example is ultra simple. 3 easy text fields, submits to
another script that validates by checking to see if value is zero. This is
Cold Fusion validation by the way, no Java Script. I would have used, client
side JavaScript but could not get  to give the popup using the
simple message attribute. I know there are other ways w/JavaScript but I'm
deep into this way and I think I am close.

So, submit the form and then the next script checks for zero values. If a
zero value is found, a "you messed up" message is generated and the form
field is re-presented to be fixed. All works well, except I'm using a few
textareas. If the textareas do not get filled out on the "fix it page" and
submitted, they are not giving an error since there is some value in there.





">

 "  >




But, with another Formfield,



">



the above can be submited over and over and will trigger the zero value.


What is wrong with my textareas so they make it past my checking for zero
values??

Here is the complete code from the page:





























































































">








">






">

 "  >







">







">







">







">






">













">







">








">


 

  Ti Crown Jewel
  Crown Jewel
  Independence
  Planet Cross
  Deluxe
  Special
  Club Racer
">













">



 
 
  Stock
  Custom
">











">






">






">






">






">







">

 "  >







">


 
 
  Less than $20,000
  $20k to $30k
  $31k to $40k
  $41k to $50k
  $51k to $60k
  $61k to $70k
  $71k to $80k
  $81k to $90k
  $91k to $100k
  A little over 100k
  way over 100k
   ">









">


 
male
female
  ">










">


 
   
once a week
2 to 4 times a
week
5 or more times a
week
   ">













  Was it helpful? Why or why not?Please answer this
question">

  "  >






">
  "  >






">
  "  >





">
  "  >





">
  "  >





">
  "  >






">
  "  >





">
  "  >






">
  "  >










Sorry. An error occurred.

#Error#
Please correct the error






















  


  

  First Name 
  
 #firstName#



  

  Last Name 
  
  #lastName#



 

  

  Age 
  
  #Age#





  

  Address 
  
  #Address#




  

  City 
  
  #City#



  

  State/Province 
  
#StateOrProvince#



  

  PostalCode 
  
   #PostalCode#



  

  Country 
  
  #Country#



  

  Email Address 
  
   #EmailAddress#



  

  Home Phone 
  
  #HomePhone#



  

  Frame Model 
  
  #Framemodel#



  

  Was the frame stock or custom? 
  
#stockorcustom#



  

  Size 
  
   #size#

RE: Structure comparison

[Bryan Love]

Use WDDX to turn both structs into strings then use the COMPARE or
COMPARENOCASE functions to see if they are the same:

 
 


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 5:38 AM
To: CF-Talk
Subject: Structure comparison


Does anyone have code (or is there a function I've overlooked) to compare
two structures and verify that they're logically identical?

Thanks


---
Martin Herbener
[EMAIL PROTECTED]
Kentucky Department of Education
~~
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

IIS plugin

[Eric Dawson]

where can I find an IIS plugin that allows a cookie to written to the IIS 
log files.

Eric
~~
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: loops, queries, ug...

[Bryan Love]

You should never put a query inside a looping structure.  Try this:



SELECT s.subnet, ip.ip, ip.name, ip.description
FROM subnets s, ips ip
WHERE s.subnet = ip.subnet
ORDER BY s.subnet




#subnet#


#ip# #name# #description#




-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 7:23 AM
To: CF-Talk
Subject: loops, queries, ug...


I'm confused!

I have 2 tables in the same database, one table has a list of
subnets(subnets), and the other will contain information on each
subnet(subnet_info).  The subnet in the subnets table is the unique id in
that table, which has a one to many relationship with the subnet in the
subnet_info table.

What I want to do is present a table that would present a subnet, then it's
corresponinding IP's and Info, then repeat for each subnet.  Something like:

208.208.208
IP = 1
Name = boxname
Description = what this box does

208.208.209
ect...

I'm not sure of the best method to do this.  I tried building a query on the
subnet table, then in the  of that query, loop through another
query on the subnet_info table... but it doesn't work.  Any ideas for me how
to do this?

TIA,
Pete
~~
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: loops, queries, ug...

[John Rice]

>I'm not sure of the best method to do this.  I tried building a query on
the
>subnet table, then in the  of that query, loop through another
>query on the subnet_info table... but it doesn't work.  Any ideas for me
how
>to do this?

My idea:



subnet


IP = 1
Name = boxname
Description = what this box does





of course using cf query varaibles with #'s and doing your formating.

And make sure your query has the Order By clause set to subnet.


Best of Luck!!


~~
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: loops, queries, ug...

[Adkins, Randy]

Try something like this:



Select Subnet.*, SubnetInfo.*
From Subnet
LEFT Join SubnetInfo ON
Subnet.IPMask = SubNetInfo.IPMask






Subnet: #getall.IPmask#




IP = #IPEnding#
Name = #getall.boxname#
Description = #Getall.Desc#
   




-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 10:23 AM
To: CF-Talk
Subject: loops, queries, ug...


I'm confused!

I have 2 tables in the same database, one table has a list of
subnets(subnets), and the other will contain information on each
subnet(subnet_info).  The subnet in the subnets table is the unique id in
that table, which has a one to many relationship with the subnet in the
subnet_info table.

What I want to do is present a table that would present a subnet, then it's
corresponinding IP's and Info, then repeat for each subnet.  Something like:

208.208.208
IP = 1
Name = boxname
Description = what this box does

208.208.209
ect...

I'm not sure of the best method to do this.  I tried building a query on the
subnet table, then in the  of that query, loop through another
query on the subnet_info table... but it doesn't work.  Any ideas for me how
to do this?

TIA,
Pete
~~
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

Best place to buy CF Studio?

[Milks, Jim]

Hi All,
I need to purchase a couple of copies of CF Studio. Any online vendors you
would recommend?

James


~~
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: loops, queries, ug...

[Andres]

did you try something like this


SELECT *
FROM subnets
order by subnetid




#subnetid#


SELECT *
FROM subnetinfo
WHERE subnetid = #subnetid#



subnet ifo here...






-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 10:23 AM
To: CF-Talk
Subject: loops, queries, ug...


I'm confused!

I have 2 tables in the same database, one table has a list of
subnets(subnets), and the other will contain information on each
subnet(subnet_info).  The subnet in the subnets table is the unique id in
that table, which has a one to many relationship with the subnet in the
subnet_info table.

What I want to do is present a table that would present a subnet, then it's
corresponinding IP's and Info, then repeat for each subnet.  Something like:

208.208.208
IP = 1
Name = boxname
Description = what this box does

208.208.209
ect...

I'm not sure of the best method to do this.  I tried building a query on the
subnet table, then in the  of that query, loop through another
query on the subnet_info table... but it doesn't work.  Any ideas for me how
to do this?

TIA,
Pete
~~
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: Studio 4.5.1 - Setup Question

[Dave Hannum]

Thanks - that was it.

Dave


- Original Message -
From: "Richard Kern" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, December 08, 2000 10:23 AM
Subject: RE: Studio 4.5.1 - Setup Question


options,settings, html gets you a switch to turn lower case on for tags.
Otherwise it's as you type.
Richard

-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 07, 2000 6:51 AM
To: CF-Talk
Subject: Studio 4.5.1 - Setup Question


Hello,

I just installed Studio 4.5.1 (finally upgraded from 3.1).  In 3.1 there was
an option to upper case the tags when you inserted them.  I have searched
for two days now, and have been unable to locate this switch in 4.5.1.  Does
it offer that option?  And if so, can someone tell me where it is?

Thanks,
Dave

=
"What we need is a list of specific unknown problems we will encounter"

David Hannum
Web Analyst/Programmer
Ohio University
[EMAIL PROTECTED]
(740) 597-2524
~~
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: List w/" " delims

[Jeff Britts]

Maybe the "*" character is throwing it off.  Sorry, I might have given you a
bad example.

This is some code I have that works.  I set up an array and then convert it
to a list...



I can then pick items from that list, using a #location# index.







Jeff Britts
ColdFusion Engineer
e-Dialog


-Original Message-
From: Robyn Follen [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 9:58 AM
To: CF-Talk
Subject: RE: List w/" " delims


I've tried to user multiple characters as a list delimiter, but whenever I
then try to iterate through the list, specifying my delimiter, it doesn't
work.  E.g., When I have the following code,




#listElement#



I get:

o
ne 
t
wo 
th
ree

because it takes each item in the list of delimiters and checks for them
individually.  Has anyone any insight on how to loop through something with
a particular combination of characters for a delimiter?

Any help would be appreciated,
Robyn


-Original Message-
From: Jeff Britts [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 8:29 AM
To: CF-Talk
Subject: RE: List w/" " delims


You CAN use multiple characters as list delimiters...eg. "|*|".

I do it frequently to cut down on the chances that one of my list items
contains a delimiter.

Jeff Britts
ColdFusion Engineer
e-Dialog



-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 07, 2000 2:21 PM
To: CF-Talk
Subject: Re: List w/" " delims


Keep in mind that list delimiters can only be 1 character.

-- 
Billy Cravens
[EMAIL PROTECTED]


Eric Fickes wrote:
> 
> Got a List question for you.
> 
> I've got a text file that I need to parse and it's " delimited list, in a
> way.  The list format is this.
> 
> "Full Name" "Email Address" "Group List" "Login Name"
> "Demo user for startup" "" " 1;" "Demo"
> 
> I was hoping to somehow use " " as a delimeter, but that's not working.
> When I do that it takes out the spaces in the column names. I'd like to
take
> 
> "Full Name" "Email Address" "Group List" "Login Name"
> 
> and turn it into
> 
> Full Name,Email Address,Group List,Login Name
> 
> Any ideas?
> 
> E
> 
>
~~
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: Which message-board to get

[W Luke]

- Original Message -
From: ""Dennis Powers"" <[EMAIL PROTECTED]>
Newsgroups: dotcom.lists.cftalk
Sent: Friday, December 08, 2000 5:44 AM
Subject: RE: Which message-board to get


> For a CF BBS, check out "Forums". It is now an open-Source project.
>
> http://www.forumspot.org/

Very nice - could be good.  Is it me, or are ASP boards more in abundance
than CF ones?

Will


~~
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: Which message-board to get

[W Luke]

> I set up fusetalk for a customer and it was very easy and works real 
> well. Runs on Access or SQL Server. The open source is pretty 
> expensive though.

Do you have a URL for that Bud?

Cheers

Will


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

Passing variables to a SQL7 stored procedure

[Andres]

What is the equivalent of  inside a stored
procedure?

i want to pass a value to a stored procedure, but the value, and the
variable that holds it, may not be passed all the time.
I want the stored procedure to assign a value of "" to the variable if no
value is passed to it. Then, depending on this variable, it needs to perform
either one of two queries. 

can someone give me pointers on how to do this??

thanks

andres leon

~~
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: ODBC errors with MS Access after MDAC 2.5

[Steve Pierce]

The update was to MDAC 2.5, not 2.6. My fault for getting the numbers mixed
up. But the CF code broke after upgrading to MDAC 2.5. Also for more
background the server is running NT4 SP6a, Website 2.5.8 and CF Enterprise
4.0.2. The CF code worked fine with MDAC 2.4, it was after upgrading to MDAC
2.5 that this one CF template started throwing a PCode error.

 - Steve




-Original Message-
From: Dru Whitledge [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 07, 2000 10:13 PM
To: CF-Talk
Subject: ODBC errors with MS Access after MDAC 2.6


After upgrading to MDAC 2.6 (contains ODBC) at my ISP I am now experiencing
memory errors for MS Access queries that once ran without a problem (and
still do on my MDAC 2.1 server).

The CF server provides the following error message -- (and of course stops
execution)

CMemoryException: unknown cause

 PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag

Has anyone else had this problem? Anyone aware of any fixes? As I started
into this I had assumed that the new MDAC 2.6 upgrade simply tightened up
some requirment for correct SQL syntax -- now I'm not so sure.

One query I'm rebuilding seems to fail on a adding a simple concatenation
to create an alias field -- (field1) & (field2) AS Field3 while (field1) AS
Field3 works fine. That's hard to workaround.

Thanks,

Dru


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

CFPOP

[Aaron Rouse]

If you define the port number of 995(or whichever port SSL POP server is
sitting on) for CFPOP will this enable it to make a SSL POP connection to a
properly configured server?


~~
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: Form Validation Question

[Patricia Lee]

use len(trim(form.lastname))   If the textbox (You did mean textbox, not
text area, yes?  a text block is a single line field that can only accept
255 charachters, while a textarea is multiline and has no max character
restriction) is empty, this combination of functions returns 0 so your
cfif could look like this..

  
do something
 
don't



The secret is the trim function. it gets rid of all leading and trailing
zeros... and will make your function return 0 when it should.


> -Original Message-
> From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 08, 2000 10:04 AM
> To: CF-Talk
> Subject: Form Validation Question
> 
> 
> This is sort of confusion to explain, but I will try.
> 
> I'm attempting to validate a form using the example in 
> MASTERING COLD FUSION
> 4, pg 390, ex 15.4.
> 
> Of course the book example is ultra simple. 3 easy text 
> fields, submits to
> another script that validates by checking to see if value is 
> zero. This is
> Cold Fusion validation by the way, no Java Script. I would 
> have used, client
> side JavaScript but could not get  to give the 
> popup using the
> simple message attribute. I know there are other ways 
> w/JavaScript but I'm
> deep into this way and I think I am close.
> 
> So, submit the form and then the next script checks for zero 
> values. If a
> zero value is found, a "you messed up" message is generated 
> and the form
> field is re-presented to be fixed. All works well, except I'm 
> using a few
> textareas. If the textareas do not get filled out on the "fix 
> it page" and
> submitted, they are not giving an error since there is some 
> value in there.
> 
> 
> 
> 
>   
>   ">
> 
>VALUE=""#Form.Address#""> "  >
> 
> 
> 
> 
> But, with another Formfield,
> 
> 
>   
>   ">
>SIZE=30 MAXLENGTH=50
> VALUE=""#Form.lastName#""">
> 
> 
> the above can be submited over and over and will trigger the 
> zero value.
> 
> 
> What is wrong with my textareas so they make it past my 
> checking for zero
> values??
> 
> Here is the complete code from the page:
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>  VALUE=""#Form.firstName#""">
>  VALUE=""#Form.lastName#""">
> 
>  VALUE=""#Form.address#""">
>  VALUE=""#Form.age#""">
> 
>  VALUE=""#Form.city#""">
> 
> 
> 
>  VALUE=""#Form.PostalCode#""">
>  VALUE=""#Form.Country#""">
> 
> 
>  VALUE=""#HomePhone#""">
> 
>  VALUE=""#Framemodel#""">
> 
> 
> 
>  VALUE=""#size#""">
> 
>  VALUE=""#serial#""">
> 
> 
> 
>  VALUE=""#color#""">
> 
> 
> 
>  VALUE=""#income#""">
> 
>  VALUE=""#gender#""">
>  VALUE=""#ride_often#""">
> 
> 
> 
>  VALUE=""#ride_often#""">
> 
> 
> 
> 
> 
>  VALUE=""#if_contact#""">
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>   
>   ">
>MAXLENGTH=50 VALUE=""#Form.firstName#""">
> 
> 
> 
> 
> 
> 
>   
>   ">
>SIZE=30 MAXLENGTH=50
> VALUE=""#Form.lastName#""">
> 
> 
> 
> 
>   
>   ">
> 
>VALUE=""#Form.Address#""> "  >
> 
> 
> 
> 
> 
> 
>   
>   ">
>VALUE=""#Form.Age#""">
> 
> 
> 
> 
> 
>   
>   ">
>MAXLENGTH=50
> VALUE=""#Form.City#""">
> 
> 
> 
> 
> 
>   
>   ">
>MAXLENGTH=50 VALUE=""#Form.StateOrProvince#""">
> 
> 
> 
> 
> 
>   
>   ">
>MAXLENGTH=50 VALUE=""#Form.PostalCode#""">
> 
> 
> 
> 
>   
>   ">
>SIZE=30 MAXLENGTH=50
> VALUE=""#Form.Country#""">
> 
> 
> 
> 
> 
> 
> 
>   
>   
> 
>  greater than 0
> or Dot is 0)>
>   
>   ">
>MAXLENGTH=30 VALUE=""#Form.EmailAddress#""">
> 
> 
> 
> 
> 
>   
>   ">
>MAXLENGTH=12 VALUE=""#Form.HomePhone#""">
> 
> 
> 
> 
> 
> 
>   
>   ">
> 
>VALUE=""#Form.Framemodel#"" >
>
> 
>   Ti Crown Jewel
>   Crown Jewel
>   Independence
>   Planet Cross
>   Deluxe
>   Special
>   Club Racer
> ">
> 
> 
>   
> 
> 
> 
> 
> 
> 
> 
> 
> 
>   
>   ">
> 
> 
> 
> VALUE=""#Form.stockorcustom#"" >
>
>   Stock
>   Custom
> ">
> 
>   
> 
> 
> 
> 
> 
> 
> 
> 
>   
>   ">
>MAXLENGTH=50
> VALUE=""#Form.size#""">
> 
> 
> 
> 
>   
>   ">
>SIZE=30 MAXLENGTH=50
> VALUE=""#Form.serial#""">
> 
> 
> 
> 
>   
>   ">
>MAXLENGTH=50 VALUE=""#Form.dateofpurchase#""">
> 
> 
> 
> 
>   
>   ">
>MAXLENGTH=50
> VALUE=""#Form.color#""">
> 
> 
> 
> 
>   
>   ">
>MAXLENGTH=50 VALUE=""#Form.nameofdealer#""">
> 
> 
> 
> 
> 
>   
>dealer?">
> 
>VALUE=""#Form.dealerlocation#""> "  >
> 
> 
> 
> 
> 
> 
>   
>   ">
> 
> 
> VALUE=""#Form.income#""   >
>
>   Less than $20,000
>   $20k to $30k
>   $31k to $40k
>   $41k to $50k
>   $51k to $60k
>   $61k to $70k
>   $71k to $80k
>   $81k 

RE: Form Validation Question

[John Rice]

Use len(trim(form.formfield)).

Textareas, unless in the format  will not be eq "".

If you have, the texarea has a CRLF in it.




the trim() will ignore the CRLF.


>
This is sort of confusion to explain, but I will try.

I'm attempting to validate a form using the example in MASTERING COLD FUSION
4, pg 390, ex 15.4.

Of course the book example is ultra simple. 3 easy text fields, submits to
another script that validates by checking to see if value is zero. This is
Cold Fusion validation by the way, no Java Script. I would have used, client
side JavaScript but could not get  to give the popup using the
simple message attribute. I know there are other ways w/JavaScript but I'm
deep into this way and I think I am close.

So, submit the form and then the next script checks for zero values. If a
zero value is found, a "you messed up" message is generated and the form
field is re-presented to be fixed. All works well, except I'm using a few
textareas. If the textareas do not get filled out on the "fix it page" and
submitted, they are not giving an error since there is some value in there.





">

 "  >




But, with another Formfield,



">



the above can be submited over and over and will trigger the zero value.


What is wrong with my textareas so they make it past my checking for zero
values??

Here is the complete code from the page:





























































































">








">






">

 "  >







">







">







">







">






">













">







">








">


 

  Ti Crown Jewel
  Crown Jewel
  Independence
  Planet Cross
  Deluxe
  Special
  Club Racer
">













">



 
 
  Stock
  Custom
">











">






">






">






">






">







">

 "  >







">


 
 
  Less than $20,000
  $20k to $30k
  $31k to $40k
  $41k to $50k
  $51k to $60k
  $61k to $70k
  $71k to $80k
  $81k to $90k
  $91k to $100k
  A little over 100k
  way over 100k
   ">









">


 
male
female
  ">










">


 
   
once a week
2 to 4 times a
week
5 or more times a
week
   ">













  Was it helpful? Why or why not?Please answer this
question">

  "  >






">
  "  >






">
  "  >





">
  "  >





">
  "  >





">
  "  >






">
  "  >





">
  "  >






">
  "  >










Sorry. An error occurred.

#Error#
Please correct the error






















  


  

  First Name 
  
 #firstName#



  

  Last Name 
  
  #lastName#



 

  

  Age 
  
  #Age#





  

  Address 
  
  #Address#




  

  City 
  
  #City#



  

  State/Province 
  
#StateOrProvince#



  

  PostalCode 
  
   #PostalCode#



  

  Country 
  
  #Country#



  

  Email Address 
  
   #EmailAddress#



  

  Home Phone 
  
  #HomePhone#



  

  Frame Model 
  
  #Framemodel#



  

  Was the frame stock or custom? 
  
#stockorcustom#



  

  Size 
  
   #size#



  

  Serial Number 
  
   #serial#



  

  Date of Purchase 
  
   #dateofpurchase#



  

  Color 
  
   #color#



  

  Name of Dealer 
  
   #nameofdealer#



  

  Dealer L

"Undcocumented Feature" (Copyright MS) in Coldfusion 4.5 isdefine d() function

[Daniel Lancelot]

This appears to be an error in ColdFusion's isdefined("") function
- the parameter is syntactically valid - I am outputting it successfully on
the line above...

==
Error Diagnostic Information

An error occurred while evaluating the expression: 


 
isdefined("request.XMLPacket.BOOKINGSERVICE.SLOTLIST.slot[#currentslot#].att
ributes.sequencenumber.Value")



Error near line 104, column 8.



Parameter 1 of function IsDefined which is now
"request.XMLPacket.BOOKINGSERVICE.SLOTLIST.slot[1].attributes.sequencenumber
..Value" must be a syntactically valid variable name

~~
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: PL/SQL

[Jeff Britts]

Basically, we're working on a tool to generate the pl/sql script on the fly
so we
cant use a stored proc.  Any ideas?

-Original Message-
From: C Frederic Valone [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 9:54 AM
To: CF-Talk
Subject: Re: PL/SQL


We use cf and pl/sql stored procs extensively. What exactly are you trying
to do?

Jeff Britts wrote:

> Anyone have any luck running PL/SQL through ColdFusion?  The simple stuff
> seems to work ok, but if you throw it something complex it chokes.
>
>
> Jeff Britts
> ColdFusion Engineer
> e-Dialog
>
>
>
~~
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: Read client text file from web server

[Billy Cravens]

It's possible that you could do some reading/parsing using the
FileSystemObject and some client-side JavaScript.  At that point you
could transfer the info to the server.  In all likelihood, a message
will be popped up to the user, since reading their local file system is
a big security issue.  The bottom line is that to read files on the
client's end, there must be some user interaction.

Personally, I'd stick with the file upload method, since that's the most
robust (FileSystemObject only available to IE, and only if their
security settings are set to allow that) solution.

-- 
Billy Cravens
[EMAIL PROTECTED]


Eric Fickes wrote:
> 
> Hello all,
> 
> I am creating a log analyzer cfm page for an internal db application, and
> I've got a question about cf pages reading files.  When I view the page
> locally, I am able to read the log files just fine as is when I use  tyep="file">.  However, when I uploaded this page to my web server, or when
> I asked somebody to test my page, it didn't work because the log file they
> specified is not physically located on my machine.  This makes sense to me.
> So to get around this, I have the page do a file upload to a temp dir, and
> then read the file from the temp dir.  All is well.  And now for my
> question.
> 
> Is there any way for me to make a CF page that will read a user specified
> file without having to upload it to the server 1st?
> 
> E
> 
>
~~
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: oracle sysdate time

[Dan Haley]

You have to specify it in the query itself . . . select to_char(date_field,
'dd-mon- hh24:mi:ss') . . . then once you have it in CF you can do what
you want with it.

Dan

-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 5:31 AM
To: CF-Talk
Subject: oracle sysdate time


anyone know how to get the time part of an oracle date field to show up in a
result. I have a table where "date_entered" is the primary key and when I
query it in oracle developer I see the time (hh:mi:ss)part but not in CF.
createodbcdatetime() does not work
~~
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

BULK INSERT - Access or ODBC incompatibility?

[Michael Gagnon]

Hi!

I am using the SQL7's  "BULK INSERT", but I get the following error:
~~
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: CF Salary info

[C Kong]

sorry about that gena.let's set parameterslets say the US and east 
or west coast earnings

thanks


>:)
>
>Good question! I know people who works for 50$ per month and it is pretty
>good salary.
>
>Try to clarify at least country/city
>
>
>
>- Original Message -
>From: "C Kong" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Friday, December 08, 2000 9:48 AM
>Subject: CF Salary info
>
>
> >
> > new to the forum here and new to coldfusion period.
> >
> > excuse the tacky question, but i was wondering what a CF beginner ,
> > intermediate level, and senior level CF programmer can make in terms of
> > salary out there.
> >
> > company versus free-lance?
~~
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: Server Configuration Question

[Lord, Heath]

Thanks for your input, I appreciate it, but that is not my question.
I am inquiring as to the stability of 4.5.1 sp2  Whether anyone has had
memory leaks or thread issues or other problems.  My server is completly
stable under 4.0.1 so I do not want to do the upgrade unless 4.5.1 is ready.

Heath

-Original Message-
From: Andres Leon [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 9:17 AM
To: CF-Talk
Subject: Re: Server Configuration Question


There are multiple variables that will determine the stability of your
application:

The hardware you have: If you have quadruple processors with over 512mb of
RAM, it will be better than if you just have one processor with 128mb

The type of traffic you are expecting to receive. Talk to your client and
assess their needs and worst case scenarios (1 million hits per second :(  )

The type of application you are hosting: If it is centered in database
access, then you better make sure taht your database is layoud out and
designed optimally. Here is where most of your scalability and performance
issues will reside.

Another rule of thumb is to install as few programs in the server as
possible.This not only helps your system concentrate on the tasks it need s
to acomplish with no background or foreground apps to run, but will also be
safer: There are many applications out there that have security holes
leaving your system vulnerable to attacks (MS Office, REALAudio, MS Windows
Media, etc.)

Godd Luck!


- Original Message -
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, December 08, 2000 5:19 AM
Subject: RE: Server Configuration Question


> > 7 Dec 00   1100
> > I need to get an answer on this ASAP today.
> >
> > We have a server with this configuration.
> > Win2000 Server SP 1
> > IIS 5  As found on CD
> > CF 4.5.1 SP2
> > Oracle 8.1.6 Client
> > 2 CFX Tags  PGP and Graphics (GifGid)
> >
> >
> > Basically, I need to know what the Stability is expected to be with this
> > configuration.
> > How this set-up will effect the Speed.
> > Any Known Memory Leaks that may be of concern to me with this
> > configuration.
> > Any issues with the use of Auto Locking Session Variables, instead of
> > explicitly locking them.  i.e. I don't want to do a whole lot of
> > recoding at this time.
>
> In case you haven't joined CF-Server yet...
>
> Put Oracle on another server - the database server will eat memory, and CF
> will try (if configured properly) to use memory rather than HD, so they'll
> end up fighting for the memory
>
> In the long run, having a dedicated database server is a life saver for
> speed and stability
>
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **
>
>
>
~~
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: CFFILE and IE 5.0 on a Mac doesn't work

[Aaron Johnson]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Craig,

Check out:

http://lookclose.com/learnmore/faqs/macieuploads.htm

Apparently MACs send the file as Macbinary rather than as .gif or
..jpg/.jpeg

Thanks to Ron @ HKSI for this info.

Aaron Johnson, MCSE, MCP+I
MINDSEYE, Inc.
617.350.0339
949.350.8884
66172567
[EMAIL PROTECTED]

___
"Never forget that only dead fish swim with 
the stream." -- Malcolm Muggeridge
___


> -Original Message-
> From: Craig A. Zingerline
> [mailto:[EMAIL PROTECTED]] Sent: Thursday,
> December 07, 2000 3:06 PM
> To: CF-Talk
> Subject: CFFILE and IE 5.0 on a Mac doesn't work
> 
> 
> Hello,
> 
> I'm wondering if anyone has found a workaround to the following
> situation...we are using CFFILE to upload .gif and .jpg files to 
> our server.
> The scripts work fine on Netscape and IE on a PC, but only work
> with Netscape on a Macintosh.  The mac OS is 9.0 and we are using
> IE 
> 5.0.  I have
> a couple of links with relevant information below, but have not 
> been able to
> find (nor do I know) if a workaround to this problem exists.  We
> get the following error code:
> 
> "Error attempting to save uploaded file to path
> 'D:\inetpub\websites\oursite\.' Access is denied. (error 5)"
> 
> Microsoft has a knowledge base article (which doesn't look
> promising) at:
> http://support.microsoft.com/support/kb/articles/Q161/3/95.asp?LN= 
EN-US&SD=g
n&FR=0&qry=RFC%201867&rnk=3&src=DHCS_MSPSS_gn_SRCH&SPR=IE

A thread in the forums about this is at:
http://forums.allaire.com/devconf/Index.cfm?Message_ID=428762

THANK YOU FOR ANY HELP!!  IT IS GREATLY APPRECIATED!

Cheers,

Craig

Craig A. Zingerline
Advanced Media Productions
Web Application Developer
~~
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: Need help interpreting error message.

[Lon Lentz]

  Here's a little of the code before and after the error causing line.


















Lon Lentz
Applications Developer & CyberEntomologist - Alvion Technologies
DataWarehousing and List Sales - Market Your Lists on the Net!
[EMAIL PROTECTED]
941-574-8600 Ext. 210

-Original Message-
From: Thomas Brown [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 07, 2000 11:05 PM
To: CF-Talk
Subject: RE: Need help interpreting error message.


can you send the code surrounding this as well???


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

FW: FileLocking error with CFFile

[Daniel Lancelot]

Any ideas with this?

This error message is displayed (at random) when attempting to overwrite a
file using CFFILE action = "Move"

The code works most of the time, but sometimes displays this error - if the
error is displayed, then waiting a couple of mins and hitting refresh, will
normally execute the cffile fine.  It appears as if the file is getting
locked for some reason.  This is in an admin backend, and is executed just
after a preview of the existing gif file has been shown (might IIS be
locking it?)

Can anyone help suggest a reason/solution? otherwise it means a partial
rewrite of the backend...

-Original Message-
From: Paul Lowton 
Sent: 08 December 2000 15:17
To: Daniel Lancelot
Subject: 


==

Error Diagnostic Information
Error processing CFFILE

Unable to move file
'c:\web_sites\brearleyGreens2\public\fileStore\residential\picsother\temp\pi
cin1137167269.gif' to path
'c:\web_sites\brearleyGreens2\public\fileStore\residential\picsother\picin11
37167269.gif'. Access is denied. (error 5)

The error occurred while processing an element with a general identifier of
(CFFILE), occupying document position (90:3) to (92:108).


Date/Time: 12/08/00 15:21:49
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)
Remote Address: 195.226.55.82
HTTP Referer: 

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

Food for thought...

[Clint Tredway]

Would any of you be interested in a product that could help streamline your
development time and still allow you full control over your code?

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

loops, queries, ug...

[Peter Benoit]

I'm confused!

I have 2 tables in the same database, one table has a list of
subnets(subnets), and the other will contain information on each
subnet(subnet_info).  The subnet in the subnets table is the unique id in
that table, which has a one to many relationship with the subnet in the
subnet_info table.

What I want to do is present a table that would present a subnet, then it's
corresponinding IP's and Info, then repeat for each subnet.  Something like:

208.208.208
IP = 1
Name = boxname
Description = what this box does

208.208.209
ect...

I'm not sure of the best method to do this.  I tried building a query on the
subnet table, then in the  of that query, loop through another
query on the subnet_info table... but it doesn't work.  Any ideas for me how
to do this?

TIA,
Pete


~~
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: Studio 4.5.1 - Setup Question

[Richard Kern]

options,settings, html gets you a switch to turn lower case on for tags.
Otherwise it's as you type.
Richard

-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 07, 2000 6:51 AM
To: CF-Talk
Subject: Studio 4.5.1 - Setup Question


Hello,

I just installed Studio 4.5.1 (finally upgraded from 3.1).  In 3.1 there was
an option to upper case the tags when you inserted them.  I have searched
for two days now, and have been unable to locate this switch in 4.5.1.  Does
it offer that option?  And if so, can someone tell me where it is?

Thanks,
Dave

=
"What we need is a list of specific unknown problems we will encounter"

David Hannum
Web Analyst/Programmer
Ohio University
[EMAIL PROTECTED]
(740) 597-2524
~~
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: Order By Random?

[Richard Kern]

suggest using the tag CF_queryrandomize in the allaire gallery

Richard Kern

-Original Message-
From: Craig M. Rosenblum [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 07, 2000 1:24 PM
To: CF-Talk
Subject: Order By Random?


Is there any way to have a query give the results in random order?

This is for Oracle...
~~
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: Need help interpreting error message.

[Lon Lentz]

I'll check it out. We've been using session.user for a long time. It's in
our login script and is where all the user's settings are loaded in. I don't
think anything in the template has changed. Although there have been a lot
of other changes recently.

Thanks!


Lon Lentz
Applications Developer & CyberEntomologist - Alvion Technologies
DataWarehousing and List Sales - Market Your Lists on the Net!
[EMAIL PROTECTED]
941-574-8600 Ext. 210

-Original Message-
From: David Cummins [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 07, 2000 11:31 PM
To: CF-Talk
Subject: Re: Need help interpreting error message.


Not sure...

Try two things:
(a) Try a different variable name than user.
(b) Try assigning it to a local variable, then setting the session variable
equal to that.

I wonder if session variables don't support structures...

If you're using CFSCRIPT, there may be some error the line before causing it
to
misunderstand what session.user is.


~~
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: List w/" " delims

[Bruce Heerssen]

Sure here you go.




#theList#

Short and sweet.

1. Create the list. Use single quotes to denote the string because the string
contains double quotes.
2. Replace all occurrences of '" "' with ','.
3. Replace the remaining double quotes at the beginning and end of the list with
nothing.

Now you have a standard comma-delimited list.

HTH
-- Bruce

btw - this code will fail if the list contains any double quotes that are not
delimiters.

> -Original Message-
> From: Eric Fickes [mailto:[EMAIL PROTECTED]]
> 
> I was hoping to somehow use " " as a delimeter, but that's not working.
> When I do that it takes out the spaces in the column names. I'd like to take
>
> "Full Name" "Email Address" "Group List" "Login Name"
>
> and turn it into
>
> Full Name,Email Address,Group List,Login Name
>
> Any ideas?
>
> E
>


~~
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: List w/" " delims

[Robyn Follen]

I've tried to user multiple characters as a list delimiter, but whenever I
then try to iterate through the list, specifying my delimiter, it doesn't
work.  E.g., When I have the following code,




#listElement#



I get:

o
ne 
t
wo 
th
ree

because it takes each item in the list of delimiters and checks for them
individually.  Has anyone any insight on how to loop through something with
a particular combination of characters for a delimiter?

Any help would be appreciated,
Robyn


-Original Message-
From: Jeff Britts [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 8:29 AM
To: CF-Talk
Subject: RE: List w/" " delims


You CAN use multiple characters as list delimiters...eg. "|*|".

I do it frequently to cut down on the chances that one of my list items
contains a delimiter.

Jeff Britts
ColdFusion Engineer
e-Dialog



-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 07, 2000 2:21 PM
To: CF-Talk
Subject: Re: List w/" " delims


Keep in mind that list delimiters can only be 1 character.

-- 
Billy Cravens
[EMAIL PROTECTED]


Eric Fickes wrote:
> 
> Got a List question for you.
> 
> I've got a text file that I need to parse and it's " delimited list, in a
> way.  The list format is this.
> 
> "Full Name" "Email Address" "Group List" "Login Name"
> "Demo user for startup" "" " 1;" "Demo"
> 
> I was hoping to somehow use " " as a delimeter, but that's not working.
> When I do that it takes out the spaces in the column names. I'd like to
take
> 
> "Full Name" "Email Address" "Group List" "Login Name"
> 
> and turn it into
> 
> Full Name,Email Address,Group List,Login Name
> 
> Any ideas?
> 
> E
> 
>
~~
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: CF outputing SQL Server int field with decimal's?

[Sandra Clark]

Their web page has all the current information on it.
http://www.sccfug.org/

-Original Message-
From: Kinley Pon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 07, 2000 4:33 PM
To: CF-Talk
Subject: RE: CF outputing SQL Server int field with decimal's?


Hello Sandra,

You mentioned of a LA CFUG.  Is this the Los Angeles CFUG?  If so, GREAT.  I
was wondering if there was a user group here.  I live in Monterey Park.
Where is meeting held and when?

Justme
Kinley

-Original Message-
From: Sandra Clark [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 06, 2000 4:31 PM
To: CF-Talk
Subject: RE: CF outputing SQL Server int field with decimal's?

This came up in our LA CFUG meeting last night.  Apparently the behavior in
how CF sees a number was changed internally from 4.0 to 4.5.1.

CF doesn't know the difference between a precision variable and an int.  It
just sees a number.

Use NumberFormat() or Int to display correctly.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 04, 2000 10:27 AM
To: CF-Talk
Subject: CF outputing SQL Server int field with decimal's?


I've successfully upsized an access 2000 db
to SQL Server 6.5 using SQL Server 7.0 import
export wizard, when I cfoutput the data or look
at the table data through rds the integer fields
are of the format:

1.00
2.00
2,345.00

instead of:

1
2
2345

But, when I query the db with the query tool in SQL
Server 6.5 I get the correct output of:

1
2
2345

Any integer fields are like this now including index's
and primary key's.

When I run the following query:


SELECT BillID,BillNumber
FROM Bills
WHERE SessionID = 2001
 AND BillNumber = 4


#editdb.RecordCount#


#BillID#  - #BillNumber#
#int(BillID)# - #int(BillNumber)#


I get:

1
51.00 -  4.00
51 - 4

So this really screws things up. If I can't find a way
to keep the integer fields whole number I'll have to
change alot of code to int(BillNumber), etc.

Anyone have any ideas what I did wrong or how I could
fix what I've got.

Thanks.

Ric Smith
h_o_l_o_g_r_a_p_h_i_c
103 Meridian St.
Tallahassee, Florida
32301
www.holographic.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

Form Validation Question

[Jeff Fongemie]

This is sort of confusion to explain, but I will try.

I'm attempting to validate a form using the example in MASTERING COLD FUSION
4, pg 390, ex 15.4.

Of course the book example is ultra simple. 3 easy text fields, submits to
another script that validates by checking to see if value is zero. This is
Cold Fusion validation by the way, no Java Script. I would have used, client
side JavaScript but could not get  to give the popup using the
simple message attribute. I know there are other ways w/JavaScript but I'm
deep into this way and I think I am close.

So, submit the form and then the next script checks for zero values. If a
zero value is found, a "you messed up" message is generated and the form
field is re-presented to be fixed. All works well, except I'm using a few
textareas. If the textareas do not get filled out on the "fix it page" and
submitted, they are not giving an error since there is some value in there.





">

 "  >




But, with another Formfield,



">



the above can be submited over and over and will trigger the zero value.


What is wrong with my textareas so they make it past my checking for zero
values??

Here is the complete code from the page:





























































































">








">






">

 "  >







">







">







">







">






">













">







">








">


 

  Ti Crown Jewel
  Crown Jewel
  Independence
  Planet Cross
  Deluxe
  Special
  Club Racer
">













">



 
 
  Stock
  Custom
">











">






">






">






">






">







">

 "  >







">


 
 
  Less than $20,000
  $20k to $30k
  $31k to $40k
  $41k to $50k
  $51k to $60k
  $61k to $70k
  $71k to $80k
  $81k to $90k
  $91k to $100k
  A little over 100k
  way over 100k
   ">









">


 
male
female
  ">










">


 
   
once a week
2 to 4 times a
week
5 or more times a
week
   ">













  Was it helpful? Why or why not?Please answer this
question">

  "  >






">
  "  >






">
  "  >





">
  "  >





">
  "  >





">
  "  >






">
  "  >





">
  "  >






">
  "  >










Sorry. An error occurred.

#Error#
Please correct the error






















  


  

  First Name 
  
 #firstName#



  

  Last Name 
  
  #lastName#



 

  

  Age 
  
  #Age#





  

  Address 
  
  #Address#




  

  City 
  
  #City#



  

  State/Province 
  
#StateOrProvince#



  

  PostalCode 
  
   #PostalCode#



  

  Country 
  
  #Country#



  

  Email Address 
  
   #EmailAddress#



  

  Home Phone 
  
  #HomePhone#



  

  Frame Model 
  
  #Framemodel#



  

  Was the frame stock or custom? 
  
#stockorcustom#



  

  Size 
  
   #size#



  

  Serial Number 
  
   #serial#



  

  Date of Purchase 
  
   #dateofpurchase#



  

  Color 
  
   #color#



  

  Name of Dealer 
  
   #nameofdealer#



  

  Dealer Location 
  
  #dealerlocation#


  
Your
  Income
  
 #income#







  

  Gender 
  

Re: PL/SQL

[C Frederic Valone]

We use cf and pl/sql stored procs extensively. What exactly are you trying to do?

Jeff Britts wrote:

> Anyone have any luck running PL/SQL through ColdFusion?  The simple stuff
> seems to work ok, but if you throw it something complex it chokes.
>
>
> Jeff Britts
> ColdFusion Engineer
> e-Dialog
>
>
>
~~
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: wddx --> SQL Server 7 ?

[mark_wimer]

Thanks Paul and David,

Paul, the updategram sounds about right, although I'll have to read more in
depth. Wish I had SQL 2000. David, I cannot just insert - although I didn't
specify this in my message originally, I need to insert (non-xml) into
multiple fields, and I don't even know which fields ahead of time. This
latter part had me worried until I remembered the dynamic evalulation
functionality with sp_executesql inside a stored proc.

I'll have to experiment with performance on the NOCOUNT thing and having
SQL do a little parsing work.

Thanks again!

Mark

Mark Wimer, Bird Point Count Database
American Bird Conservancy, c/o
USGS-Patuxent Wildlife Research Center
12100 Beech Forest Road, Laurel, MD  20708-4038
Ph: 301-497-5596   Email: [EMAIL PROTECTED]


> 1. CFLOOP through structure in CF, doing insert statements (I won't do
> this: too many db calls from CF).

you could loop thru inside just one cfquery remembering to wrap
the whole mess in SET NOCOUNT ON/OFF block.

> 2. Use CF to create a large string, pass that to stored proc, parses and
> loop through with inserts. I can do this.

sql is not too good at this.

> 3. Create wddx packet, send that to a stored proc somehow. This is what
I'd
> like to do.

you're a bit ahead of your time w/this. what you're after is i guess
"updategrams" that kinda work (i know of no production sites
doing this) in sql server 2000. in any case, see this article:
http://msdn.microsoft.com/library/periodic/period00/TheXMLFiles.htm
~~
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