date:20010315


And I cant forward your email! heh

jon
> As I live in Australia, my two cents's worth is now worth $0.01  ;-(
>
> Lee (Bjork) Borkman
> http://bjork.net ColdFusion Tags by Bjork
>
>
>
> -Original Message-
> From: Scott, Andrew [mailto:[EMAIL PROTECTED]]
>
> Yes agreed, and the other thing that annoys me a little is that with
Spectra
> (which generates a lot of space, and overheads to any site) some
developers
> are very quick to incorporate the code to remove the white space etc. But
> this throws so much extra processing that it would be better to leave the
> whitespace alone.
>
> 
>
>
> IMPORTANT NOTICE:
> This e-mail and any attachment to it is intended only to be read or used
by
> the named addressee.  It is confidential and may contain legally
privileged
> information.  No confidentiality or privilege is waived or lost by any
> mistaken transmission to you.  If you receive this e-mail in error, please
> immediately delete it from your system and notify the sender.  You must
not
> disclose, copy or use any part of this e-mail if you are not the intended
> recipient.  The RTA is not responsible for any unauthorised alterations to
> this e-mail or attachment to it.
>
>
~~
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: White space

2001-03-15 Thread Scott, Andrew


I agree on the savings that it can achieve, but again at what cost.

If it ends up adding (and yes I have seen this) say 2000 ms in a very big
site that has hundreds of cfm files. Would this 2 seconds be better of
getting the information to the client, than trying to remove whitespace!

But as Philip said it is personal preference:-)


-Original Message-
From: Lanny R. Udey [mailto:[EMAIL PROTECTED]]
Sent: 16 March 2001 14:06
To: CF-Talk
Subject: RE: White space


If you cache a lot of your pages like we do, then getting rid of the white
space is a big savings. This is particularly true if you have a lot of
people accessing your pages through modems via AOL etc. The saving on
download time on a 33 Kbs modem is substantial. We cut page sizes down from
40 K to 8K and that is after we used all the proper coding techniques.

Lanny Udey
Hofstra University




>>> [EMAIL PROTECTED] Thursday, March 15, 2001 >>>
Yes agreed, and the other thing that annoys me a little is that with Spectra
(which generates a lot of space, and overheads to any site) some developers
are very quick to incorporate the code to remove the white space etc. But
this throws so much extra processing that it would be better to leave the
whitespace alone.

And I agree that in a very heavy visited site, the less work the server has
to do the better of it is. Sure one could argue that you can just keep
throwing more $'s into the hardware, but why spend unnecessary money when
you don't have too. I mean we have a hard enough time convincing people to
purchase CF as it is without having to turn around and add to the cost's

Just my $0.02 worth:-)

 

-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] 
Sent: 15 March 2001 22:01
To: CF-Talk
Subject: RE: White space


> You raised some good points there, and I agree that it is all down to
> preference. However, text does travel faster than binary files. But if you
> are intent on removing the whitespace, bare in mind that you want to still
> be able to forsee the scalability of the code and the method used
> to create
> the backend.
>
> For example, with a system that is designed to be portable. Easy to
> maintain, and debug. You couldn't take all the methods listed, to achieve
> this sort of system. You can use these in parts, to help cut down but I
> don't think putting that much load onto the server really warrants a few
> extra k of text.

I'm personally of the opinion that if the server runs the templates faster,
then you can serve more users - if they have to wait a fraction of a second
longer, so what?

I'd rather serve 200 pages a second than 150 (or whatever the figures are)

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

cfinclude security


Does anyone know of a work around for cfinclude in a shared hosting
environment? Maybe a few guidelines?
Because, if there is a way to limit a top root directory for cfinclude, it
is not obvious to me...

Actually writing this, I had a thought. Is it feasible to run the CFServer
as a user who does not have permissions in certain directories but otherwise
is an administrator?

jon


~~
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: White space

2001-03-15 Thread Lanny R. Udey


If you cache a lot of your pages like we do, then getting rid of the white space is a 
big savings. This is particularly true if you have a lot of people accessing your 
pages through modems via AOL etc. The saving on download time on a 33 Kbs modem is 
substantial. We cut page sizes down from 40 K to 8K and that is after we used all the 
proper coding techniques.

Lanny Udey
Hofstra University




>>> [EMAIL PROTECTED] Thursday, March 15, 2001 >>>
Yes agreed, and the other thing that annoys me a little is that with Spectra
(which generates a lot of space, and overheads to any site) some developers
are very quick to incorporate the code to remove the white space etc. But
this throws so much extra processing that it would be better to leave the
whitespace alone.

And I agree that in a very heavy visited site, the less work the server has
to do the better of it is. Sure one could argue that you can just keep
throwing more $'s into the hardware, but why spend unnecessary money when
you don't have too. I mean we have a hard enough time convincing people to
purchase CF as it is without having to turn around and add to the cost's

Just my $0.02 worth:-)

 

-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] 
Sent: 15 March 2001 22:01
To: CF-Talk
Subject: RE: White space


> You raised some good points there, and I agree that it is all down to
> preference. However, text does travel faster than binary files. But if you
> are intent on removing the whitespace, bare in mind that you want to still
> be able to forsee the scalability of the code and the method used
> to create
> the backend.
>
> For example, with a system that is designed to be portable. Easy to
> maintain, and debug. You couldn't take all the methods listed, to achieve
> this sort of system. You can use these in parts, to help cut down but I
> don't think putting that much load onto the server really warrants a few
> extra k of text.

I'm personally of the opinion that if the server runs the templates faster,
then you can serve more users - if they have to wait a fraction of a second
longer, so what?

I'd rather serve 200 pages a second than 150 (or whatever the figures are)

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: Solaris cfserver start stop

2001-03-15 Thread Mak Wing Lok


what error it gives when you accessing the .cfm pages thru your browser?


- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 16, 2001 6:26 AM
Subject: Solaris cfserver start stop


>
>
> I have CF 4.0 installed on Solaris (sun) and I can't access the cf server
> through the .cfms.  I tried restarting the server by doing the following
but
> it still no connection to the cfserver through the web:
>
> >stop cfserver
> >start cfserver
> >stop cfexec
> >start cfexec
> >start 271
> 271 is the process id
> and so forth from the directory where it is installed.
>
> Please help!
>
> Nehal
>
~~
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: White space

2001-03-15 Thread BORKMAN Lee


Yeah, although I wrote it, I don't use CF_LessWhiteSpace much anymore,
because of the processing overhead.  I try to manage with CFSETTINGS, which
is pretty easy to arrange when using FuseBox, but a pain if you're not.

As I live in Australia, my two cents's worth is now worth $0.01  ;-(

Lee (Bjork) Borkman
http://bjork.net ColdFusion Tags by Bjork



-Original Message-
From: Scott, Andrew [mailto:[EMAIL PROTECTED]]

Yes agreed, and the other thing that annoys me a little is that with Spectra
(which generates a lot of space, and overheads to any site) some developers
are very quick to incorporate the code to remove the white space etc. But
this throws so much extra processing that it would be better to leave the
whitespace alone.




IMPORTANT NOTICE:
This e-mail and any attachment to it is intended only to be read or used by
the named addressee.  It is confidential and may contain legally privileged
information.  No confidentiality or privilege is waived or lost by any
mistaken transmission to you.  If you receive this e-mail in error, please
immediately delete it from your system and notify the sender.  You must not
disclose, copy or use any part of this e-mail if you are not the intended
recipient.  The RTA is not responsible for any unauthorised alterations to
this e-mail or attachment to it.  

~~
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: White space

2001-03-15 Thread Scott, Andrew


Yes agreed, and the other thing that annoys me a little is that with Spectra
(which generates a lot of space, and overheads to any site) some developers
are very quick to incorporate the code to remove the white space etc. But
this throws so much extra processing that it would be better to leave the
whitespace alone.

And I agree that in a very heavy visited site, the less work the server has
to do the better of it is. Sure one could argue that you can just keep
throwing more $'s into the hardware, but why spend unnecessary money when
you don't have too. I mean we have a hard enough time convincing people to
purchase CF as it is without having to turn around and add to the cost's

Just my $0.02 worth:-)

 

-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: 15 March 2001 22:01
To: CF-Talk
Subject: RE: White space


> You raised some good points there, and I agree that it is all down to
> preference. However, text does travel faster than binary files. But if you
> are intent on removing the whitespace, bare in mind that you want to still
> be able to forsee the scalability of the code and the method used
> to create
> the backend.
>
> For example, with a system that is designed to be portable. Easy to
> maintain, and debug. You couldn't take all the methods listed, to achieve
> this sort of system. You can use these in parts, to help cut down but I
> don't think putting that much load onto the server really warrants a few
> extra k of text.

I'm personally of the opinion that if the server runs the templates faster,
then you can serve more users - if they have to wait a fraction of a second
longer, so what?

I'd rather serve 200 pages a second than 150 (or whatever the figures are)

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: XML

2001-03-15 Thread Benjamin S. Rogers


> Let me point out a very good reason NOT to use CF for XML.  When you get
> XML, you have to compare it to your DTD and then parse it to get the data
> out.  I'm not sure about you, but writing a parser as complex as this in
CF
> doesn't sit very high on the list of things I want to do.

Luckily, you do not have to. There are many written in Java or that have
been compiled in C++ as COM objects. Many of these will work in ColdFusion.
The obvious choice, if you are working in a Windows environment, is the
MSXML COM object that is installed with every installation of Internet
Explorer 5 or greater. If find COM objects too difficult, have a look at
SiteObjects' MSXML wrapper, CF_SOXML.

http://www.siteobjects.com/index.cfm?fuseAction=showProducts

