Cfquery Statements and when are they executed ?????

[AustralianAccommodation.com Pty. Ltd.]

I have a series of cfquery statements at the top of the page as soon as that
page is activated does the server take time to search for all those query
results or rather does the cf server wait until the query is requested
further down the page from that specific cfquery statement before the
cfquery statement runs the query

why am I asking

I have a page that has multiple forms on the one page each separated by cfif
statements to ensure the appropriate form is executed when specific
conditions are met. Each of the forms have a series of unique cfquery
statements and I am wondering should I place all the cf query statements for
all the forms at the top of the page before I star running the cfif
condition tags or should the appropriate cf query statements be placed
directly after each opening cfif tag

I look forward to your comments and advice

thank you in advance for you assistance



Kind Regards

Claude Raiola (Director)
AustralianAccommodation.com Pty. Ltd.
Website: www.AustralianAccommodation.com
Email: [EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Read HTTP Headers

[Dave Watts]

> Does anyone know of a way to read raw http headers from a
> form post?  For instance, a form posts to a CF action page;
> other than the form fields, is there any way for the CF action
> page to get at the other information in the file header?

No, CF doesn't allow you to read HTTP request headers directly. There are
ways around this, but they all involve posting to a non-CF page.

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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Need help from a pro

[Mike Weaver]

This is a multi-part message in MIME format.

--=_NextPart_000_0028_01BFF9B1.CB80B280
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello,
   I am in need of guidance on dates. I  am using an Access db.  and =
have a query which generates records between 2 dates you enter in a =
form.  The date input for each record is the automatic access db =
function.

I can't seem to get the #DateFormat(Now())# to work in single or double =
quotes so I used the auto function.  When I run the query I get an error =
of division by zero.

Any assistance is greatly appreciated.

Mike

--=_NextPart_000_0028_01BFF9B1.CB80B280
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Hello,
   I am in need of guidance =
on=20
dates. I  am using an Access db.  and have a query =
which=20
generates records between 2 dates you enter in a form.  The date =
input for=20
each record is the automatic access db function.
 
I can't seem to get the =
#DateFormat(Now())# to=20
work in single or double quotes so I used the auto function.  When =
I run=20
the query I get an error of division by zero.
 
Any assistance is greatly=20
appreciated.
 
Mike

--=_NextPart_000_0028_01BFF9B1.CB80B280--

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Testing number of characters in CFform textarea

[AustralianAccommodation.com Pty. Ltd.]

I am wanting to limit the number of characters being entered into a multi
lined text area cfform

does cf allow for in the design of the form to limit the input of characters
to a pre determined number preventing the data input of any further
characters (keeping in mind this is a multi lined form so the user is able
to easily read their input)

or does the form need to be submitted by the user and at the time of
submission cf test to the number of characters prior to updating the
datafield in the database

or do I have to set the max characters in the memo field of the database to
the max number of characters accepted and when those characters are exceeded
the database prevents the update and an appropriate error message is
displayed

I look forward to your comments / suggestions in this regard and thank you
in advance

Kind Regards

Claude Raiola (Director)
AustralianAccommodation.com Pty. Ltd.
Website: www.AustralianAccommodation.com
Email: [EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

CF-Talk V1 #109

[justin]

Hello

I am on holiday until Monday 14th of August.  Please phone Electrum on 0131 555 4241 
if it cannot wait until then.

Cheers




_
This message has been checked for all known viruses by Star Internet delivered
through the MessageLabs Virus Control Centre. For further information visit
http://www.star.net.uk/stats.asp
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Mapping "literally"

[Mike Weaver]

Thanks very much!

Mike
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 26, 2000 7:20 AM
Subject: Re: Mapping "literally"


>
> Products from MapInfo, http://www.mapinfo.com/, work for us.  MapXtreme is
> the more costly product but you can do what you want with MapXcite to
> handle the 'displaying' of the data and MapInfo to create the map.  You
end
> up with a static map onto which variable data can be placed.  If your data
> is static, you may only need MapInfo.  The people at MapInfo are very nice
> and helpful.
>
>
>
>
>
> "Mike Weaver" <[EMAIL PROTECTED]> on 07/26/2000 10:16:51 AM
>
> Please respond to [EMAIL PROTECTED]
>
> To:   <[EMAIL PROTECTED]>
> cc:
>
> Subject:  Mapping "literally"
>
>
> This is a multi-part message in MIME format.
>
> --=_NextPart_000_0022_01BFF6D1.782A5060
> Content-Type: text/plain;
>  charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Does anyone know of code that would enable one to plot locations on a =
> map based on Zip Code.   I want to visually display on a southeast =
> regional map "dots" to indicate the location of an input to my =
> application based on Zip Code.  I have seen this in another site.
>
> Thanks in advance.
>
> Mike
>
> --=_NextPart_000_0022_01BFF6D1.782A5060
> Content-Type: text/html;
>  charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> 
> 
>  charset=3Diso-8859-1">
> 
> 
> 
> 
> Does anyone know of code that would =
> enable one to=20
> plot locations on a map based on Zip Code.   I want to =
> visually=20
> display on a southeast regional map "dots" to indicate the location of =
> an input=20
> to my application based on Zip Code.  I have seen this in another=20
> site.
>  
> Thanks in advance.
>  
> Mike
> --=_NextPart_000_0022_01BFF6D1.782A5060--
>
> --

>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
>
>
>
>
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Image Submits & Fusebox

[Ian Potts]

Examine the formurl2attributes tag. There is a section in the newest
version that allows you to use images as submit buttons:
>From the formurl2attributes file:

This is so that you can have multiple type="image" buttons on the same
page, if  you name the button name="fuseaction_[the value you want]" it
will set the fuseaction to that value.

Ian

"Geoffrey V. Brown" wrote:
> 
> Hi,
> I know this probably should go to the fusebox list, however, I've been
> having problems posting to it.  Maybe one of you could give me a hand with
> the problem below...
> 
> I have a project that requires that form submit buttons use images.  This
> creates a problem when trying to make this app fusebox compliant.  In normal
> situations, I would do the following using a submit button:
> 
> 
> Returns: #form.fuseaction# = dothis
> 
> However, given that I have multiple image submits in a single form, each
> must have a separate name.  As most of you know, you can not assign an
> explicit value to an image submit, as it returns mouse coordinates as the
> form value.  Example:
> 
>  height="10" width="10">
> Returns: form.fuseaction.x = 4 (any number) and form.fuseaction.y = 9 (any
> number).
> 


-- 
Ian Potts
CenterGate Research Group, LLC.
http://www.centergate.com
"Technology so advanced, even we don't understand it!"(SM)
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: cfmail sedning bare linefeeds (LF)

[Ian Potts]

I ran in to this problem w/CF 4.5.1 -> Linux Qmail SMTP Server. If you
have cf templates saved in unix format using SMTP qmail will not send
the mail, and complains about the bare line feeds. If you use the
unix2dos program to convert all templates using cfmail to "dos" format,
then it will accept the mail. 

Ian

Nicklas af Ekenstam wrote:
> 
> Hi
> 
> I get this in my mail.log when using cfmail to send emails through my mail
> server.
> "Error","TID=2540","07/27/00","16:05:24","Failed to send the spooled mail
> file, C:\CFUSION\MAIL\spool\7B9.cfmail. SMTP server replied "See
> http://pobox.com/~djb/docs/smtplf.html." Moved file to
> C:\CFUSION\MAIL\undelivr\7BB.cfmail."
> 
> As you can see by reading the document at
> http://pobox.com/~djb/docs/smtplf.html cf is sending a bare linefeed which
> is "a bad thing"(tm).
> Any comments on this from you cf-gurus?
> 
> //Nille
> 
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

-- 
Ian Potts
CenterGate Research Group, LLC.
http://www.centergate.com
"Technology so advanced, even we don't understand it!"(SM)
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: SQL and apostrophes

[Jake Hileman]

Here...


SELECT Name, Address1, Address2, City, Phone
FROM Centers
WHERE City IN (#PreserveSingleQuotes(List)#)



You have to use PreserveSingleQuotes.  Let me know PLEASE if this helped
anyone!

thanks,

Jake
- Original Message -
From: "Brian W. Zaleski, DC, MS" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, July 29, 2000 1:50 PM
Subject: Re: SQL and apostrophes


> Jake,
>
> I may be totally off base, but in ASP you do something like this:
>
> Function RequestDQ (VarName)
> RequestDQ = Replace (Request(VarName), "'", "''")
> End Function
>
> The SQL output that is returned to the page is normal (i.e. even though it
> puts in O''Rielly to the SQL Server when it is displayed to the page it is
> O'Rielly). It appears that for once MicroShaft got something right.
>
> Try the same thing in CF:
>
> 
> 
>
> 
>
> 
> 
>
> 
>
> 
>
>  dbtype="ODBC">
> DELETE FROM TEST WHERE JobID = 123
> 
>
> 
>
> 
> INSERT INTO TEST (Name, JobId) VALUES ('#varUnSafeAtAnySpeed#', 123)
>  --->
>
> varUnSafeAtAnySpeed=#varUnSafeAtAnySpeed#
>
> 
> 
> 
> 
>
> 
> 
> INSERT INTO TEST (Name, JobId) VALUES ('#varSQLSafeName#', 123)
> 
>
> varSQLSafeName=#varSQLSafeName#
>
> 
> 
> INSERT INTO TEST (Name, JobId) VALUES ('O''Reilly Hard-Code', 123)
> 
>
>  dbtype="ODBC">
> SELECT * FROM TEST JobId WHERE JobID = 123 ORDER BY CreateDate
> 
>
> 
> Results= #Name#
> 
>
> These are the results on the page:
>
> varUnSafeAtAnySpeed=O''Reilly
> varSQLSafeName=O''Reilly from form
>
> Results= O'Reilly Hard-Code
> Results= O''Reilly from form
>
> You don't run into these problems when you use cfstoredproc on SQL Server.
> Any other suggestions would be welcomed.
>
> Brian Zaleski
> [EMAIL PROTECTED]
>
>
> >I did just that. Now if the field has a double quote in it, it gets cut
off
> at that point (it looks like the end of the string). :-(
>
> >At 04:18 PM 7/28/00 -0400, Jake Hileman wrote:
> >Just put it between double quotes. Most datatypes use doublequotes
anyhow..
> >so it would be
> >last_name="O'Brien" and you should be okay.
> >
> >let me know if i'm retarded or not.. i probably am :-)
> >
> >jake
> >- Original Message -
> >From: "Peter Theobald" <[EMAIL PROTECTED]>
> >To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> >Sent: Friday, July 28, 2000 1:23 PM
> >Subject: Re: SQL and apostrophes
> >
> >> I'm having the same problem.
> >>
> >> At 04:03 PM 7/27/00 -0600, Nick Call wrote:
> >> >Any SQL Server 7 gurus out there that know how to allow apostrophe's
in
> >SQL
> >> >statements?  For example, last_name = 'O'Brien' chokes the query.
> >> >
> >> >TIA.
> >> >Nick
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Help! - Passing image file data with wddx

[Jonathan Fisher]

This is a multi-part message in MIME format.

--=_NextPart_000_0011_01BFF9C9.E05FCA20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi everyone,

I'm trying to use wddx to pass an image file from one site to another =
over the web. I've followed the examples in the documentation and think =
I'm on the right track, but end up with the following error :

Error Occurred While Processing Request
  Error Diagnostic Information
  XML parsing error: not well-formed (error code 4, line 1, column =
9, buffer offset 9)=20


  The error occurred while processing an element with a general =
identifier of (CFWDDX), occupying document position (10:1) to (10:65).


  Date/Time: 07/30/00 01:10:29
  Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
  Remote Address: 127.0.0.1
  HTTP Referer: http://127.0.0.1/packets/send.cfm=20

=20




Here's the code I'm using - can anyone point out where I'm going wrong?

Sending Page:




Testing  Sending data















The converted to printable data is:...

#q#



Serializing CFML data...



Resulting WDDX packet is:
#wddxText#




  
   
   
  =20






Receiving Page :


Deserializing WDDX packet...
















The newly saved image is:...






Thanks,

J


--=_NextPart_000_0011_01BFF9C9.E05FCA20
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Hi everyone,
 
I'm trying to use wddx to pass an =
image=20
file from one site to another over the web. I've followed the =
examples in=20
the documentation and think I'm on the right track, but end up with the=20
following error :
 

Error Occurred While Processing Request


  
  

  Error Diagnostic Information
  XML parsing error: not well-formed (error code 4, line 1, =
column 9,=20
  buffer offset 9)=20
  
  The error occurred while processing an element with a general=20
  identifier of (CFWDDX), occupying document position (10:1) to =
(10:65).
  
  Date/Time: 07/30/00 01:10:29Browser: Mozilla/4.0 =
(compatible; MSIE=20
  5.01; Windows NT 5.0)Remote Address: 127.0.0.1HTTP =
Referer: http://127.0.0.1/packets/send.cfm">http://127.0.0.1/packets/send.=
cfm=20

  
 
Here's the code I'm using - can anyone point out where I'm going =
wrong?
Sending Page:
   =20







The converted to =
printable data=20
is:...
   =20
#q#

Serializing CFML=20
data...

Resulting WDDX packet=20
is:
<CFOUTPUT>#wddxText#</CFOUTPUT>=


  
         

 
Receiving Page :
Deserializing=20
WDDX packet...






The newly saved image is:...


 
Thanks,
J

--=_NextPart_000_0011_01BFF9C9.E05FCA20--


__
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: SQL and apostrophes

[Brian W. Zaleski, DC, MS]

Jake,

I may be totally off base, but in ASP you do something like this:

Function RequestDQ (VarName)
RequestDQ = Replace (Request(VarName), "'", "''")
End Function

The SQL output that is returned to the page is normal (i.e. even though it
puts in O''Rielly to the SQL Server when it is displayed to the page it is
O'Rielly). It appears that for once MicroShaft got something right.

Try the same thing in CF:














DELETE FROM TEST WHERE JobID = 123





INSERT INTO TEST (Name, JobId) VALUES ('#varUnSafeAtAnySpeed#', 123)
 --->

varUnSafeAtAnySpeed=#varUnSafeAtAnySpeed#








INSERT INTO TEST (Name, JobId) VALUES ('#varSQLSafeName#', 123)


varSQLSafeName=#varSQLSafeName#



INSERT INTO TEST (Name, JobId) VALUES ('O''Reilly Hard-Code', 123)



SELECT * FROM TEST JobId WHERE JobID = 123 ORDER BY CreateDate



Results= #Name#


These are the results on the page:

varUnSafeAtAnySpeed=O''Reilly
varSQLSafeName=O''Reilly from form

Results= O'Reilly Hard-Code
Results= O''Reilly from form

You don't run into these problems when you use cfstoredproc on SQL Server.
Any other suggestions would be welcomed.

Brian Zaleski
[EMAIL PROTECTED]


>I did just that. Now if the field has a double quote in it, it gets cut off
at that point (it looks like the end of the string). :-(

>At 04:18 PM 7/28/00 -0400, Jake Hileman wrote:
>Just put it between double quotes. Most datatypes use doublequotes anyhow..
>so it would be
>last_name="O'Brien" and you should be okay.
>
>let me know if i'm retarded or not.. i probably am :-)
>
>jake
>- Original Message -
>From: "Peter Theobald" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Friday, July 28, 2000 1:23 PM
>Subject: Re: SQL and apostrophes
>
>> I'm having the same problem.
>>
>> At 04:03 PM 7/27/00 -0600, Nick Call wrote:
>> >Any SQL Server 7 gurus out there that know how to allow apostrophe's in
>SQL
>> >statements?  For example, last_name = 'O'Brien' chokes the query.
>> >
>> >TIA.
>> >Nick

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Cold fusion on IE & Netscape

[Shane]

One thing, check to make absolutely sure that you have closed every TR  and
TD tag if you have tables...  I've found that NS is not at all forgiving of
that. Four nested tables, one missing TD tag somewhere in the middle and
your entire page loads blank in Netscrape.



Shane


- Original Message -
From: "Nagesh Kumar Deva" <[EMAIL PROTECTED]>
To: "Cold Fusion (E-mail)" <[EMAIL PROTECTED]>
Sent: Saturday, July 29, 2000 2:12 AM
Subject: Cold fusion on IE & Netscape


> hi all,
>
> I strucked up with one problem. ie My application is not at all loading
when
> i run on netscape, itz working fine when i run on IE 5.0
>
> Just i'm thinking that the page which suppose to load after login has got
> lot of javascript and wddx packets. Is it the problem with Netscape. Does
> Netscape supports JS & WDDX? Otherwise it is problem with the coldfusion?
>
> if it supports, then why i could not able to run the application.
>
> thanx in advance
> nagesh
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: CFLOCKs.... is this really necessary? - hold on a sec

[Zachary Bedell]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

> > That's not strictly true.  If you're never EVER going to 
> > write to the variable (CFSET) beyond the first write, 
> > then you can afford to not lock it.
> 
> True, but since READONLY locks impose just about no 
> performance degredation (unless an exclusive lock is 
> in effect), why not just lock all reads AND writes, 
> no matter how static the variable?  If it truly is a 
> write once, read forever type of value then a bunch 
> of concurrent readonly locks aren't going to do much 
> damage.

Establishing & releasing a lock *does* take some processor time even
if it's a readonly lock w/ no exclusive locks in place.  It's not a
lot, but locks aren't free either.  If you're locking in a case where
you, the programmer, know it isn't nessary, all those locks & unlocks
can add up to some extra processor available.

It's also a matter of convenience.  With something like
Application.DSN that's used on every single page request, it gets
obnoxious to have to lock it every single time.  It's certainly NOT a
bad idea to do it, and if CFStudio added some facility to handle
locking automatically, that'd be nice.  The reason I don't lock every
single read, tho, is mostly because I'm too darn lazy to go in & fix
20,000 lines of code... (I know, I know... Poor me, right? ;-)

 
> On the other hand, if a situation ever WERE to arise where 
> the value was being written do, the readonly locks would 
> kick in.  Better to have the app take a performance hit 
> (even a small one) than risk memory corruption and
> its group of buddies (pCode errors anyone?)

Very true.  Better safe than sorry is certainly the best approach.
 
> Finally, locking ALL access to the shared scopes helps 
> prevent problems in the future. For example, if your 
> application were ever to change in such a way that those 
> once "constant" values become more variable in nature, if
> you've made a habit of locking your reads as well as writes 
> then you won't have to worry.  On the other hand, if you 
> design an app with the assumption that a given variable will 
> never be written more than once, and then that changes, you 
> will have to go back through your code and add a bunch of locks.

That's a matter of good programming practice.  If you define
something as constant, you'd better make sure that it is indeed
constant.  When there's any doubt, I lock it, but for things like
DSNs, ApplicationName, HomePage, AdminEmail, etc., those aren't ever
going to change during code execution.  They MAY change in the
application.cfm if one of those bits of information is renamed, but
in that case, I'd likely restart CFAS to make the changes kick in as
everything is included in if IsDefined("") blocks anyways.

> 
> > Okay..  I may have overstated that.  Let's say that, "Good CFML
> > programming practice dictates that IT IS AN ABSOLUTE NECESITY
> > THAT YOU .."
> 
> Very well put.
> 
> > Like any good rule, if you really know what you're doing, you can
> > afford to bend it from time to time.
> 
> That's true, but I still don't see how doing so has any 
> benefits, given that readonly locks by themselves don't 
> really harm an application.

Chalk it up to LPD (Lazy Programmer's Disease) -- A truely horrible
malady for certain...

What I'd *like* to see is either a feature added to Studio (That's
right, Allaire.  EARN your $500!), or an add on code sanitizer of
some sort that would act like Java's compiler does.  Some of the
things it should do include:

* Check for locking, and REARRANGE your code if it needs to add
locking (apon your approval, of course).
* Ensure that ALL variables MUST have some value before it allows you
to access them.  For anything that's coming in from a Form, etc., it
should FORCE a CFPARAM tag for that variable.
* Check for syntax errors BEFORE the code is sent to the server.  By
most reports, parsing bad CFML takes its tole on the server over
time, so it'd be nice if something could attempt to PCode a template
before you throw it at the server.
* Check SQL Syntax
* Lots of other good stuff that I can't think of off the top of my
head

(Hey, I can dream, can't I?...)

Best regards,
Zac Bedell

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.3 for non-commercial use 
Comment: Please use PGP!!!

iQA/AwUBOYL4FQraVoMWBwRBEQLQ9gCePKTjXlyqIhb9RNwFKiRvSN35oM4An0U6
VYGRXwhHqoRC4MyY2FMJsM0L
=tp8L
-END PGP SIGNATURE-
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Need help with delete function

[Jon Tillman]

On Sat, 29 Jul 2000, Chris Evans spewed forth into the void:
> Oops.  Should be  ListDeleteAt(session.productId,ListPosition)>
> 
> 
> Chris Evans
> [EMAIL PROTECTED]
> http://www.fuseware.com
> 
> 
Thanks, now it works. one more question though: how would I create a button
that did that? As it stands now, it deletes a new product every time the module
is reloaded.

-- 
This Email is 100% Virus Free! How do I know?
Because no Microsoft products were used to 
generate it!

:::
 Jon Tillman
 LINUX USER: #141163
 ICQ: 4015362
 [EMAIL PROTECTED]
 http://tillman.freehosting.net
:::
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Need help with delete function

[Chris Evans]

Oops.  Should be 


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


-Original Message-
From: Jon Tillman [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 29, 2000 11:05 AM
To: [EMAIL PROTECTED]
Subject: RE: Need help with delete function


On Sat, 29 Jul 2000, Chris Evans spewed forth into the void:
> 
> 

It throws an error as follows:
There is no ColdFusion function named ListDelete. Check the spelling of the
function name in the ColdFusion documentation

>
>
> Chris Evans
> [EMAIL PROTECTED]
> http://www.fuseware.com
>
>
>
> -Original Message-
> From: Jon Tillman [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, July 29, 2000 9:07 AM
> To: [EMAIL PROTECTED]
> Subject: Need help with delete function
>
>
> I am at a loss here. I have a catalog I am building, and in the shopping
> cart
> part of it, I need to be able to delete individual items from it. They are
> stored in a variable (session.productId) as a list of numbers
(1,55,34,44).
> What I need my delete function to do is remove one of the numbers from
that
> list. I cannot figure out how to do this at all. Anyone feel like showing
me
> how it could be done?
>
>
> --
> This Email is 100% Virus Free! How do I know?
> Because no Microsoft products were used to
> generate it!
>
> :::
>  Jon Tillman
>  LINUX USER: #141163
>  ICQ: 4015362
>  [EMAIL PROTECTED]
>  http://tillman.freehosting.net
> :::
> --
--
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
This Email is 100% Virus Free! How do I know?
Because no Microsoft products were used to
generate it!

:::
 Jon Tillman
 LINUX USER: #141163
 ICQ: 4015362
 [EMAIL PROTECTED]
 http://tillman.freehosting.net
:::

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Need help with delete function

[Jon Tillman]

On Sat, 29 Jul 2000, Chris Evans spewed forth into the void:
> 
> 

It throws an error as follows:
There is no ColdFusion function named ListDelete. Check the spelling of the 
function name in the ColdFusion documentation

> 
> 
> Chris Evans
> [EMAIL PROTECTED]
> http://www.fuseware.com
> 
> 
> 
> -Original Message-
> From: Jon Tillman [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, July 29, 2000 9:07 AM
> To: [EMAIL PROTECTED]
> Subject: Need help with delete function
> 
> 
> I am at a loss here. I have a catalog I am building, and in the shopping
> cart
> part of it, I need to be able to delete individual items from it. They are
> stored in a variable (session.productId) as a list of numbers (1,55,34,44).
> What I need my delete function to do is remove one of the numbers from that
> list. I cannot figure out how to do this at all. Anyone feel like showing me
> how it could be done?
> 
> 
> --
> This Email is 100% Virus Free! How do I know?
> Because no Microsoft products were used to
> generate it!
> 
> :::
>  Jon Tillman
>  LINUX USER: #141163
>  ICQ: 4015362
>  [EMAIL PROTECTED]
>  http://tillman.freehosting.net
> :::
> 
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> 
> 
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
-- 
This Email is 100% Virus Free! How do I know?
Because no Microsoft products were used to 
generate it!

:::
 Jon Tillman
 LINUX USER: #141163
 ICQ: 4015362
 [EMAIL PROTECTED]
 http://tillman.freehosting.net
:::
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: CFMAIL and multiple attachments

[Chris Evans]

In CF4.5, you can use the CFMAILPARAM tag to add additional headers.  This
is not supported in previous version. If you using a previous version, you
can use CFX_MAIL from Fuseware (http://www.fuseware.com) to do the same
thing.


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

-Original Message-
From: JRose [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 29, 2000 10:18 AM
To: [EMAIL PROTECTED]
Subject: CFMAIL and multiple attachments



greetings list,

Is it possible to attach multiple files to a single
email message with CFMAIL?  There is nothing in the
documentation.

It certainly seems like you should be able to do this.

Any help greatly appreciated.

- Jeffrey


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

More shopping cart questions

[Jon Tillman]

Thanks Chris, for the delete function.

I have another quandry though:
I would like to create a session.variable for the quantity of product the
customer is ordering, and pass it to my purchase module. How do I create a
session.variable from either an  or  tag?

 -- 
This Email is 100% Virus Free! How do I know?
Because no Microsoft products were used to 
generate it!

:::
 Jon Tillman
 LINUX USER: #141163
 ICQ: 4015362
 [EMAIL PROTECTED]
 http://tillman.freehosting.net
:::
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

CFMAIL and multiple attachments

[JRose]

greetings list,

Is it possible to attach multiple files to a single
email message with CFMAIL?  There is nothing in the
documentation.

It certainly seems like you should be able to do this.

Any help greatly appreciated.

- Jeffrey

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

ODBC Error S1009-Invalid path?

[Joe Tartaglia]

I am getting the following error when I try to 
a datasource that I was able to verify using the CF
Administrator:

 ODBC Error Code = S1009 (Invalid argument value), 
 [Microsoft][ODBC Microsoft Access 97 Driver] 
 '\\Pluto\clients\highcaliber\PMT' isn't a valid path. 

 Make sure that the, path name is spelled correctly and that 
 you are connected to the server on which the file resides.

The path shown does exist and, like I said, I can verify the
datasource in CF admin.  MS Access database running on Win NT
server, IIS, CF v4.01.  Other CF datasources are working fine
on this server.


What am I doing wrong?

TIA

Joe Tartaglia
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CFLOCKs.... is this really necessary? - hold on a sec

[Seth Petry-Johnson]

> That's not strictly true.  If you're never EVER going to write to the
> variable (CFSET) beyond the first write, then you can afford to not
> lock it.

True, but since READONLY locks impose just about no performance degredation
(unless an exclusive lock is in effect), why not just lock all reads AND
writes, no matter how static the variable?  If it truly is a write once,
read forever type of value then a bunch of concurrent readonly locks aren't
going to do much damage.

On the other hand, if a situation ever WERE to arise where the value was
being written do, the readonly locks would kick in.  Better to have the app
take a performance hit (even a small one) than risk memory corruption and
its group of buddies (pCode errors anyone?)

Finally, locking ALL access to the shared scopes helps prevent problems in
the future. For example, if your application were ever to change in such a
way that those once "constant" values become more variable in nature, if
you've made a habit of locking your reads as well as writes then you won't
have to worry.  On the other hand, if you design an app with the assumption
that a given variable will never be written more than once, and then that
changes, you will have to go back through your code and add a bunch of
locks.

> Okay..  I may have overstated that.  Let's say that, "Good CFML
> programming practice dictates that IT IS AN ABSOLUTE NECESITY THAT
> YOU .."

Very well put.

> Like any good rule, if you really know what you're doing, you can
> afford to bend it from time to time.

That's true, but I still don't see how doing so has any benefits, given that
readonly locks by themselves don't really harm an application.

Best regards,
Seth Petry-Johnson
Argo Enterprise and Associates

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Reading List Ideas

[cftalk]

http://www.forta.com/cf/bookshelf/

- Original Message -
From: "Jon Tillman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, July 29, 2000 3:05 PM
Subject: Reading List Ideas


Hi all,
I am relatively new to ColdFusion, and was wondering:
Does anyone here have a list of books that would be considered
recommended/required reading for someone learning ColdFusion, who is coming
from a HTML/XML background, and knows very little about databases and such?

Thanks

 --
This Email is 100% Virus Free! How do I know?
Because no Microsoft products were used to
generate it!

:::
 Jon Tillman
 LINUX USER: #141163
 ICQ: 4015362
 [EMAIL PROTECTED]
 http://tillman.freehosting.net
:::

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: CFLOCKs.... is this really necessary? - hold on a sec

[Zachary Bedell]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

> > > http://www.sys-con.com/coldfusion/archives/0208/Forta/
> > >
> > > I think Ben explains this pretty good here.
> unfortunately, his article completely contradicts some of the 
> statements made earlier in this thread. Ben says:
> 
> "...CF developers typically create variables in the 
> APPLICATION scope...and are careful never to overwrite 
> them. If an application contained variables like this, 
> variables that were never updated (after initial 
> creation), you wouldn't really need to lock them at all."
> 
> so according to Ben Forta, the only time you need 
> to lock an application variable is when you are 
> changing the value (i.e. CFSET), *NOT* when you are
> simply reading it (i.e. CFOUTPUT). 

That's not strictly true.  If you're never EVER going to write to the
variable (CFSET) beyond the first write, then you can afford to not
lock it.  If you ARE going to write to it more than that first time,
then you MUST lock the variable every time your write OR read it.  If
you don't lock the reads as well, then the lock on the write will
have no way of knowing if the variable is being read.  In otherwords,
not locking the reads completely defeats the purpose of locking as
other threads would be allowed to read from the variable as it is
being written to EVEN IF THE WRITE WAS IN A LOCK.

> But Zack said in a previous reply:
> 
> "IT IS AN ABSOLUTE NECESITY THAT YOU LOCK ALL SESSION, 
> APPLICATION, AND
> SERVER VARIABLES WHEN YOU WRITE OR READ THEM."

Okay..  I may have overstated that.  Let's say that, "Good CFML
programming practice dictates that IT IS AN ABSOLUTE NECESITY THAT
YOU .."

Like any good rule, if you really know what you're doing, you can
afford to bend it from time to time.  If you are absolutely certain
that an application/session/server variable will NOT be written to
ever after the initial assignment in the Application.cfm, then you
can afford to not lock it for reads.  If there's any code elsewhere
in the CF application that assigns a value to and ap/ses/serv
variable, then you must lock ALL reads and writes, otherwise it's
possible to cause multiple access problems, and down comes your
server.
 
> i will say that this is one thing that our 
> organization is struggling with... in almost 
> every question, someone says one thing and 
> someone else says another. there doesn't seem 
> to be much agreement anymore in the community. 
> perhaps this is because allaire has changed CF 
> so much with 4 and 4.5, but it certainly doesn't 
> look good when i research something like CFLOCK 
> and create a standard to use it only to find out 
> that someone else is saying otherwise.

There's disagreement for this reason:  

Many CF programmers do not have good training in a "classical"
programming language (C++), and have dealt with little other than
scripting languanges (like CF, ASP, Perl, Python, PHP, etc.) for most
of their programming days.  Scripting languages teach you to think in
a specific way (very task oriented), while allowing you to ignore the
underlying memory, disk, processor, and other archetechural details
to a large degree.  

Unfortunately CFML fails as a true scripting language in that it does
not ALLOW you to ignore many of those details, at least not all of
the time.  The worst part is that most of CFML's weaknesses (like
locking, or non-threadsafe CFX tags, or baddly written TCP/IP tags
(CFHTTP), etc.) do not manifest themselves until you apply lots of
traffic to the application.  And as you all know, by the time you've
applied traffic, it's too late...

Locking especially is an issue that is only a problem at moderate to
high traffic levels.  If you only have 10 visitors a day, OR if
you're developing an application and there's only YOU hitting it with
no other visitors, it's very possible to ignore locking and never see
any problems.  As your traffic grows, however, the excrement will hit
the rotating cooling appliance very quickly

When you add to that the fact that Allaire seems to change the rules
with every new release.  AND that they never bother to tell you
exactly what the rules are in the first place  Things aren't
fun...

My experiences have been gathered more or less from scratch.  I used
to shun CF (prefering ASP), but with some very bad ASP experiences
(can you say, "Blue Screen of Death?") and with a HUGE volume site on
the horizon, I switched to CF.  I had to learn all of the do's and
don't's from scratch.  At this point, I'm fairly confident that I've
got it right (a million hits a month & I haven't rebooted the NT
server for over two months!).  I'm always willing to listen to
others' experiences, tho -- I've certainly been dead wrong more than
once in the past...

> anyone else feel like this?

Absolutely.  The developers of CF (not the flunkies who write the
docs for the developers) need to take a hard look at their code &
dictate to us (the users of CF) exactly what you SHOULD, SHOULD NOT

RE: Need help with delete function

[Chris Evans]

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



-Original Message-
From: Jon Tillman [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 29, 2000 9:07 AM
To: [EMAIL PROTECTED]
Subject: Need help with delete function


I am at a loss here. I have a catalog I am building, and in the shopping
cart
part of it, I need to be able to delete individual items from it. They are
stored in a variable (session.productId) as a list of numbers (1,55,34,44).
What I need my delete function to do is remove one of the numbers from that
list. I cannot figure out how to do this at all. Anyone feel like showing me
how it could be done?


--
This Email is 100% Virus Free! How do I know?
Because no Microsoft products were used to
generate it!

:::
 Jon Tillman
 LINUX USER: #141163
 ICQ: 4015362
 [EMAIL PROTECTED]
 http://tillman.freehosting.net
:::

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Need help with delete function

[Jon Tillman]

I am at a loss here. I have a catalog I am building, and in the shopping cart
part of it, I need to be able to delete individual items from it. They are
stored in a variable (session.productId) as a list of numbers (1,55,34,44).
What I need my delete function to do is remove one of the numbers from that
list. I cannot figure out how to do this at all. Anyone feel like showing me
how it could be done?


-- 
This Email is 100% Virus Free! How do I know?
Because no Microsoft products were used to 
generate it!

:::
 Jon Tillman
 LINUX USER: #141163
 ICQ: 4015362
 [EMAIL PROTECTED]
 http://tillman.freehosting.net
:::
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reading List Ideas

[Jon Tillman]

Hi all,
I am relatively new to ColdFusion, and was wondering:
Does anyone here have a list of books that would be considered
recommended/required reading for someone learning ColdFusion, who is coming
from a HTML/XML background, and knows very little about databases and such?

Thanks

 -- 
This Email is 100% Virus Free! How do I know?
Because no Microsoft products were used to 
generate it!

:::
 Jon Tillman
 LINUX USER: #141163
 ICQ: 4015362
 [EMAIL PROTECTED]
 http://tillman.freehosting.net
:::
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Can this be done ?

[David Hannum]

Try caching the query, then do a group by state with a startrow and maxrows
in your cfoutput.  You'll have to build your
next / previous counters to populate your startrow variable.  If you can't
build your own, there's a tag in the Alliare Developers Exchange that can
help.

Dave


- Original Message -
From: gregg Kachel <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 28, 2000 7:03 PM
Subject: Can this be done ?


I'm wondering if this is possible, as I haven't had any luck.  I hope
someone can help me =).  I am trying to do is list all the manufactures in
my database by state. No, problem, works fine. But, I only want it to list
five states at a time, and have a next button that will take the user to the
next five states. Unfortuneatly, I can only get it to go up the next five
"records" in the database. Is there a way to have it go next to the next
catagory ?  Thanks ahead of time,
Gregg
webmaster
www.houseboatmagazine.com

PS: here is the code I have so far !



  SELECT id, state, statename, company
  FROM HBMF
 Order by state





Click on the state or province for houseboat manufactures in that state
only.


 



#statename#




Or, you may browse the entire listing below of houseboat manufactures.
  


  
Manufactures
  
  
  Sorry, no matching records.
  


 
 

 #statename#
  
   
 #company#
  
  
  







There are #manf.RecordCount# items in the database.
You are currently viewing records #StartRow# to #Evaluate(StartRow
+ MaxRows - 1)#



 Next page


 Previous page





--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Question about Dynamic List Box

[Dick Applebaum]

Your problem is that as you iterate thru each query item, 5 of the 
conditions will be met, e.g:

you are processing query button 3, so, at this moment 1,2,4,5 and 6 are
missing:


Try something like this (not tested):

   
   SELECT *
   FROM Buttons
   



   

   
   
 
   


   

   
 
   
 
> #thisButton#
 
   
 
   

HTH

Dick


At 5:06 AM -0400 7/29/00, [EMAIL PROTECTED] wrote:
>Ok, this is what i am trying to doI want to look through my records in a
>table called Buttons.  There is a field in the Buttons Table named Location. 
>This field contains either a 1, 2, 3, 4, 5, or 6.   What i want to do is
>dynamically populate a list box of the numbers that are NOT in the database. 
>This is what i have so far, but i get messed up outputs.  can someone
>help me please
>
>
>SELECT *
>FROM Buttons
>
>
>
>
> 
>  
> 1
> 
>  
> 2
> 
>  
> 3
> 
>  
> 4
> 
>  
> 5
> 
>  
> 6
> 
>
>
>Now is there something i am doing wrong?  should i be using a CFLOOP
>instead
>
>Help me please
>
>Thanks
>
>Kev
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal 
>k or send a message to [EMAIL PROTECTED] with 
>'unsubscribe' in the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

CF-Talk V1 #108

[justin]

Hello

I am on holiday until Monday 14th of August.  Please phone Electrum on 0131 555 4241 
if it cannot wait until then.

Cheers




_
This message has been checked for all known viruses by Star Internet delivered
through the MessageLabs Virus Control Centre. For further information visit
http://www.star.net.uk/stats.asp
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Question about Dynamic List Box

[KJis18]

Ok, this is what i am trying to doI want to look through my records in a 
table called Buttons.  There is a field in the Buttons Table named Location.  
This field contains either a 1, 2, 3, 4, 5, or 6.   What i want to do is 
dynamically populate a list box of the numbers that are NOT in the database.  
This is what i have so far, but i get messed up outputs.  can someone 
help me please


SELECT *
FROM Buttons





 
1

 
2

 
3

 
4

 
5

 
6



Now is there something i am doing wrong?  should i be using a CFLOOP 
instead

Help me please

Thanks

Kev
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Cold fusion on IE & Netscape

[Dick Applebaum]

nagesh

NN supports JavaScript & like all browers, tolerates WDDX packets 
(Ignores tags it doesn't understand).

NN is less forgiving than IE if you omit closing tags... especially 

HTH

Dick

At 4:12 PM +0800 7/29/00, Nagesh Kumar Deva wrote:
>hi all,
>
>I strucked up with one problem. ie My application is not at all loading when
>i run on netscape, itz working fine when i run on IE 5.0
>
>Just i'm thinking that the page which suppose to load after login has got
>lot of javascript and wddx packets. Is it the problem with Netscape. Does
>Netscape supports JS & WDDX? Otherwise it is problem with the coldfusion?
>
>if it supports, then why i could not able to run the application.
>
>thanx in advance
>nagesh
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CSS and attribut A:visited

[cftalk]

Any links available ?
Uwe

- Original Message -
From: "Kaplan, Mindie" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 28, 2000 7:39 PM
Subject: RE: CSS and attribut A:visited


You don't need to use javascript.  The HTML tag is:



A good CSS reference is:  _Core CSS_ by Keith Schengili-Roberts.  It has
syntax, browser support notes, and workarounds.



-Original Message-
From: Shane Pitts [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 28, 2000 12:03 PM
To: [EMAIL PROTECTED]
Subject: Re: CSS and attribut A:visited


A far as I know, it's not supported as of yet.  you would have to use an
image swap javascript, and not use text.

Shane


- Original Message -
From: "cftalk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 28, 2000 7:06 AM
Subject: OT: CSS and attribut A:visited


> A:visited as an attribut of CSS for hyperlinks doesn't work in Netscape
4.x
> Ideas how to manage it in Netscape with CSS ?
>
> Uwe
>
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Cold fusion on IE & Netscape

[Nagesh Kumar Deva]

hi all,

I strucked up with one problem. ie My application is not at all loading when
i run on netscape, itz working fine when i run on IE 5.0

Just i'm thinking that the page which suppose to load after login has got
lot of javascript and wddx packets. Is it the problem with Netscape. Does
Netscape supports JS & WDDX? Otherwise it is problem with the coldfusion?

if it supports, then why i could not able to run the application. 

thanx in advance
nagesh
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.