> So, short summary - there are no existing CF parsers for XML (that I know
> of...if I'm wrong, someone please correct me).  Handling XML is pretty
> process intensive, and lets be honest, thats not really CF's strong point.

There are none that I know of that are written in CFML but that only makes
sense since both are a markup language. As you've suggested, you really
wouldn't want to parse a markup language with another markup language. But,
as mentioned above, there are several really good XML parsers which are
available to ColdFusion developers via COM, JAVA, etc.

> what are the advantages of using XML with my coldfusion web apps?  like
what
> cool stuff can I do?  and is XML hard to learn?

As to the original question, there are quite a few immediate uses for XML.
For instance, you can separate content from display. This is done by using
ColdFusion to query a database to create a XML template on the fly or query
an XML document repository and applying an appropriate XSL template.

This gives you the ability to change the design of the site on the fly
depending on the browser (WML/WAP enabled phone, text reader, TV,
traditional, etc.) without having to maintain several different versions of
the site. This, of course, is just one example but one that is being used
quite frequently by ColdFusion developers.

Another way to integrate XML into your sites would be through WDDX, which is
built right into ColdFusion. You can use WDDX or even XML itself to
syndicate content. That is what has been done with the MoreOver.com news
feeds for example.

In my opinion, XML is much more difficult to learn than HTML because it is
designed for the parser rather than the developer. It is case sensitive, is
very strict in regards to syntax, and requires a more abstract approach. It
also requires a knowledge of DTDs, and if you are going to generate Web
pages from XML, a knowledge of XSL and XSLT will be necessary. These are all
hurdles to overcome if you come from an HTML background.

Luckily, there are already tools like those mentioned above that hide quite
a bit of the logic and make our jobs as developers much easier; and the
tools will only get better.

Benjamin S. Rogers
Web Developer, c4.net
Voice: (508) 240-0051
Fax: (508) 240-0057


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

2001-03-15 Thread Brian Thornton


Is your DB Access97?
- Original Message -
From: "Joshua Tipton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 4:23 PM
Subject: RE: help


> Can oyu send me the crack?
>
> -Original Message-
> From: Brian Thornton [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 15, 2001 4:21 PM
> To: CF-Talk
> Subject: Re: help
>
>
> Check out astalavista.box.sk. They have a MS Crack for unlocking the
> password. I used it for a Access97 DB.
>
> Best of Luck.
> - Original Message -
> From: "Joshua Tipton" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, March 15, 2001 2:19 PM
> Subject: help
>
>
> > I have an access db that is locked.  User cant remeber the password.
Does
> > anyone know how to get the password or do you have a util to do so?
> >
> >
> > Joshua Tipton
> >
> >
> >
>
~~
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: Control Panels for Remote Administration of Datasources for multiple clients


I am currently working on something very similar to the below app. I am
using a combination of IHTK from Lewis Sellers, cfregistry for datasources,
and using cfexecute to call the command line Imail programs for email stuff,
and cffile to write out dns files. Of course mine isn't as pretty ;-)

As far as security, I would never give a developer I did not trust to any of
these tools. For the general population, I would probably implement some
kind of queuing function. Where the program records all of the data needed
first, then an administrator reviews the changes and sumbits the job and the
program runs through and does the changes on the servers.

jon
- Original Message -
From: "Jason Larson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 5:02 PM
Subject: RE: Control Panels for Remote Administration of Datasources for
multiple clients


> Daryl,
>
> One of the best controlpanels that I have seen is at
> http://iroquois.cosmotek.net/mycontrol/login.asp. I have just begun to do
> some hosting myself, and eventually want to resell my services on the web
> (give about 12 months though). check it out, it is pretty cool.
>
> Jason
>
> -Original Message-
> From: Daryl Fullerton [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 15, 2001 2:18 PM
> To: CF-Talk
> Subject: Control Panels for Remote Administration of Datasources for
> multiple clients
>
>
> Hi all
>
> We are opening up our servers in Hosting division for clients to
> remotely administrate datasources.
>
> Up to now we relied on email messages or phone for client requests for
> datasource additions / alterations.
>
> Just wondering what everyones views are on control panels and which ones
> they have experience with from security points of view.
>
> Anyone recocommend or got preferences.
>
> Thanks
>
> D
>
>
> Daryl Fullerton,
> Managing Partner,
> BizNet Solutions,
> Allaire Premier Partner (Ireland)
> 133 - 137 Lisburn Road
> Belfast
> BT9 7AG
> N.Ireland
>
> Direct +44 (0) 28 9022 7888
> Tel  +44 (0) 028 9022 3224
> Fax +44 (0) 028 9022 3223
>
>
> [EMAIL PROTECTED]
> Http://www.BizNet-Solutions.com
>
> [EMAIL PROTECTED] (Chairman)
> Http://www.cfug.ie The Irish Cold Fusion User Group
>
~~
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: power point

2001-03-15 Thread C. Hatton Humphrey


Sorry, but I'm a bit confused on your question.  Are you trying to grab
screen shots and put them in a power point or do you want to incorperate a
power point presentation into your site?

Hatton

-Original Message-
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 8:46 PM
To: CF-Talk
Subject: power point


I need to display form information collected from a web page in a power
point presentation view from a browser
has anyone done this before
thanks
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: XML

2001-03-15 Thread Steve Aylor


http://xml.granularity.com/

- Original Message -
From: "John Wilker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 1:38 PM
Subject: RE: XML


> Couldn't you just interface with a COM object? like Microsoft's XML
parser?
> I've only played with it a little bit outside CF, but was able to read XML
> files and such. It's also free (dl from the site, plus I think IE 5.5
comes
> with version 3 of the parser).
>
> I don't do much with XML at this point so I'm only tossing that idea out
> there.
>
> J.
>
> John Wilker
> Web Applications Consultant
> Allaire Certified ColdFusion Developer
>
> Office: 909-943-8428
> www.billtracker.org 
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 15, 2001 1:02 PM
> To: CF-Talk
> Subject: RE: XML
>
>
> OK - different subject, so I'm following with a different email:
>
> Let me point out a very good reason NOT to use CF for XML.  When you get
> XML, you have to compare it to your DTD and then parse it to get the data
> out.  I'm not sure about you, but writing a parser as complex as this in
CF
> doesn't sit very high on the list of things I want to do.
>
> On the other hand, there are plenty of Java (and other languages) XML
> parsers out there.  The apache organization maintains a very nice one
called
> "xerces" which is seeing a lot of use.  I think Sun may also distribute
> their own version of an XML parser.
>
> So, short summary - there are no existing CF parsers for XML (that I know
> of...if I'm wrong, someone please correct me).  Handling XML is pretty
> process intensive, and lets be honest, thats not really CF's strong point.
>
> Brian
>
> -Original Message-
> From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 13, 2001 4:21 PM
> To: CF-Talk
> Subject: XML
>
>
> what are the advantages of using XML with my coldfusion web apps?  like
what
> cool stuff can I do?  and is XML hard to learn?
>
~~
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: XML

2001-03-15 Thread Marc Garrett


<[EMAIL PROTECTED]> wrote

> So, short summary - there are no existing CF parsers for XML (that I know
> of...if I'm wrong, someone please correct me).  Handling XML is pretty
> process intensive, and lets be honest, thats not really CF's strong point.

Brian,

The custom tag CF_SOXML is very easy to use and relies on the MSXML parser,
which almost any up-to-date Windows server will have. You only have to pass
it a few parameters -- the xml file, the xsl file, and the desired action.

Regards,

Marc Garrett




~~
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: Cold fusion has top line blank.......

2001-03-15 Thread Richard Kuryk


Thank you very much.  It was an application file.  didn't even think to look
there.

Rich

-Original Message-
From: Howarth, Craig (IBK-NY) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 5:00 PM
To: CF-Talk
Subject: RE: Cold fusion has top line blank...


Do you have an application.cfm file?  This is always processed before your
template, so it may be adding extra blank space.

Craig

> -Original Message-
> From: Richard Kuryk [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, March 15, 2001 4:11 PM
> To:   CF-Talk
> Subject:  Cold fusion has top line blank...
> 
> We have two server and on one server with cf4.5sp2 the text "COLD FUSION
> BLOWS" appears on the very top line of the source but on another server
with
> cf4.5sp1 "COLD FUSION BLOWS" appears a line down.  The exact same source.
> This doesn't seem like a big deal but my xml/xsl parser flips out if  version="1.0"?> is not on the first line.  I have all pasted the source
> below and it is a single line file.  Any thoughts on how I can fix this?
> 
> Sorry about the knock to cold fusion but I have been banging my head all
day
> on this one!
> 
> Thanks you
> 
> Rich
> 
> SOURCE:
> LINE1: ENABLECFOUTPUTONLY="YES">writeoutput(StripCR("COLD FUSION
> BLOWS!"));
> 
> 
>
~~
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: atomz Search for Dynamic site

2001-03-15 Thread Lanny R. Udey

We use Atomz but we use the following type of URLs so the search engines spider the
site properly. Most search engines have a problem with URL parameters after a "?".

http://www.hofstra.edu/Academics/index_Academics.cfm/type/dn/link/Academics

We do have a few pages with URL parameters and these are not spider properly by Atomz
spider. Since we don't really need to index these we exclude them.

If you want to write me off-line I will send you how we do the links as above.

Also, Atomz tech support is great. They may have a way to set up the spider to accept
url variables - if you find out please let me know.

Lanny Udey
Hofstra University
Associate Dean,
Learning and Information Technology
Hofstra University
[EMAIL PROTECTED]

>>> [EMAIL PROTECTED] Thursday, March 15, 2001 >>>
Can anybody give me some info on how they set up an Atomz index for a
dynamic site?

I have a coldfusion site using fusebox method that uses for all links and heavy use of url parameters with case values.

I set up an Atomz.com index of a fusebox site with the entry point as
domain/index.cfm

Atomz.com only indexes the display files called by the default fuseaction,
but does not follow the in the dsp files.

I know that people have said they did this successfully-can I get a reality
check?

-Tom
~~
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: atomz Search for Dynamic site

2001-03-15 Thread Jason Lotz


How exactly could it follow 's since they are sent to the browser
after the file has been included?



- Original Message -
From: "Tom" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 3:10 PM
Subject: atomz Search for Dynamic site


> Can anybody give me some info on how they set up an Atomz index for a
> dynamic site?
>
> I have a coldfusion site using fusebox method that uses  template=""> for all links and heavy use of url parameters with case
values.
>
> I set up an Atomz.com index of a fusebox site with the entry point as
> domain/index.cfm
>
> Atomz.com only indexes the display files called by the default fuseaction,
> but does not follow the  in the dsp files.
>
> I know that people have said they did this successfully-can I get a
reality
> check?
>
>
> -Tom
>
>
>
>
~~
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

cflock and file access

2001-03-15 Thread Jay Brushett



Hi,

I'm trying to remove all of the images from a directory and then remove the 
directory.
But I keep getting an error saying the directory is not empty since the os 
is still deleting the files.
I know I can use cflock to accomplish this but I'm not sure how.

Thanks,

Jay
< > < > < > < > < Strategy ~ Creativity ~ Technology > < > < > < > < > < >

Jay Brushett
[EMAIL PROTECTED]

Developer

< ZeddComm Inc. >
2nd Floor, The Tower | 100 Signal Hill Road
St. John's, Newfoundland | Canada A1A 1B3
Main: 709.570.5669 | Fax: 709.739.9003
Web: www.zeddcomm.com
< > < > < > < St. John's ~ Toronto ~ Newport Beach ~ Ottawa > < > < > < >



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

power point


I need to display form information collected from a web page in a power
point presentation view from a browser
has anyone done this before
thanks
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

power point


I need to display form information collected from a web page in a power
point presentation view from a browser
has anyone done this before
thanks
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

Download manager application

2001-03-15 Thread Darren Evans


Does anyone know where I could find a sample download manager app to maintain files to 
be downloaded?

Any help would be appreciated.

Darren


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

2001-03-15 Thread Angel Stewart


Yes..there are several tools that you can purchase that will crack virtually
any password set by a Microsoft program.
check www.lostpasswords.com

-Gel


-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]

I have an access db that is locked.  User cant remeber the password.  Does
anyone know how to get the password or do you have a util to do so?


Joshua Tipton


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

2001-03-15 Thread Brian Thornton


Check out astalavista.box.sk. They have a MS Crack for unlocking the
password. I used it for a Access97 DB.

Best of Luck.
- Original Message -
From: "Joshua Tipton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 2:19 PM
Subject: help


> I have an access db that is locked.  User cant remeber the password.  Does
> anyone know how to get the password or do you have a util to do so?
>
>
> Joshua Tipton
>
>
>
~~
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

AW: Control Panels for Remote Administration of Datasources for multiple clients

2001-03-15 Thread cf-talk


http://www.multnomah.lib.or.us/cfdocs/Allaire_Support/adminsecurity.htm

Uwe

-Ursprüngliche Nachricht-
Von: Daryl Fullerton [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 15. März 2001 22:18
An: CF-Talk
Betreff: Control Panels for Remote Administration of Datasources for
multiple clients


Hi all

We are opening up our servers in Hosting division for clients to
remotely administrate datasources.

Up to now we relied on email messages or phone for client requests for
datasource additions / alterations.

Just wondering what everyones views are on control panels and which ones
they have experience with from security points of view.

Anyone recocommend or got preferences.

Thanks

D


Daryl Fullerton,
Managing Partner,
BizNet Solutions,
Allaire Premier Partner (Ireland)
133 - 137 Lisburn Road
Belfast
BT9 7AG
N.Ireland

Direct +44 (0) 28 9022 7888
Tel  +44 (0) 028 9022 3224
Fax +44 (0) 028 9022 3223


[EMAIL PROTECTED]
Http://www.BizNet-Solutions.com

[EMAIL PROTECTED] (Chairman)
Http://www.cfug.ie The Irish Cold Fusion User Group
~~
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

automatic loading files to server

2001-03-15 Thread thanh nguyen


hello all,
every day I have to upload files manually to one of our client website using 
netscape or explorer, I go to their website, click on a link, and it prompt 
for user name and passowrd, after that i have to enter some information like 
name, and then choose to file on my local machine and click uploaded. I just 
want to know if I can automatically upload the files ussing  cold fusion or 
other programming tools, if yes, how what tags i should use,
thanks
~~
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

Solaris cfserver start stop

2001-03-15 Thread [EMAIL PROTECTED]




I have CF 4.0 installed on Solaris (sun) and I can't access the cf server
through the .cfms.  I tried restarting the server by doing the following but
it still no connection to the cfserver through the web:

>stop cfserver
>start cfserver
>stop cfexec
>start cfexec
>start 271
271 is the process id
and so forth from the directory where it is installed.

Please help!

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

atomz Search for Dynamic site

2001-03-15 Thread Tom


Can anybody give me some info on how they set up an Atomz index for a
dynamic site?

I have a coldfusion site using fusebox method that uses  for all links and heavy use of url parameters with case values.

I set up an Atomz.com index of a fusebox site with the entry point as
domain/index.cfm

Atomz.com only indexes the display files called by the default fuseaction,
but does not follow the  in the dsp files.

I know that people have said they did this successfully-can I get a reality
check?


-Tom


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

CFLAP question

2001-03-15 Thread Douglas . Knudsen





I use


I get the following error

CFLDAP
No such object
The error occurred while processing an element with a general identifier
of (CFLDAP), occupying document position (46:1) to (46:730) in the
template file C:\INETPUB\WWWROOT\DOUG\LDAPQUERY5.CFM
The specific sequence of files included or processed is:
C:\INETPUB\WWWROOT\DOUG\LDAPQUERY5.CFM  .


Any thoughts as to why I can't do this? If I do not supply a password, it
works fine.  I'm trying to use our companies LDAP for authentication by
'rebinding', although I'm not to familiar with the term.

Cheers!

-
Douglas Knudsen
Leveraged Technologies Group
678-351-6063
Got Linux? http://linuxmall.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

RE: Control Panels for Remote Administration of Datasources for multiple clients

2001-03-15 Thread Jason Larson


Daryl,

One of the best controlpanels that I have seen is at
http://iroquois.cosmotek.net/mycontrol/login.asp. I have just begun to do
some hosting myself, and eventually want to resell my services on the web
(give about 12 months though). check it out, it is pretty cool.

Jason

-Original Message-
From: Daryl Fullerton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 2:18 PM
To: CF-Talk
Subject: Control Panels for Remote Administration of Datasources for
multiple clients


Hi all

We are opening up our servers in Hosting division for clients to
remotely administrate datasources.

Up to now we relied on email messages or phone for client requests for
datasource additions / alterations.

Just wondering what everyones views are on control panels and which ones
they have experience with from security points of view.

Anyone recocommend or got preferences.

Thanks

D


Daryl Fullerton,
Managing Partner,
BizNet Solutions,
Allaire Premier Partner (Ireland)
133 - 137 Lisburn Road
Belfast
BT9 7AG
N.Ireland

Direct +44 (0) 28 9022 7888
Tel  +44 (0) 028 9022 3224
Fax +44 (0) 028 9022 3223


[EMAIL PROTECTED]
Http://www.BizNet-Solutions.com

[EMAIL PROTECTED] (Chairman)
Http://www.cfug.ie The Irish Cold Fusion User Group
~~
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: Cold fusion has top line blank.......

2001-03-15 Thread Howarth, Craig (IBK-NY)


Do you have an application.cfm file?  This is always processed before your template, 
so it may be adding extra blank space.

Craig

> -Original Message-
> From: Richard Kuryk [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, March 15, 2001 4:11 PM
> To:   CF-Talk
> Subject:  Cold fusion has top line blank...
> 
> We have two server and on one server with cf4.5sp2 the text "COLD FUSION
> BLOWS" appears on the very top line of the source but on another server with
> cf4.5sp1 "COLD FUSION BLOWS" appears a line down.  The exact same source.
> This doesn't seem like a big deal but my xml/xsl parser flips out if  version="1.0"?> is not on the first line.  I have all pasted the source
> below and it is a single line file.  Any thoughts on how I can fix this?
> 
> Sorry about the knock to cold fusion but I have been banging my head all day
> on this one!
> 
> Thanks you
> 
> Rich
> 
> SOURCE:
> LINE1: ENABLECFOUTPUTONLY="YES">writeoutput(StripCR("COLD FUSION
> BLOWS!"));
> 
> 
>
~~
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: exploiting shopping carts

2001-03-15 Thread Dave Watts


> I just got this article today about how people are exploiting 
> shopping cart logic to change prices and essentially stealing 
> products. After some testing on my own carts I have been able 
> to exploit some of them by building a form with all there 
> required hidden fields and modifying there values. Of course
> this wouldn't be a problem if they weren't sending pricing 
> information as a hidden variable but many of them do. Do you 
> guys have any recommendation for preventing this on carts 
> built this way? I've thought of checking the http_referer to 
> make sure the request comes from the same domain the site is
> in but I'm not sure there isn't a better solution that I'm 
> missing. I've attached the address to the article for you all 
> to read.

No, there's no way to prevent this for carts built this way, except to
change the code so that it doesn't work this way.

Any data from the browser is subject to tampering. You can't rely on
HTTP_REFERER - that's sent by the browser, and thus subject to the same sort
of tampering as the form fields.

When I teach the Allaire Advanced CF Development class, I typically do a
demonstration of this exact thing using the sample (intentionally unsecure)
application, and it usually gets a big rise out of the class.

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

RE: cfm-resources.com

2001-03-15 Thread Robert Obreczarek


The service is not the highest quality, but you get what
you pay for. But it's a legit operation. The guy that runs it,
Pablo is doing a great job. He's giving a great opportunity
to beginning coders with low budgets (like me) to write code
and be able to preview their work. How many teenagers do you
know that could afford CF Server software? I bet it's not easy to
get a bootleg copy of it either. If you decide to host with
CFM Resources be prepared to see your site down once in a
while. Personally, I think it's worth it.

Robert Obreczarek

==
http://www.httpworkshop.com
[EMAIL PROTECTED]

-Original Message-
From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 12:39 PM
To: CF-Talk
Subject: cfm-resources.com


I just came across www.cfm-resources.com and was wondering if anyone is
using them?  I just am skeptical of their service because of its price,
seems way to good to be true.  Please let me know of your good/bad
experiences with them.

Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer
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: Cold fusion has top line blank.......

2001-03-15 Thread David E. Crawford


Check your application.cfm file.

DC

- Original Message -
From: "Richard Kuryk" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 16:11
Subject: Cold fusion has top line blank...


> We have two server and on one server with cf4.5sp2 the text "COLD FUSION
> BLOWS" appears on the very top line of the source but on another server
with
> cf4.5sp1 "COLD FUSION BLOWS" appears a line down.  The exact same source.
> This doesn't seem like a big deal but my xml/xsl parser flips out if  version="1.0"?> is not on the first line.  I have all pasted the source
> below and it is a single line file.  Any thoughts on how I can fix this?
>
> Sorry about the knock to cold fusion but I have been banging my head all
day
> on this one!
>
> Thanks you
>
> Rich
>
> SOURCE:
> LINE1: ENABLECFOUTPUTONLY="YES">writeoutput(StripCR("COLD FUSION
> BLOWS!"));
>
>
>
~~
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: Cold fusion has top line blank.......

2001-03-15 Thread Hayes, David

Are you sure it's CF?  Are there any web server settings that are different?
What results do you see with a plain HTML file?

-Original Message-
From: Richard Kuryk [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 3:11 PM
To: CF-Talk
Subject: Cold fusion has top line blank...

We have two server and on one server with cf4.5sp2 the text "COLD FUSION
BLOWS" appears on the very top line of the source but on another server with
cf4.5sp1 "COLD FUSION BLOWS" appears a line down.  The exact same source.
This doesn't seem like a big deal but my xml/xsl parser flips out if  is not on the first line.  I have all pasted the source
below and it is a single line file.  Any thoughts on how I can fix this?

Sorry about the knock to cold fusion but I have been banging my head all day
on this one!

Thanks you

Rich

SOURCE:
LINE1:writeoutput(StripCR("COLD FUSION
BLOWS!"));
~~
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: XML

2001-03-15 Thread John Wilker


Couldn't you just interface with a COM object? like Microsoft's XML parser?
I've only played with it a little bit outside CF, but was able to read XML
files and such. It's also free (dl from the site, plus I think IE 5.5 comes
with version 3 of the parser).

I don't do much with XML at this point so I'm only tossing that idea out
there.

J.

John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer

Office: 909-943-8428
www.billtracker.org 


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 1:02 PM
To: CF-Talk
Subject: RE: XML


OK - different subject, so I'm following with a different email:

Let me point out a very good reason NOT to use CF for XML.  When you get
XML, you have to compare it to your DTD and then parse it to get the data
out.  I'm not sure about you, but writing a parser as complex as this in CF
doesn't sit very high on the list of things I want to do.

On the other hand, there are plenty of Java (and other languages) XML
parsers out there.  The apache organization maintains a very nice one called
"xerces" which is seeing a lot of use.  I think Sun may also distribute
their own version of an XML parser.

So, short summary - there are no existing CF parsers for XML (that I know
of...if I'm wrong, someone please correct me).  Handling XML is pretty
process intensive, and lets be honest, thats not really CF's strong point.

Brian

-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 4:21 PM
To: CF-Talk
Subject: XML


what are the advantages of using XML with my coldfusion web apps?  like what
cool stuff can I do?  and is XML hard to learn?
~~
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: Code review PLEASE


THank You Jon,  I am trying some of what other's here on the list suggested
also.

Michael


"Jon Hall" <[EMAIL PROTECTED]> wrote in message
028701c0ad91$fd121de0$a41f88d8@ns2">news:028701c0ad91$fd121de0$a41f88d8@ns2...
> Mike do a little debugging on the host. What is the value of #nextid# and
> #previd# on the page? When you click next on the host, does it show the
> first record everytime? Does the url always say default2.cfm?ID=2  ?
> If so, it's obvious that the sql statement is not picking up the url
> variable and probably is only picking up the cfparam variable.
>
> Try scoping your variables just to make sure. If this isn't the problem it
> is always a good idea to scope variables, it makes the code a little
easier
> to read later on, and it executes faster.
>
>
> 
>
>  dbtype="ODBC">
> SELECT  ID, EmpCandidate, SKillBackground, Status, Recruiter, Profile
> FROMinterview
> WHERE ID=#url.id#
> 
>
> 
> 
>
> Notice no pound signs within the cfsets, it is again easier to read and
> executes slightly faster.
>
> One problem I see is that you are relying the ID to be sequential in the
> database. If you delete a record, eventually you will run into a query
that
> has no record and shows a blank page.
> I think a better way to do all this if the user does not have the ability
to
> edit records, would be to cache the query and use startrow and maxrow in
> your cfoutput. Like so...
>
> 
>
>  cachedwithin="#CreateTimeSpan(0,0,0,10)#">
> SELECT  ID, EmpCandidate, SKillBackground, Status, Recruiter, Profile
> 
>
> 
> 
>
> 
> Data here
>
> Previous
> Next
> 
>
> This will work even without caching, but might as well make it quicker.
>
>
> jon
> - Original Message -
> From: "Mike" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, March 15, 2001 1:59 PM
> Subject: Code review PLEASE
>
>
> > This is really making me go bald,  I have a page that has next and
> previous,
> > and when viewed locally I can see everything, when I ftp to my host (and
> yes
> > the odbc is working and correct) I can only see the first record, and
> > nothing after that.
> >
> > I have tried putting the database(access) in the database folder, and
> > straight in the directory with all the pages and I still get the same
> > result, I have replaced the database, and contacted my host, and they
say
> > that the code is fine from what little the guy knew about CF.
> >
> > Below is the code if someone could share there knowledge I would as
always
> > appreciate it.
> >
> > And thank you
> >
> >
> > 
> >
> > 
> > 
> > 
> >
> >  > dbtype="ODBC">
> > SELECT  ID, EmpCandidate, SKillBackground, Status, Recruiter,
Profile
> > FROMinterview
> > WHERE ID=#ID#
> > 
> >
> > 
> > 
> >
> > Interview Candidates
> > 
> >
> > 
> > 
> > 
> >
> > 
> > 
> > 
> >  ID
> >  #id#
> > 
> > 
> >  Candidate Name
> >  #EmpCandidate#
> > 
> > 
> >  Skill Background
> >  #SKillBackground#
> > 
> > 
> >  Status
> >  #Status#
> > 
> > 
> >  Recruiter
> >  #Recruiter#
> > 
> > 
> >  Profile
> >  #profile#
> > 
> > 
> > 
> > 
> > 
> > Previous
> > Next
> > 
> > 
> >
> >
> >
> >
>
~~
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 Fields cleared on Back


> http://www.aspmedia.co.uk/CF/_EditForm.cfm

Damn,

http://www.aspmedia.co.uk/CF/_EditForm.zip

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


> -Original Message-
> From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
> Sent: 15 March 2001 18:59
> To: CF-Talk
> Subject: RE: Form Fields cleared on Back
>
>
> > What editor thingy is that Phillip?
>
> I posted the URL a nobody notices  nobody cares 
>
>
> It handles the layout, the error checking and all sorts of stuff
>
> It's the first version, so no error catching (yet)
>
> Check my post on 14th March for further info
>
> Further versions soon...
>
> 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: Insert Into Query Bombing Out - What Am I Not Seeing?


> >>1, read Ben Forta's "To # or not to #"
>
> Where is that located?  Thanks,

There's a link from www.forta.com under CF Resources

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: cfm-resources.com

2001-03-15 Thread Steve Aylor


Whats New For: March 13th, 2001
ASP (Too Many Client Tasks) Error
Tito and I have been working on this error this week, we're working to bring
it to an end. We've been discussing solution possibilities with other system
administrators and are installing patches and service packs. We'll keep you
updated on this issue!

We' almost in the final stages of the move to Verio, paid members under the
Silver, Gold & Platinum accounts, will be moved to the new server within 2
weeks... The new server will show you improvements instantly upon your site
being moved!
- Original Message -
From: "Bernd VanSkiver" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 12:39 PM
Subject: cfm-resources.com


> I just came across www.cfm-resources.com and was wondering if anyone is
> using them?  I just am skeptical of their service because of its price,
> seems way to good to be true.  Please let me know of your good/bad
> experiences with them.
>
> Bernd VanSkiver
> [EMAIL PROTECTED]
> ColdFusion Developer
> 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: cfm-resources.com

2001-03-15 Thread C. Hatton Humphrey


I'm using them for my personal site.  It's been going well for a while, but
you definitely have a case of "you get what you pay for".  I'm using their
free service.

The one comment that I have to say is that the owner (and he's the only
admin) is definitely doing his best to keep everything going.

Hatton

> -Original Message-
> From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 15, 2001 3:39 PM
> To: CF-Talk
> Subject: cfm-resources.com
>
>
> I just came across www.cfm-resources.com and was wondering if anyone is
> using them?  I just am skeptical of their service because of its price,
> seems way to good to be true.  Please let me know of your good/bad
> experiences with them.
>
> Bernd VanSkiver
> [EMAIL PROTECTED]
> ColdFusion Developer
> 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: cfm-resources.com

2001-03-15 Thread Jason Lotz


I use them for several sites.  I wouldn't recommend them for anything
"mission critical" but there is nothing hidden in the costs.  It truly is a
free hosting service that works as expected.  Go for it!

Jason

- Original Message -
From: "Bernd VanSkiver" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 1:39 PM
Subject: cfm-resources.com


> I just came across www.cfm-resources.com and was wondering if anyone is
> using them?  I just am skeptical of their service because of its price,
> seems way to good to be true.  Please let me know of your good/bad
> experiences with them.
>
> Bernd VanSkiver
> [EMAIL PROTECTED]
> ColdFusion Developer
> 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: cfm-resources.com

2001-03-15 Thread Savan Thongvanh




i use them for development purposes only.  i even use their free service.  the
web master seems to be a decent guy.  performance-wise they seem to be up to
par, good luck trying to do long processes i.e., cfmail.




"Bernd VanSkiver" <[EMAIL PROTECTED]> on 03/15/2001 02:39:09 PM

Please respond to [EMAIL PROTECTED]

To:   CF-Talk <[EMAIL PROTECTED]>
cc:(bcc: Savan Thongvanh/DSM/Seabury)

Subject:  cfm-resources.com



I just came across www.cfm-resources.com and was wondering if anyone is
using them?  I just am skeptical of their service because of its price,
seems way to good to be true.  Please let me know of your good/bad
experiences with them.

Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer
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: exploiting shopping carts

2001-03-15 Thread Tony Schreiber


On my shopping cart program, I don't pass prices around. It works like
this:

You get a CartID as a session variable. Anything in your shopping cart is
in the CartPart table with that ID and ProductID, Qty and any Options
(size, color). When you order, the CartParts are moved into OrderParts and
the current price (regular, sale, whatever) is stored in the OrderParts
table. The price of the item is never passed around anywhere. The only
thing sensitive exposed is the CartID and once moved into the order stage,
that's secured with the username/password of the customer...

In fact, I built my whole cart with out forms, using all gets insteads.
The only post is at the end. Made making links and quantity changes easy.

> I just got this article today about how people are exploiting shopping cart
> logic to change prices and essentially stealing products. After some testing
> on my own carts I have been able to exploit some of them by building a form
> with all there required hidden fields and modifying there values. Of course
> this wouldn't be a problem if they weren't sending pricing information as a
> hidden variable but many of them do. Do you guys have any recommendation for
> preventing this on carts built this way? I've thought of checking the
> http_referer to make sure the request comes from the same domain the site is
> in but I'm not sure there isn't a better solution that I'm missing. I've
> attached the address to the article for you all to read.
> 
> http://msn.zdnet.com/msn/zdnet/story/0%2C12461%2C2692337-hud00025mn6%2C00.ht
> ml
> 
> Rick
> 
> 
>
~~
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

Control Panels for Remote Administration of Datasources for multiple clients

2001-03-15 Thread Daryl Fullerton


Hi all

We are opening up our servers in Hosting division for clients to
remotely administrate datasources.

Up to now we relied on email messages or phone for client requests for
datasource additions / alterations.

Just wondering what everyones views are on control panels and which ones
they have experience with from security points of view.

Anyone recocommend or got preferences.

Thanks

D


Daryl Fullerton,
Managing Partner,
BizNet Solutions,
Allaire Premier Partner (Ireland)
133 - 137 Lisburn Road
Belfast
BT9 7AG
N.Ireland

Direct +44 (0) 28 9022 7888
Tel  +44 (0) 028 9022 3224
Fax +44 (0) 028 9022 3223


[EMAIL PROTECTED]
Http://www.BizNet-Solutions.com

[EMAIL PROTECTED] (Chairman)
Http://www.cfug.ie The Irish Cold Fusion User Group


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

help

2001-03-15 Thread Joshua Tipton


I have an access db that is locked.  User cant remeber the password.  Does
anyone know how to get the password or do you have a util to do so?


Joshua Tipton


~~
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: exploiting shopping carts

2001-03-15 Thread Robert Everland


What I do is this. The only fields I pass are the products Id, so when I go
to the add to cart page I do another query that gets the price again and
then I make that a client variable. Little more processing but my car would
be safe from price tricking. 

Robert Everland III
Web Developer
Dixon Ticonderoga


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 2:27 PM
To: CF-Talk
Subject: exploiting shopping carts


Hey all,

I just got this article today about how people are exploiting shopping cart
logic to change prices and essentially stealing products. After some testing
on my own carts I have been able to exploit some of them by building a form
with all there required hidden fields and modifying there values. Of course
this wouldn't be a problem if they weren't sending pricing information as a
hidden variable but many of them do. Do you guys have any recommendation for
preventing this on carts built this way? I've thought of checking the
http_referer to make sure the request comes from the same domain the site is
in but I'm not sure there isn't a better solution that I'm missing. I've
attached the address to the article for you all to read.

http://msn.zdnet.com/msn/zdnet/story/0%2C12461%2C2692337-hud00025mn6%2C00.ht
ml

Rick
~~
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: Nested Query

2001-03-15 Thread Hayes, David


E_ID='#RESOURCE_ID#'

If this is an integer field, it shouldn't have the single quotes around the
value.

Prepare to hear feedback on using "select *".



-Original Message-
From: Michael S. Kimmett [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 2:34 PM
To: CF-Talk
Subject: Nested Query


I am having the worst time trying to figure out why the last query( See
Below ) in this chain of if statements is not working.  The error that I am
getting from the CFServer when I try to execute the last query is:

Message: ODBC Error Code = 37000 (Syntax error or access violation) 
Detail: [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data
type varchar to numeric. 

The query is being populated from a form and all the other queries are
working except for the last one (However all the queries are working in the
MS Query Analyzer when hard coded with data).  I have done a  to
check what type of data is being input into the query, but the data is
correct!  Anyone have an idea as to why this last query is not working?

Thanks in advance.

Michael



  
   
   


SELECT * FROM CMD_CTR, ACT_ITEM, EMPLOYEE 
WHERE CMD_CTR.ACTION_ID=ACT_ITEM.ACTION_ID
AND CMD_CTR.E_ID=EMPLOYEE.E_ID 
AND CMD_CTR.E_ID='#RESOURCE_ID#'
AND CMD_CTR.P_ID='#PROJECT_ID#'
AND ACT_ITEM.OPEN_DATE='#OPEN_DATE#'
AND ACT_ITEM.CLOSE_DATE='#CLOSE_DATE#' 
  

   


SELECT * FROM CMD_CTR, ACT_ITEM, EMPLOYEE 
WHERE CMD_CTR.ACTION_ID=ACT_ITEM.ACTION_ID
AND CMD_CTR.E_ID=EMPLOYEE.E_ID 
AND CMD_CTR.E_ID='#RESOURCE_ID#'
AND CMD_CTR.P_ID='#PROJECT_ID#'
AND ACT_ITEM.OPEN_DATE='#OPEN_DATE#'
 
  

 
   

SELECT * FROM CMD_CTR, ACT_ITEM, EMPLOYEE 
WHERE CMD_CTR.ACTION_ID=ACT_ITEM.ACTION_ID
AND CMD_CTR.E_ID=EMPLOYEE.E_ID 
AND CMD_CTR.E_ID='#RESOURCE_ID#'
AND CMD_CTR.P_ID='#PROJECT_ID#'
 
  

  



SELECT * FROM CMD_CTR 
WHERE 
 E_ID='#RESOURCE_ID#'
 
  
  
 
   
   

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

Cold fusion has top line blank.......

2001-03-15 Thread Richard Kuryk


We have two server and on one server with cf4.5sp2 the text "COLD FUSION
BLOWS" appears on the very top line of the source but on another server with
cf4.5sp1 "COLD FUSION BLOWS" appears a line down.  The exact same source.
This doesn't seem like a big deal but my xml/xsl parser flips out if  is not on the first line.  I have all pasted the source
below and it is a single line file.  Any thoughts on how I can fix this?

Sorry about the knock to cold fusion but I have been banging my head all day
on this one!

Thanks you

Rich

SOURCE:
LINE1:writeoutput(StripCR("COLD FUSION
BLOWS!"));


~~
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: enumerating variables


Server variables are not available for security reason. Client variables are
retrieveable with getClientVariableList().

jon
- Original Message -
From: "Richard Meredith-Hardy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 3:09 PM
Subject: enumerating variables


> With my debug script I can enumerate most system variables thus:
>
>
> 
> 
> 
> 
> 
> #struct# variables:
> 
> #var#:
> 
> A structure
> 
> An array
> 
> A query
> 
> #structfind(evaluate(struct),var)#
> 
> 
> 
> 
> 
> 
> #struct# not defined 
> 
> 
>
>
> But
>
> server.variables, client.variables and variables.variables don't seem to
> be accessible at all in the method above or any other 'automated' way
> (try adding them to structlist);  - is there a way of enumerating them
> all at the end of a page?
>
>
> --
> Regards;
>
> Richard Meredith-Hardy
> -
> [EMAIL PROTECTED]
> Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668
>
>
~~
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: Re:RE: Form Fields cleared on Back


http://www.aspmedia.co.uk/CF/




"Carol Bluestein" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Tried it, Philip, but my browser could not read the URL.
> But, I must say, it is a very well-done website.
>
> Carol L. Bluestein
> Senior Programmer
> NYS Office of Real Property
> 518-486-6335
> [EMAIL PROTECTED]
>
>
> Reply Separator
> Subject:RE: Form Fields cleared on Back
> Author: [EMAIL PROTECTED]
> Date:   3/15/01 6:58 PM
>
> > What editor thingy is that Phillip?
>
> I posted the URL a nobody notices  nobody cares 
>
> http://www.aspmedia.co.uk/CF/_EditForm.cfm
>
> It handles the layout, the error checking and all sorts of stuff
>
> It's the first version, so no error catching (yet)
>
> Check my post on 14th March for further info
>
> Further versions soon...
>
> 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: XML

2001-03-15 Thread bflynn


OK - different subject, so I'm following with a different email:

Let me point out a very good reason NOT to use CF for XML.  When you get
XML, you have to compare it to your DTD and then parse it to get the data
out.  I'm not sure about you, but writing a parser as complex as this in CF
doesn't sit very high on the list of things I want to do.

On the other hand, there are plenty of Java (and other languages) XML
parsers out there.  The apache organization maintains a very nice one called
"xerces" which is seeing a lot of use.  I think Sun may also distribute
their own version of an XML parser.

So, short summary - there are no existing CF parsers for XML (that I know
of...if I'm wrong, someone please correct me).  Handling XML is pretty
process intensive, and lets be honest, thats not really CF's strong point.

Brian

-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 4:21 PM
To: CF-Talk
Subject: XML


what are the advantages of using XML with my coldfusion web apps?  like what
cool stuff can I do?  and is XML hard to learn?
~~
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: enumerating variables

2001-03-15 Thread Aaron Johnson


hi Richard,

I'm pretty sure that you can't, but for good reason. Many people use CF in a
shared environment. If you could enumerate server, client & variables, you
could see *every* server client & variable that every person is using on the
server.. :)  I admit, that would be fun, but most likely will not be
available anytime soon.

Aaron Johnson, MCSE, MCP+I
Allaire Certified ColdFusion Developer
MINDSEYE, Inc.
617.350.0339
617.350.8884
66172567
[EMAIL PROTECTED]

-Original Message-
From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 3:09 PM
To: CF-Talk
Subject: enumerating variables


With my debug script I can enumerate most system variables thus:







#struct# variables:

#var#:

A structure

An array

A query

#structfind(evaluate(struct),var)#






#struct# not defined 




But

server.variables, client.variables and variables.variables don't seem to
be accessible at all in the method above or any other 'automated' way
(try adding them to structlist);  - is there a way of enumerating them
all at the end of a page?


--
Regards;

Richard Meredith-Hardy
-
[EMAIL PROTECTED]
Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668
~~
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: Code review PLEASE


I took out the max rows, and reposted it and everything works fine,  well
kinda fine, the only dilema now is that once you go past the last record it
show's a blank page,  and vice versa for the first page if you scroll back,
so now I am trying to figure that one out,  thank you to all that answered.

Michael



"Adkins, Randy" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Put CFOUTPTUT around the CFSET for your NEXT/PREV variables
>
> Your MAXROWS=1 is fine
>
> -Original Message-
> From: Mike [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 15, 2001 2:47 PM
> To: CF-Talk
> Subject: Re: Code review PLEASE
>
>
> Your the second one to say that, but locally everything works fine,  if I
> turn the max rows off then I will see all the records and I only want to
see
> one record at time
>
>
> Michael
>
>
>
> "Cami Lawson" <[EMAIL PROTECTED]> wrote in message
> 010001c0ad87$6836dcb0$[EMAIL PROTECTED]">news:010001c0ad87$6836dcb0$[EMAIL PROTECTED]...
> > You have a maxrows = 1 on the query.
> >
> > $.02
> > - Original Message -
> > From: "Mike" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, March 15, 2001 12:59 PM
> > Subject: Code review PLEASE
> >
> >
> > > This is really making me go bald,  I have a page that has next and
> > previous,
> > > and when viewed locally I can see everything, when I ftp to my host
(and
> > yes
> > > the odbc is working and correct) I can only see the first record, and
> > > nothing after that.
> > >
> > > I have tried putting the database(access) in the database folder, and
> > > straight in the directory with all the pages and I still get the same
> > > result, I have replaced the database, and contacted my host, and they
> say
> > > that the code is fine from what little the guy knew about CF.
> > >
> > > Below is the code if someone could share there knowledge I would as
> always
> > > appreciate it.
> > >
> > > And thank you
> > >
> > >
> > > 
> > >
> > > 
> > > 
> > > 
> > >
> > >  > > dbtype="ODBC">
> > > SELECT  ID, EmpCandidate, SKillBackground, Status, Recruiter,
> Profile
> > > FROMinterview
> > > WHERE ID=#ID#
> > > 
> > >
> > > 
> > > 
> > >
> > > Interview Candidates
> > > 
> > >
> > > 
> > > 
> > > 
> > >
> > > 
> > > 
> > > 
> > >  ID
> > >  #id#
> > > 
> > > 
> > >  Candidate Name
> > >  #EmpCandidate#
> > > 
> > > 
> > >  Skill Background
> > >  #SKillBackground#
> > > 
> > > 
> > >  Status
> > >  #Status#
> > > 
> > > 
> > >  Recruiter
> > >  #Recruiter#
> > > 
> > > 
> > >  Profile
> > >   name="Profile">#profile#
> > > 
> > > 
> > > 
> > > 
> > > 
> > > Previous
> > > Next
> > > 
> > > 
> > >
> > >
> > >
> > >
> >
>
~~
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 Fields cleared on Back


Hiya Philip,
I did a little testing, and the issue (at least for me) was the direction of
the slash.

So:
variables.thisTemplateName=ListLast(CGI.CF_TEMPLATE_PATH,"/");

Is fine, while:
variables.thisTemplateName=ListLast(CGI.CF_TEMPLATE_PATH,"\");

Pulls the local file structure (as there is not occurence of the list
delimiter, it pulls the whole thing). (Same thing happens on our production
server.)

-d



Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923




~~
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: Code review PLEASE


Mike do a little debugging on the host. What is the value of #nextid# and
#previd# on the page? When you click next on the host, does it show the
first record everytime? Does the url always say default2.cfm?ID=2  ?
If so, it's obvious that the sql statement is not picking up the url
variable and probably is only picking up the cfparam variable.

Try scoping your variables just to make sure. If this isn't the problem it
is always a good idea to scope variables, it makes the code a little easier
to read later on, and it executes faster.





SELECT  ID, EmpCandidate, SKillBackground, Status, Recruiter, Profile
FROMinterview
WHERE ID=#url.id#





Notice no pound signs within the cfsets, it is again easier to read and
executes slightly faster.

One problem I see is that you are relying the ID to be sequential in the
database. If you delete a record, eventually you will run into a query that
has no record and shows a blank page.
I think a better way to do all this if the user does not have the ability to
edit records, would be to cache the query and use startrow and maxrow in
your cfoutput. Like so...




SELECT  ID, EmpCandidate, SKillBackground, Status, Recruiter, Profile






Data here

Previous
Next


This will work even without caching, but might as well make it quicker.


jon
- Original Message -
From: "Mike" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 1:59 PM
Subject: Code review PLEASE


> This is really making me go bald,  I have a page that has next and
previous,
> and when viewed locally I can see everything, when I ftp to my host (and
yes
> the odbc is working and correct) I can only see the first record, and
> nothing after that.
>
> I have tried putting the database(access) in the database folder, and
> straight in the directory with all the pages and I still get the same
> result, I have replaced the database, and contacted my host, and they say
> that the code is fine from what little the guy knew about CF.
>
> Below is the code if someone could share there knowledge I would as always
> appreciate it.
>
> And thank you
>
>
> 
>
> 
> 
> 
>
>  dbtype="ODBC">
> SELECT  ID, EmpCandidate, SKillBackground, Status, Recruiter, Profile
> FROMinterview
> WHERE ID=#ID#
> 
>
> 
> 
>
> Interview Candidates
> 
>
> 
> 
> 
>
> 
> 
> 
>  ID
>  #id#
> 
> 
>  Candidate Name
>  #EmpCandidate#
> 
> 
>  Skill Background
>  #SKillBackground#
> 
> 
>  Status
>  #Status#
> 
> 
>  Recruiter
>  #Recruiter#
> 
> 
>  Profile
>  #profile#
> 
> 
> 
> 
> 
> Previous
> Next
> 
> 
>
>
>
>
~~
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: XML

2001-03-15 Thread bflynn


I think everyone has done a pretty good job of describing what XML is and
what it can do.  Let me add one comment on the difference between HTML and
XHTML:  XHTML is really just stricter HTML.  Tags that are opened must be
closed and must be properly nested.  Thats pretty much the most significant
rules.  I misremember right now, but it seems there was to be something
about stricter controls over how tables get displayed too...maybe that was a
different XML child.

Because XHTML is a subset of XML, it can be validated exactly by using a
DTD.  A DTD is just an XML document which descibes how things can be put
together.  A DTD is a lot like a regular grammer.  With a few minor
exceptions, you're probably already writing XHTML.

Some quick examples: In HTML, this is legal (OK, it doesn't even make sense,
I'm just demostrating):



  A
  B





In XHTML, its not - The option and BR statments are never closed and the
table and paragraph marks are not nested correctly.  



  A
  B





Brian

-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 4:21 PM
To: CF-Talk
Subject: XML


what are the advantages of using XML with my coldfusion web apps?  like what
cool stuff can I do?  and is XML hard to learn?
~~
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

cfm-resources.com

2001-03-15 Thread Bernd VanSkiver


I just came across www.cfm-resources.com and was wondering if anyone is 
using them?  I just am skeptical of their service because of its price, 
seems way to good to be true.  Please let me know of your good/bad 
experiences with them.

Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer
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

Nested Query

2001-03-15 Thread Michael S. Kimmett


I am having the worst time trying to figure out why the last query( See Below ) in 
this chain of if statements is not working.  The error that I am getting from the 
CFServer when I try to execute the last query is:

Message: ODBC Error Code = 37000 (Syntax error or access violation) 
Detail: [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type 
varchar to numeric. 

The query is being populated from a form and all the other queries are working except 
for the last one (However all the queries are working in the MS Query Analyzer when 
hard coded with data).  I have done a  to check what type of data is being 
input into the query, but the data is correct!  Anyone have an idea as to why this 
last query is not working?

Thanks in advance.

Michael



  
   
   


SELECT * FROM CMD_CTR, ACT_ITEM, EMPLOYEE 
WHERE CMD_CTR.ACTION_ID=ACT_ITEM.ACTION_ID
AND CMD_CTR.E_ID=EMPLOYEE.E_ID 
AND CMD_CTR.E_ID='#RESOURCE_ID#'
AND CMD_CTR.P_ID='#PROJECT_ID#'
AND ACT_ITEM.OPEN_DATE='#OPEN_DATE#'
AND ACT_ITEM.CLOSE_DATE='#CLOSE_DATE#' 
  

   


SELECT * FROM CMD_CTR, ACT_ITEM, EMPLOYEE 
WHERE CMD_CTR.ACTION_ID=ACT_ITEM.ACTION_ID
AND CMD_CTR.E_ID=EMPLOYEE.E_ID 
AND CMD_CTR.E_ID='#RESOURCE_ID#'
AND CMD_CTR.P_ID='#PROJECT_ID#'
AND ACT_ITEM.OPEN_DATE='#OPEN_DATE#'
 
  

 
   

SELECT * FROM CMD_CTR, ACT_ITEM, EMPLOYEE 
WHERE CMD_CTR.ACTION_ID=ACT_ITEM.ACTION_ID
AND CMD_CTR.E_ID=EMPLOYEE.E_ID 
AND CMD_CTR.E_ID='#RESOURCE_ID#'
AND CMD_CTR.P_ID='#PROJECT_ID#'
 
  

  



SELECT * FROM CMD_CTR 
WHERE 
 E_ID='#RESOURCE_ID#'
 
  
  
 
   
   


 



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

CFMAIL

2001-03-15 Thread Savan Thongvanh




Why is it that when i submit a form to this snipped I don't throw an exception
but I never get the email?
the email addy is good and the server i know is good.




Contact Form Received from:
#form.email#

Message body:

#form.buzword#

===End Message===



confirmation blah blah blah

exception stuff





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

exploiting shopping carts

2001-03-15 Thread Rick Lamb


Hey all,

I just got this article today about how people are exploiting shopping cart
logic to change prices and essentially stealing products. After some testing
on my own carts I have been able to exploit some of them by building a form
with all there required hidden fields and modifying there values. Of course
this wouldn't be a problem if they weren't sending pricing information as a
hidden variable but many of them do. Do you guys have any recommendation for
preventing this on carts built this way? I've thought of checking the
http_referer to make sure the request comes from the same domain the site is
in but I'm not sure there isn't a better solution that I'm missing. I've
attached the address to the article for you all to read.

http://msn.zdnet.com/msn/zdnet/story/0%2C12461%2C2692337-hud00025mn6%2C00.ht
ml

Rick


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

Insert Into Query Bombing Out - SOLVED

2001-03-15 Thread Chris Montgomery


Ok, I knew it was something stupid. "From" is apparently a reserved word in
Access. I changed the field name to something else and it worked.

Sorry to pester everyone.

Chris


~~
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: Code review PLEASE


Yes

"Stephenie Hamilton" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> this may seem pretty obvious, but is your host using the same version of
CF
> as you are locally?
>
> --
> Stephenie Hamilton
> Senior ColdFusion Administrator
> Express Technologies, Inc.
> want CF_Freedom?
> try CFXHosting.com
>
>
>
>
> -Original Message-
> From: Mike [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 15, 2001 2:47 PM
> To: CF-Talk
> Subject: Re: Code review PLEASE
>
>
> Your the second one to say that, but locally everything works fine,  if I
> turn the max rows off then I will see all the records and I only want to
see
> one record at time
>
>
> Michael
>
>
>
> "Cami Lawson" <[EMAIL PROTECTED]> wrote in message
> 010001c0ad87$6836dcb0$[EMAIL PROTECTED]">news:010001c0ad87$6836dcb0$[EMAIL PROTECTED]...
> > You have a maxrows = 1 on the query.
> >
> > $.02
> > - Original Message -
> > From: "Mike" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, March 15, 2001 12:59 PM
> > Subject: Code review PLEASE
> >
> >
> > > This is really making me go bald,  I have a page that has next and
> > previous,
> > > and when viewed locally I can see everything, when I ftp to my host
(and
> > yes
> > > the odbc is working and correct) I can only see the first record, and
> > > nothing after that.
> > >
> > > I have tried putting the database(access) in the database folder, and
> > > straight in the directory with all the pages and I still get the same
> > > result, I have replaced the database, and contacted my host, and they
> say
> > > that the code is fine from what little the guy knew about CF.
> > >
> > > Below is the code if someone could share there knowledge I would as
> always
> > > appreciate it.
> > >
> > > And thank you
> > >
> > >
> > > 
> > >
> > > 
> > > 
> > > 
> > >
> > >  > > dbtype="ODBC">
> > > SELECT  ID, EmpCandidate, SKillBackground, Status, Recruiter,
> Profile
> > > FROMinterview
> > > WHERE ID=#ID#
> > > 
> > >
> > > 
> > > 
> > >
> > > Interview Candidates
> > > 
> > >
> > > 
> > > 
> > > 
> > >
> > > 
> > > 
> > > 
> > >  ID
> > >  #id#
> > > 
> > > 
> > >  Candidate Name
> > >  #EmpCandidate#
> > > 
> > > 
> > >  Skill Background
> > >  #SKillBackground#
> > > 
> > > 
> > >  Status
> > >  #Status#
> > > 
> > > 
> > >  Recruiter
> > >  #Recruiter#
> > > 
> > > 
> > >  Profile
> > >   name="Profile">#profile#
> > > 
> > > 
> > > 
> > > 
> > > 
> > > Previous
> > > Next
> > > 
> > > 
> > >
> > >
> > >
> > >
> >
>
~~
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: XML Anyone?

2001-03-15 Thread David Gassner


kev,

Take a look at the examples I put together for last year's conference:

http://www.vintageapps.com/conference.cfm

They detail how to use the MSXML3 COM object and a bit on the Java-based
Xerces library.

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 15, 2001 11:49 AM
> To: CF-Talk
> Subject: XML Anyone?
>
>
> Surely all of you smart people can direct me to some awesome
> resources on CF
> with XML or vice versa
>
> Thanks a bunch
>
> kev
>
> ~
> Kevin Mansel
> Web Developer
> Fox Communications
> [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: XML Anyone?

2001-03-15 Thread Steve Aylor


www.granularity.com

GIAXT

- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 11:48 AM
Subject: XML Anyone?


> Surely all of you smart people can direct me to some awesome resources on
CF
> with XML or vice versa
>
> Thanks a bunch
>
> kev
>
> ~
> Kevin Mansel
> Web Developer
> Fox Communications
> [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: Broken Images / Testing for file existence - JS to the rescue

2001-03-15 Thread ron

Tony,

Let the client-side box do the work, with JavaScript. Here's a demo page
that tests for the presence of an image, and swaps the missing image with a
default image... I'm sure you can modify it to your needs:

Image Not Found Test

Tested with IE and NS v4+ on PC; even if it doesn't work on other browsers,
it shouldn't break anything since they'll just ignore the event handler.

A big thanks to Jeff Howden at evolt.org for pointing out the onError event
handler for  tags to me initially.

Ron Allen Hornbaker
President/CTO
Humankind Systems, Inc.
http://humankindsystems.com
mailto:[EMAIL PROTECTED]

> -Original Message-
> From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 14, 2001 6:38 AM
> To: CF-Talk
> Subject: RE: Broken Images / Testing for file existence - JS to the
> rescue
>
>
> This sounds interesting and I seem to have missed the suggestion/code...
> What was it?
>
> > [EMAIL PROTECTED] wrote:
> >
> > > Let the client-side box do the work, with JavaScript.
> >
> > Interesting possibility.  Of course, that still clutters your
> > server log with 404 errors, which may be a consideration.  And
> > it requires additional network traffic, which may slow down the
> > page display.  But there are always tradeoffs.
> >
> > Keith C. Ivey <[EMAIL PROTECTED]>
> > Webmaster, EEI Communications
> > 66 Canal Center Plaza, Suite 200
> > Alexandria, VA  22314
> > Telephone:  703-683-0683
> > Fax:  703-683-4915
> > Web Site:  http://www.eeicommunications.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

Re: Code review PLEASE

2001-03-15 Thread Jason Lotz


Take maxrows out of the  and add it to the  along with a
startrow attribute.

Jason

- Original Message -
From: "Mike" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 12:46 PM
Subject: Re: Code review PLEASE


> Your the second one to say that, but locally everything works fine,  if I
> turn the max rows off then I will see all the records and I only want to
see
> one record at time
>
>
> Michael
>
>
>
> "Cami Lawson" <[EMAIL PROTECTED]> wrote in message
> 010001c0ad87$6836dcb0$[EMAIL PROTECTED]">news:010001c0ad87$6836dcb0$[EMAIL PROTECTED]...
> > You have a maxrows = 1 on the query.
> >
> > $.02
> > - Original Message -
> > From: "Mike" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, March 15, 2001 12:59 PM
> > Subject: Code review PLEASE
> >
> >
> > > This is really making me go bald,  I have a page that has next and
> > previous,
> > > and when viewed locally I can see everything, when I ftp to my host
(and
> > yes
> > > the odbc is working and correct) I can only see the first record, and
> > > nothing after that.
> > >
> > > I have tried putting the database(access) in the database folder, and
> > > straight in the directory with all the pages and I still get the same
> > > result, I have replaced the database, and contacted my host, and they
> say
> > > that the code is fine from what little the guy knew about CF.
> > >
> > > Below is the code if someone could share there knowledge I would as
> always
> > > appreciate it.
> > >
> > > And thank you
> > >
> > >
> > > 
> > >
> > > 
> > > 
> > > 
> > >
> > >  > > dbtype="ODBC">
> > > SELECT  ID, EmpCandidate, SKillBackground, Status, Recruiter,
> Profile
> > > FROMinterview
> > > WHERE ID=#ID#
> > > 
> > >
> > > 
> > > 
> > >
> > > Interview Candidates
> > > 
> > >
> > > 
> > > 
> > > 
> > >
> > > 
> > > 
> > > 
> > >  ID
> > >  #id#
> > > 
> > > 
> > >  Candidate Name
> > >  #EmpCandidate#
> > > 
> > > 
> > >  Skill Background
> > >  #SKillBackground#
> > > 
> > > 
> > >  Status
> > >  #Status#
> > > 
> > > 
> > >  Recruiter
> > >  #Recruiter#
> > > 
> > > 
> > >  Profile
> > >   name="Profile">#profile#
> > > 
> > > 
> > > 
> > > 
> > > 
> > > Previous
> > > Next
> > > 
> > > 
> > >
> > >
> > >
> > >
> >
>
>
~~
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: XML Anyone?


Here is one
http://www.siteobjects.com/examples/soxml/index.cfm

jon
- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 2:48 PM
Subject: XML Anyone?


> Surely all of you smart people can direct me to some awesome resources on
CF
> with XML or vice versa
>
> Thanks a bunch
>
> kev
>
> ~
> Kevin Mansel
> Web Developer
> Fox Communications
> [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

enumerating variables

2001-03-15 Thread Richard Meredith-Hardy


With my debug script I can enumerate most system variables thus:







#struct# variables:

#var#:
 
A structure

An array

A query

#structfind(evaluate(struct),var)#






#struct# not defined 




But 

server.variables, client.variables and variables.variables don't seem to
be accessible at all in the method above or any other 'automated' way
(try adding them to structlist);  - is there a way of enumerating them
all at the end of a page?


--
Regards;

Richard Meredith-Hardy
-
[EMAIL PROTECTED]
Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668

~~
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: Regular expression help

2001-03-15 Thread Douglas Malcolm


Leaves table tags in:

([[:alpha:]]|[[:s
pace:]]|[[:punct:]])+','')#>


Removes table tags:

([[:alpha:]]|[[:s
pace:]]|[[:punct:]])+','')#>


Note that the default attribute for scope is "one", so the above snippet
will only remove the first instance it finds of table tags.  Change the
scope to "all" if you want them all gone.

Of course, if you only want one very specific table tag set to be removed,
you'll have to find it another way (adding some other unique text for the
regexp to look for).


Douglas Malcolm



-Original Message-
From: Jeff Britts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 11:50 AM
To: CF-Talk
Subject: Regular expression help


Help for a regular expression idiot.

I'm looking to remove all the characters between two tags:

example
from:  asldfj lskdf jaskldf jklasdf jlaskdfj lasdkf 

to: 


(removing the tags themselves would be a plus)
~~
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: Code review PLEASE

2001-03-15 Thread Adkins, Randy


Put CFOUTPTUT around the CFSET for your NEXT/PREV variables

Your MAXROWS=1 is fine

-Original Message-
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 2:47 PM
To: CF-Talk
Subject: Re: Code review PLEASE


Your the second one to say that, but locally everything works fine,  if I
turn the max rows off then I will see all the records and I only want to see
one record at time


Michael



"Cami Lawson" <[EMAIL PROTECTED]> wrote in message
010001c0ad87$6836dcb0$[EMAIL PROTECTED]">news:010001c0ad87$6836dcb0$[EMAIL PROTECTED]...
> You have a maxrows = 1 on the query.
>
> $.02
> - Original Message -
> From: "Mike" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, March 15, 2001 12:59 PM
> Subject: Code review PLEASE
>
>
> > This is really making me go bald,  I have a page that has next and
> previous,
> > and when viewed locally I can see everything, when I ftp to my host (and
> yes
> > the odbc is working and correct) I can only see the first record, and
> > nothing after that.
> >
> > I have tried putting the database(access) in the database folder, and
> > straight in the directory with all the pages and I still get the same
> > result, I have replaced the database, and contacted my host, and they
say
> > that the code is fine from what little the guy knew about CF.
> >
> > Below is the code if someone could share there knowledge I would as
always
> > appreciate it.
> >
> > And thank you
> >
> >
> > 
> >
> > 
> > 
> > 
> >
> >  > dbtype="ODBC">
> > SELECT  ID, EmpCandidate, SKillBackground, Status, Recruiter,
Profile
> > FROMinterview
> > WHERE ID=#ID#
> > 
> >
> > 
> > 
> >
> > Interview Candidates
> > 
> >
> > 
> > 
> > 
> >
> > 
> > 
> > 
> >  ID
> >  #id#
> > 
> > 
> >  Candidate Name
> >  #EmpCandidate#
> > 
> > 
> >  Skill Background
> >  #SKillBackground#
> > 
> > 
> >  Status
> >  #Status#
> > 
> > 
> >  Recruiter
> >  #Recruiter#
> > 
> > 
> >  Profile
> >  #profile#
> > 
> > 
> > 
> > 
> > 
> > Previous
> > Next
> > 
> > 
> >
> >
> >
> >
>
~~
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: Code review PLEASE

2001-03-15 Thread Judith Campbell

At 02:46 PM 3/15/01 -0500, you wrote:
>Your the second one to say that, but locally everything works fine,  if I
>turn the max rows off then I will see all the records and I only want to see
>one record at time
>
>
>Michael

The problem isn't with maxrows, it's with ID.  the cfparam statement isn't 
finding it so it sets it to the default of one.

~~
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: Custom Tag

2001-03-15 Thread Dave Watts


> Am I right in thinking that you could also 
> assign the query to the request scope in the calling
> page and reference it that way in the tag?

Yes, you could. However, from a best practices perspective, you'd want to be
careful about doing that, as the Request scope is shared by all scripts
within a single request.

Ideally, when you write a custom tag, you write it so that it's
self-contained: all of the data it needs are contained within attributes,
and all the return values are created using variable names specified by the
caller. While the Request scope is handy for deeply-nested and recursive
custom tags, using that scope as a shared area between custom tag and
calling page violates the self-containment mentioned above.

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

Re: Code review PLEASE


Mike,
You can still use my previous post- it's set for 5 records at a time, but
just change the maxrows attribute to 1.

But, do this: output the recordcount of your query (without the maxrows
attribute). See if for some reason your database is only returning one row.

-d




Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923




~~
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: Code review PLEASE

2001-03-15 Thread Douglas Malcolm


Michael,

What error are you getting when not-local?

Your code looks fine to me, I'm wondering if this bit is 100% correct
though:


Since it works fine the first time, the problem has got to be "after" the
first pass through, right?  Try making sure that ID is a not a string, and
is in fact a number after you increment it.

Douglas Malcolm



-Original Message-
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 11:47 AM
To: CF-Talk
Subject: Re: Code review PLEASE


Your the second one to say that, but locally everything works fine,  if I
turn the max rows off then I will see all the records and I only want to see
one record at time


Michael



"Cami Lawson" <[EMAIL PROTECTED]> wrote in message
010001c0ad87$6836dcb0$[EMAIL PROTECTED]">news:010001c0ad87$6836dcb0$[EMAIL PROTECTED]...
> You have a maxrows = 1 on the query.
>
> $.02
> - Original Message -
> From: "Mike" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, March 15, 2001 12:59 PM
> Subject: Code review PLEASE
>
>
> > This is really making me go bald,  I have a page that has next and
> previous,
> > and when viewed locally I can see everything, when I ftp to my host (and
> yes
> > the odbc is working and correct) I can only see the first record, and
> > nothing after that.
> >
> > I have tried putting the database(access) in the database folder, and
> > straight in the directory with all the pages and I still get the same
> > result, I have replaced the database, and contacted my host, and they
say
> > that the code is fine from what little the guy knew about CF.
> >
> > Below is the code if someone could share there knowledge I would as
always
> > appreciate it.
> >
> > And thank you
> >
> >
> > 
> >
> > 
> > 
> > 
> >
> >  > dbtype="ODBC">
> > SELECT  ID, EmpCandidate, SKillBackground, Status, Recruiter,
Profile
> > FROMinterview
> > WHERE ID=#ID#
> > 
> >
> > 
> > 
> >
> > Interview Candidates
> > 
> >
> > 
> > 
> > 
> >
> > 
> > 
> > 
> >  ID
> >  #id#
> > 
> > 
> >  Candidate Name
> >  #EmpCandidate#
> > 
> > 
> >  Skill Background
> >  #SKillBackground#
> > 
> > 
> >  Status
> >  #Status#
> > 
> > 
> >  Recruiter
> >  #Recruiter#
> > 
> > 
> >  Profile
> >  #profile#
> > 
> > 
> > 
> > 
> > 
> > Previous
> > Next
> > 
> > 
> >
> >
> >
> >
>
~~
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: Philips Edit Form


Yep, in the source code I'm getting this:
deann
[EMAIL PROTECTED]

Where x = drive letter on our web server.
Not so good.

-d



Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923




~~
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: Code review PLEASE


OK my miss understanding,  another developer showed me the prev and next
code and when they did, they told me that I didnt need the max rows anymore.
Although I question why it worked fine on the local machine and not when
posted?


THANK YOU


MICHAEL

egg on my face



"Cami Lawson" <[EMAIL PROTECTED]> wrote in message
010001c0ad87$6836dcb0$[EMAIL PROTECTED]">news:010001c0ad87$6836dcb0$[EMAIL PROTECTED]...
> You have a maxrows = 1 on the query.
>
> $.02
> - Original Message -
> From: "Mike" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, March 15, 2001 12:59 PM
> Subject: Code review PLEASE
>
>
> > This is really making me go bald,  I have a page that has next and
> previous,
> > and when viewed locally I can see everything, when I ftp to my host (and
> yes
> > the odbc is working and correct) I can only see the first record, and
> > nothing after that.
> >
> > I have tried putting the database(access) in the database folder, and
> > straight in the directory with all the pages and I still get the same
> > result, I have replaced the database, and contacted my host, and they
say
> > that the code is fine from what little the guy knew about CF.
> >
> > Below is the code if someone could share there knowledge I would as
always
> > appreciate it.
> >
> > And thank you
> >
> >
> > 
> >
> > 
> > 
> > 
> >
> >  > dbtype="ODBC">
> > SELECT  ID, EmpCandidate, SKillBackground, Status, Recruiter,
Profile
> > FROMinterview
> > WHERE ID=#ID#
> > 
> >
> > 
> > 
> >
> > Interview Candidates
> > 
> >
> > 
> > 
> > 
> >
> > 
> > 
> > 
> >  ID
> >  #id#
> > 
> > 
> >  Candidate Name
> >  #EmpCandidate#
> > 
> > 
> >  Skill Background
> >  #SKillBackground#
> > 
> > 
> >  Status
> >  #Status#
> > 
> > 
> >  Recruiter
> >  #Recruiter#
> > 
> > 
> >  Profile
> >  #profile#
> > 
> > 
> > 
> > 
> > 
> > Previous
> > Next
> > 
> > 
> >
> >
> >
> >
>
~~
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: Code review PLEASE

2001-03-15 Thread David E. Crawford


Well, how many records are you going to have in the table for a particular
ID?  If ID is the unique, primary key, the first time you run it, it selects
the record for ID=1, and gives you "prior" and "next" links for ID=0 and
ID=2.  The maxrows issue is a smokescreen to your real problem.  Check to
see what the value of ID is each time to make sure things are happening the
way you want them to. If there are gaps in in your ID values, you will also
have issues, as well as the fact that it is doubtful that you would have an
ID of 0.

DC

- Original Message -
From: "Mike" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 14:46
Subject: Re: Code review PLEASE


> Your the second one to say that, but locally everything works fine,  if I
> turn the max rows off then I will see all the records and I only want to
see
> one record at time
>
>
> Michael
>
>
>
> "Cami Lawson" <[EMAIL PROTECTED]> wrote in message
> 010001c0ad87$6836dcb0$[EMAIL PROTECTED]">news:010001c0ad87$6836dcb0$[EMAIL PROTECTED]...
> > You have a maxrows = 1 on the query.
> >
> > $.02
> > - Original Message -
> > From: "Mike" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, March 15, 2001 12:59 PM
> > Subject: Code review PLEASE
> >
> >
> > > This is really making me go bald,  I have a page that has next and
> > previous,
> > > and when viewed locally I can see everything, when I ftp to my host
(and
> > yes
> > > the odbc is working and correct) I can only see the first record, and
> > > nothing after that.
> > >
> > > I have tried putting the database(access) in the database folder, and
> > > straight in the directory with all the pages and I still get the same
> > > result, I have replaced the database, and contacted my host, and they
> say
> > > that the code is fine from what little the guy knew about CF.
> > >
> > > Below is the code if someone could share there knowledge I would as
> always
> > > appreciate it.
> > >
> > > And thank you
> > >
> > >
> > > 
> > >
> > > 
> > > 
> > > 
> > >
> > >  > > dbtype="ODBC">
> > > SELECT  ID, EmpCandidate, SKillBackground, Status, Recruiter,
> Profile
> > > FROMinterview
> > > WHERE ID=#ID#
> > > 
> > >
> > > 
> > > 
> > >
> > > Interview Candidates
> > > 
> > >
> > > 
> > > 
> > > 
> > >
> > > 
> > > 
> > > 
> > >  ID
> > >  #id#
> > > 
> > > 
> > >  Candidate Name
> > >  #EmpCandidate#
> > > 
> > > 
> > >  Skill Background
> > >  #SKillBackground#
> > > 
> > > 
> > >  Status
> > >  #Status#
> > > 
> > > 
> > >  Recruiter
> > >  #Recruiter#
> > > 
> > > 
> > >  Profile
> > >   name="Profile">#profile#
> > > 
> > > 
> > > 
> > > 
> > > 
> > > Previous
> > > Next
> > > 
> > > 
> > >
> > >
> > >
> > >
> >
>
~~
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:RE: Form Fields cleared on Back

2001-03-15 Thread Carol Bluestein


Tried it, Philip, but my browser could not read the URL.
But, I must say, it is a very well-done website.

Carol L. Bluestein
Senior Programmer
NYS Office of Real Property
518-486-6335
[EMAIL PROTECTED]


Reply Separator
Subject:RE: Form Fields cleared on Back
Author: [EMAIL PROTECTED]
Date:   3/15/01 6:58 PM

> What editor thingy is that Phillip?

I posted the URL a nobody notices  nobody cares 

http://www.aspmedia.co.uk/CF/_EditForm.cfm

It handles the layout, the error checking and all sorts of stuff

It's the first version, so no error catching (yet)

Check my post on 14th March for further info

Further versions soon...

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: Code review PLEASE

2001-03-15 Thread Stephenie Hamilton


this may seem pretty obvious, but is your host using the same version of CF
as you are locally?

--
Stephenie Hamilton
Senior ColdFusion Administrator
Express Technologies, Inc.
want CF_Freedom?
try CFXHosting.com




-Original Message-
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 2:47 PM
To: CF-Talk
Subject: Re: Code review PLEASE


Your the second one to say that, but locally everything works fine,  if I
turn the max rows off then I will see all the records and I only want to see
one record at time


Michael



"Cami Lawson" <[EMAIL PROTECTED]> wrote in message
010001c0ad87$6836dcb0$[EMAIL PROTECTED]">news:010001c0ad87$6836dcb0$[EMAIL PROTECTED]...
> You have a maxrows = 1 on the query.
>
> $.02
> - Original Message -
> From: "Mike" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, March 15, 2001 12:59 PM
> Subject: Code review PLEASE
>
>
> > This is really making me go bald,  I have a page that has next and
> previous,
> > and when viewed locally I can see everything, when I ftp to my host (and
> yes
> > the odbc is working and correct) I can only see the first record, and
> > nothing after that.
> >
> > I have tried putting the database(access) in the database folder, and
> > straight in the directory with all the pages and I still get the same
> > result, I have replaced the database, and contacted my host, and they
say
> > that the code is fine from what little the guy knew about CF.
> >
> > Below is the code if someone could share there knowledge I would as
always
> > appreciate it.
> >
> > And thank you
> >
> >
> > 
> >
> > 
> > 
> > 
> >
> >  > dbtype="ODBC">
> > SELECT  ID, EmpCandidate, SKillBackground, Status, Recruiter,
Profile
> > FROMinterview
> > WHERE ID=#ID#
> > 
> >
> > 
> > 
> >
> > Interview Candidates
> > 
> >
> > 
> > 
> > 
> >
> > 
> > 
> > 
> >  ID
> >  #id#
> > 
> > 
> >  Candidate Name
> >  #EmpCandidate#
> > 
> > 
> >  Skill Background
> >  #SKillBackground#
> > 
> > 
> >  Status
> >  #Status#
> > 
> > 
> >  Recruiter
> >  #Recruiter#
> > 
> > 
> >  Profile
> >  #profile#
> > 
> > 
> > 
> > 
> > 
> > Previous
> > Next
> > 
> > 
> >
> >
> >
> >
>
~~
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: Code review PLEASE


Are you trying to have the user page through one record at a time? Cause
that's what you're going to get with this. You'll only ever get one user
whose id equals the passed id
---snip---> WHERE ID=#ID#

What I think you want is something like the following (quickly cut from
existing code, so probably needs cleanup).






SELECT  ID, EmpCandidate, SKillBackground, Status, Recruiter, Profile
FROMinterview





Table o' info here














 







 






Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923




~~
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: Insert Into Query Bombing Out - What Am I Not Seeing?

2001-03-15 Thread Chris Montgomery




> -Original Message-
> From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 15, 2001 12:57 PM
> To: CF-Talk
> Subject: RE: Insert Into Query Bombing Out - What Am I Not Seeing?
>

>
> 1, read Ben Forta's "To # or not to #"
I have. The # marks need to be around Form.GroupList else the value of
ListID comes out as "Form.GroupList" in the insert query.

> 2, why are you naming the queries? There's no return, so no reason to name

Actually, what I sent before was the last iteration of my attempts (heck, I
was trying everything I could think of :). Here's a simplified form:


  
  insert into Messages (ListID, From, Subject, MsgBody)
  values(#i#, '#form.from#', '#form.subject#', '#form.msgbody#')
  


It still bombs out.

> 3, is ListID an AutoNumber? If so, you can't insert into it

No, see my previous reply.

> 4, if "i" is a value, why are you using Val(i) - it'll slow the server up
> some

Not worried about that right now. I have tried it without Val around the
"i". No difference.

> 5, ensure that your fields don't have apostrophies in them by using
> Replace(form.field,"'","''","all") - SQL will spit otherwise

They don't have apostrophies.

Still scratching my head. Thanks.

Chris


~~
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: Code review PLEASE


Your the second one to say that, but locally everything works fine,  if I
turn the max rows off then I will see all the records and I only want to see
one record at time


Michael



"Cami Lawson" <[EMAIL PROTECTED]> wrote in message
010001c0ad87$6836dcb0$[EMAIL PROTECTED]">news:010001c0ad87$6836dcb0$[EMAIL PROTECTED]...
> You have a maxrows = 1 on the query.
>
> $.02
> - Original Message -
> From: "Mike" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, March 15, 2001 12:59 PM
> Subject: Code review PLEASE
>
>
> > This is really making me go bald,  I have a page that has next and
> previous,
> > and when viewed locally I can see everything, when I ftp to my host (and
> yes
> > the odbc is working and correct) I can only see the first record, and
> > nothing after that.
> >
> > I have tried putting the database(access) in the database folder, and
> > straight in the directory with all the pages and I still get the same
> > result, I have replaced the database, and contacted my host, and they
say
> > that the code is fine from what little the guy knew about CF.
> >
> > Below is the code if someone could share there knowledge I would as
always
> > appreciate it.
> >
> > And thank you
> >
> >
> > 
> >
> > 
> > 
> > 
> >
> >  > dbtype="ODBC">
> > SELECT  ID, EmpCandidate, SKillBackground, Status, Recruiter,
Profile
> > FROMinterview
> > WHERE ID=#ID#
> > 
> >
> > 
> > 
> >
> > Interview Candidates
> > 
> >
> > 
> > 
> > 
> >
> > 
> > 
> > 
> >  ID
> >  #id#
> > 
> > 
> >  Candidate Name
> >  #EmpCandidate#
> > 
> > 
> >  Skill Background
> >  #SKillBackground#
> > 
> > 
> >  Status
> >  #Status#
> > 
> > 
> >  Recruiter
> >  #Recruiter#
> > 
> > 
> >  Profile
> >  #profile#
> > 
> > 
> > 
> > 
> > 
> > Previous
> > Next
> > 
> > 
> >
> >
> >
> >
>
~~
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

XML Anyone?

2001-03-15 Thread kmansel


Surely all of you smart people can direct me to some awesome resources on CF
with XML or vice versa

Thanks a bunch

kev

~
Kevin Mansel
Web Developer
Fox Communications
[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

Regular expression help

2001-03-15 Thread Jeff Britts


Help for a regular expression idiot.
 
I'm looking to remove all the characters between two tags:
 
example 
from:  asldfj lskdf jaskldf jklasdf jlaskdfj lasdkf 
 
to: 
 
 
(removing the tags themselves would be a plus)
 
 
 


~~
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: Philips Edit Form


> 1. give an example of usage in the docs

Yeah, yeah, I know, I know

> 2. On my system, the variable for the filename to submit to is pulling the
> local file system, as opposed to the web address. I haven't dug
> through the code at all to see if this something in your code, or if
> it's an oddity with our development server.

It pulls the template path using ListLast(CGI.CF_TEMPLATE_PATH,"\"), and it
posts back to that - theoretically it can't do anything else...

Can you View Source for me - all of my testing went fine for this...

Another update by early next week, promise...

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: Code review PLEASE

2001-03-15 Thread Sicular, Alexander


change mawrows = 1 to something else, like user definable.

Alexander Sicular
Technical Director, Information Technology
The Neurological Institute of New York
Columbia University
212.305.1318
[EMAIL PROTECTED]


> -Original Message-
> From: Mike [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 15, 2001 2:00 PM
> To: CF-Talk
> Subject: Code review PLEASE
> 
> 
> This is really making me go bald,  I have a page that has 
> next and previous,
> and when viewed locally I can see everything, when I ftp to 
> my host (and yes
> the odbc is working and correct) I can only see the first record, and
> nothing after that.
> 
> I have tried putting the database(access) in the database folder, and
> straight in the directory with all the pages and I still get the same
> result, I have replaced the database, and contacted my host, 
> and they say
> that the code is fine from what little the guy knew about CF.
> 
> Below is the code if someone could share there knowledge I 
> would as always
> appreciate it.
> 
> And thank you
> 
> 
> 
> 
> 
> 
> 
> 
>  dbtype="ODBC">
> SELECT  ID, EmpCandidate, SKillBackground, Status, 
> Recruiter, Profile
> FROMinterview
> WHERE ID=#ID#
> 
> 
> 
> 
> 
> Interview Candidates
> 
> 
> 
> 
> 
> 
> 
> 
> 
>  ID
>  #id#
> 
> 
>  Candidate Name
>  #EmpCandidate#
> 
> 
>  Skill Background
>  #SKillBackground#
> 
> 
>  Status
>  #Status#
> 
> 
>  Recruiter
>  #Recruiter#
> 
> 
>  Profile
>   name="Profile">#profile#
> 
> 
> 
> 
> 
> Previous
> Next
> 
> 
> 
> 
> 
>
~~
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: Insert Into Query Bombing Out - What Am I Not Seeing?

2001-03-15 Thread Douglas Malcolm


>>1, read Ben Forta's "To # or not to #"

Where is that located?  Thanks,

djm


-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 10:57 AM
To: CF-Talk
Subject: RE: Insert Into Query Bombing Out - What Am I Not Seeing?


> This should be an easy one and I'm a bit embarassed to ask about
> it, but I'm not seeing something.
>
> I want to loop over a list of numbers and do a query Insert Into for each
> item in the list. This is what I have:
>
> (Form.GroupList is a list of numbers, e.g., 5,7,6,3,8,2,1,4)
>
> 
> 
>   
>   
> insert into Messages (ListID, From, Subject, MsgBody)
> values(#Val(i)#, '#form.from#', '#form.subject#', '#form.msgbody#')
>   
> 
>
> (the form.from, form.subject, and form.msgbody fields will be the same for
> each insertion)

1, read Ben Forta's "To # or not to #"
2, why are you naming the queries? There's no return, so no reason to name
3, is ListID an AutoNumber? If so, you can't insert into it
4, if "i" is a value, why are you using Val(i) - it'll slow the server up
some
5, ensure that your fields don't have apostrophies in them by using
Replace(form.field,"'","''","all") - SQL will spit otherwise


> I'm getting a syntax error:
>
> Diagnostic error message: ODBC Error Code = 37000 (Syntax error or access
> violation)
>
> [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
> statement.
>
> SQL = "insert into Messages (ListID, From, Subject, MsgBody)
> values(5, 'Joe Blow', 'Test', 'enter email message here this is a test')"
>
> Using MS Access to do this. What am I not seeing?

Access is nice with it's error messages - they're vague as hell!

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: Code review PLEASE

2001-03-15 Thread Cami Lawson


You have a maxrows = 1 on the query.

$.02
- Original Message -
From: "Mike" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 12:59 PM
Subject: Code review PLEASE


> This is really making me go bald,  I have a page that has next and
previous,
> and when viewed locally I can see everything, when I ftp to my host (and
yes
> the odbc is working and correct) I can only see the first record, and
> nothing after that.
>
> I have tried putting the database(access) in the database folder, and
> straight in the directory with all the pages and I still get the same
> result, I have replaced the database, and contacted my host, and they say
> that the code is fine from what little the guy knew about CF.
>
> Below is the code if someone could share there knowledge I would as always
> appreciate it.
>
> And thank you
>
>
> 
>
> 
> 
> 
>
>  dbtype="ODBC">
> SELECT  ID, EmpCandidate, SKillBackground, Status, Recruiter, Profile
> FROMinterview
> WHERE ID=#ID#
> 
>
> 
> 
>
> Interview Candidates
> 
>
> 
> 
> 
>
> 
> 
> 
>  ID
>  #id#
> 
> 
>  Candidate Name
>  #EmpCandidate#
> 
> 
>  Skill Background
>  #SKillBackground#
> 
> 
>  Status
>  #Status#
> 
> 
>  Recruiter
>  #Recruiter#
> 
> 
>  Profile
>  #profile#
> 
> 
> 
> 
> 
> Previous
> Next
> 
> 
>
>
>
>
~~
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

Philips Edit Form


Cool, Philip. I'm going to have to play with this some more, but my only
initial comments would be:

1. give an example of usage in the docs
2. On my system, the variable for the filename to submit to is pulling the
local file system, as opposed to the web address. I haven't dug through the
code at all to see if this something in your code, or if it's an oddity with
our development server.

-d




Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923




~~
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: Insert Into Query Bombing Out - What Am I Not Seeing?

2001-03-15 Thread Chris Montgomery


Kevin,

ListID is actually a foreign key, not a primary key. It's defined as a
number type.

Thanks,

Chris

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 15, 2001 12:52 PM
> To: CF-Talk
> Subject: RE: Insert Into Query Bombing Out - What Am I Not Seeing?
>
>
> If your ListID is a PrimaryKey field, you will not be able to
> insert a value
> into it.  Make sure this field in Access is an int.
>
> HTH
>
> 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

Code review PLEASE


This is really making me go bald,  I have a page that has next and previous,
and when viewed locally I can see everything, when I ftp to my host (and yes
the odbc is working and correct) I can only see the first record, and
nothing after that.

I have tried putting the database(access) in the database folder, and
straight in the directory with all the pages and I still get the same
result, I have replaced the database, and contacted my host, and they say
that the code is fine from what little the guy knew about CF.

Below is the code if someone could share there knowledge I would as always
appreciate it.

And thank you









SELECT  ID, EmpCandidate, SKillBackground, Status, Recruiter, Profile
FROMinterview
WHERE ID=#ID#





Interview Candidates









 ID
 #id#


 Candidate Name
 #EmpCandidate#


 Skill Background
 #SKillBackground#


 Status
 #Status#


 Recruiter
 #Recruiter#


 Profile
 #profile#





Previous
Next





~~
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 Fields cleared on Back

2001-03-15 Thread Clint Tredway


I am sorry... I probably deleted it without reading the message... :(


--
Clint Tredway
www.factorxsoftware.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

RE: Cold Fusion -> Web site Monitor

2001-03-15 Thread Larry W. Virden


Re: contact the author to see if logging is already there.

I understand - and I've done this.  I thought while I was
waiting for a response I would research whether anyone else had 
cracked the 'log a web ticker' type application.  This is
similar to tracking running stock quotes, changing weather 
conditions, monitoring news headlines, etc.


-- 
Larry W. Virden mailto:[EMAIL PROTECTED]> 
http://www.purl.org/net/lvirden/>
Even if explicitly stated to the contrary, nothing in this 
posting
should be construed as representing my employer's opinions.



~~
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 Fields cleared on Back


> What editor thingy is that Phillip?

I posted the URL a nobody notices  nobody cares 

http://www.aspmedia.co.uk/CF/_EditForm.cfm

It handles the layout, the error checking and all sorts of stuff

It's the first version, so no error catching (yet)

Check my post on 14th March for further info

Further versions soon...

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: Insert Into Query Bombing Out - What Am I Not Seeing?

2001-03-15 Thread kmansel

I mean number  :)

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 10:52 AM
To: CF-Talk
Subject: RE: Insert Into Query Bombing Out - What Am I Not Seeing?

If your ListID is a PrimaryKey field, you will not be able to insert a value
into it.  Make sure this field in Access is an int.

HTH 

kevin

-Original Message-
From: Chris Montgomery [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 10:46 AM
To: CF-Talk
Subject: Insert Into Query Bombing Out - What Am I Not Seeing?

Howdy,

This should be an easy one and I'm a bit embarassed to ask about it, but I'm
not seeing something.

I want to loop over a list of numbers and do a query Insert Into for each
item in the list. This is what I have:

(Form.GroupList is a list of numbers, e.g., 5,7,6,3,8,2,1,4)

insert into Messages (ListID, From, Subject, MsgBody)
values(#Val(i)#, '#form.from#', '#form.subject#', '#form.msgbody#')

(the form.from, form.subject, and form.msgbody fields will be the same for
each insertion)

I'm getting a syntax error:

Diagnostic error message: ODBC Error Code = 37000 (Syntax error or access
violation)

[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.

SQL = "insert into Messages (ListID, From, Subject, MsgBody) values(5, 'Joe
Blow', 'Test', 'enter email message here this is a test')"

Using MS Access to do this. What am I not seeing?

TIA,

Chris Montgomery [EMAIL PROTECTED]

Web Development & Consulting http://www.astutia.com
Allaire Consulting Partner
210-490-3249/888-745-7603Fax 210-490-4692
AIM: astutiaweb; ICQ: 7381282
~~
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: Insert Into Query Bombing Out - What Am I Not Seeing?