RE: Hacking Client Variables?

2003-03-10 Thread Ben Koshy
Depending on how your application works, someone could go CFID/CFTOKEN searching trying to find a still active session and try to hijack that session. I've seen it done by accident. Moving your client variables to a 36bit UUID helps with this and what I've done is created a timeoutvariable just

Re: sql2k vs mySQL vs postgresql (for win2k)

2003-03-10 Thread Jochem van Dieten
dan martin wrote: I am currently using ms access with a growing 20mb database that I need to upgrade. My initial plan was to migrate over to SQL 2000 because that seems to be the most painless (except for price). I am wondering if it would make more sense to migrate to an open source db:

Re: sql2k vs mySQL vs postgresql (for win2k)

2003-03-10 Thread Peter Mayer
Hello! mysql has a very good performance but if you need certain features like views or subselect this database is out of the game. Postgresql fullfills almost all standard criterias for a real database engine but it is a little bit more complex. Running Postgresql on Windows isn't that

Re: sql2k vs mySQL vs postgresql (for win2k)

2003-03-10 Thread Paul Hastings
BTW, one database you didn't mention was Firebird. I hear it is almost as capable as PostgreSQL and it does have a native Windows version. firebird's not quite as standard as postgreSQL (it offers many ANSI SQL-92 features), has some syntax differences from sql server/access. it has some nice

Restrict IP range for machines that use RDS

2003-03-10 Thread Aidan Whitehall
With ColdFusion MX is there a way to restrict the IP range of the machines that are able to use RDS? Under 5.0, I moved ide.cfm from where it was installed to where CF Studio looked for it at cfide/main/ide.cfm and then restricted access to that file in IIS. It looks like the only thing you can

Re: sql2k vs mySQL vs postgresql (for win2k)

2003-03-10 Thread Jochem van Dieten
Peter Mayer wrote: Hello! mysql has a very good performance but if you need certain features like views or subselect this database is out of the game. Postgresql fullfills almost all standard criterias for a real database engine but it is a little bit more complex. Running Postgresql on

RE: Multiple browser/platform screenshots

2003-03-10 Thread Aidan Whitehall
Can anyone remind me of the URL of the web site that lets you see how a web page looks in multiple browser / versions / platforms? For the archives, it looks like http://www.browsercam.com/ will do the job. -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks

error

2003-03-10 Thread Tangorre, Michael
Can anyone help me diagnose this... I am receiving this error from an app that I have hosted. and the server admins and tech support people can not resolve it. access denied (java.io.FilePermission C:\CFusionMX\wwwroot\WEB-INF\cfclasses\cfindex2ecfm1831581047.class read)

flash integrated website creation system

2003-03-10 Thread Uwe Degenhardt
Hi list, we have a website-creation system (based on CF) with which some people can create based on layout templates generate their own websites. This is working pretty nice. No the customer want to integrate Flash (Flash-Intro-Functions) to the websites. Is there a way we can provide a

Re: Restrict IP range for machines that use RDS

2003-03-10 Thread Thomas Chiverton
On Monday 10 Mar 2003 10:34 am, Aidan Whitehall wrote: With ColdFusion MX is there a way to restrict the IP range of the machines that are able to use RDS? This is one reason we proxy the CF requests through Apache, we can just use the normal apache allow/deny directives. -- Tom C Land of

CF Tag Reference PDF

2003-03-10 Thread Randell B Adkins
I found a website awhile back that had a PDF file that showed the CF Function and Tag References. I wanted to have it printed out to place on my wall here in the office. Does anyone recall a website that has that or have the files? Thanks!!

RE: Restrict IP range for machines that use RDS

2003-03-10 Thread Aidan Whitehall
This is one reason we proxy the CF requests through Apache, we can just use the normal apache allow/deny directives. I'm not sure what you mean by proxy the CF requests. Do you have IIS and Apache on the same machine, with Apache being the default web server and handing off all requests for

Re: CF Tag Reference PDF

2003-03-10 Thread Dave Carabetta
- Original Message - From: Randell B Adkins [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 10, 2003 08:09 AM Subject: CF Tag Reference PDF I found a website awhile back that had a PDF file that showed the CF Function and Tag References. I wanted to have it

Re: Restrict IP range for machines that use RDS

2003-03-10 Thread Thomas Chiverton
On Monday 10 Mar 2003 13:17 pm, Aidan Whitehall wrote: I'm not sure what you mean by proxy the CF requests. Do you have IIS We use the weblogic module, and set it as the handler for the '/' location. and Apache on the same machine, with Apache being the default web server and handing off all

Re: CF Tag Reference PDF

2003-03-10 Thread Thomas Chiverton
On Monday 10 Mar 2003 13:34 pm, Dave Carabetta wrote: printed out to place on my wall Well, this is where I think you saw it, but, as you will see, the PDF is pretty out-of-date (unless I missed a newer version somewhere): I got a nice A3 one in the box... -- Tom C Land of the free, home

strip quotes

2003-03-10 Thread Robert Orlini
Hello, I know this is an easy one, but I don't use CF all the time so it escapes me. How do I strip quotes from a string? It appears towards the end; ie: TID=227 Do I use rtrim? Thanks. Robert Orlini HWW ~| Archives:

Re: CF Tag Reference PDF

2003-03-10 Thread Randell B Adkins
If it is in a file format, can you share that with us? Thanks! [EMAIL PROTECTED] 03/10/03 08:57AM On Monday 10 Mar 2003 13:34 pm, Dave Carabetta wrote: printed out to place on my wall Well, this is where I think you saw it, but, as you will see, the PDF is pretty out-of-date (unless I

RE: strip quotes

2003-03-10 Thread John Stanley
you can use the replace function or the right function, probably some others too. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 8:59 AM To: CF-Talk Subject: strip quotes Hello, I know this is an easy one, but I don't use CF all the time

Re: strip quotes

2003-03-10 Thread Todd
replace(string,,,ALL) At 08:59 AM 3/10/2003 -0500, you wrote: Hello, I know this is an easy one, but I don't use CF all the time so it escapes me. How do I strip quotes from a string? It appears towards the end; ie: TID=227 Do I use rtrim? Thanks. Robert Orlini HWW -- Todd

RE: strip quotes

2003-03-10 Thread Charlie Griefer
If you know that the only double-quote will be that last character, you can do: #replace(myString, , , all)# (i think that should work...escaping double quotes inside of double quotes always fries my brain). You can also use a conditional to check to see if the last character is a

Re: CF Tag Reference PDF

2003-03-10 Thread Thomas Chiverton
On Monday 10 Mar 2003 14:08 pm, Randell B Adkins wrote: I got a nice A3 one in the box... If it is in a file format, can you share that with us? I guess it might be on the CD, which I don't have to hand. -- Tom C Land of the free, home of the brave... you have to be brave to live there and

RE: strip quotes

2003-03-10 Thread Raymond Camden
rTrim removes spaces. If you want to remove one char from the end, you can use left. cfset newStr = left(oldStr,len(oldStr)-1) This says, basically, take N characters from the left where N is the length minus one. You could also use a regex to replace a single quote at the end. This code shows

HELP -- CFMX Very High Queued Requests/Hanging

2003-03-10 Thread Brandon Purcell
Jeremy, Drop me an email at [EMAIL PROTECTED] What is the URL of the forums posting? Have you taken a thread dump when the server hangs? Are there any errors in /runtime/logs? Thanks Brandon Purcell Sr Product Support Engineer Macromedia [EMAIL PROTECTED]

strip quotes

2003-03-10 Thread Robert Orlini
Thanks all for the speedy assistance! Robert Orlini HWW ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ:

RE: Restrict IP range for machines that use RDS

2003-03-10 Thread Aidan Whitehall
We don't use IIS. I guess in your set-up (assuming IIS can't do proxying) you could run your CF server (use the JRun it ships with ?), on port X, and install apache on port 80, proxying all request with mod_proxy or something to port X. OK. Well, for what I'm after, disabling RDS and using

RE: CF Tag Reference PDF

2003-03-10 Thread Edwards Robert (air0rae)
There is a slightly newer poster that I found on TeraTech's website -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 8:35 AM To: CF-Talk Subject: Re: CF Tag Reference PDF - Original Message - From: Randell B Adkins [EMAIL

Re: Restrict IP range for machines that use RDS

2003-03-10 Thread Thomas Chiverton
On Monday 10 Mar 2003 14:20 pm, Aidan Whitehall wrote: disabling RDS and using A N Other method Best practice is to do this for live sites anyway. -- Tom C Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms

RE: flash integrated website creation system

2003-03-10 Thread Mike Brunt
Uwe, this is not exactly a direct answer but have you looked at how Fusebox 3.0 is used regarding the layouts schema and how that might help in your case? Kind Regards - Mike Brunt Webapper Services LLC Web Site http://www.webapper.com Blog http://www.webapper.net Webapper Web Application

RE: CF Tag Reference PDF

2003-03-10 Thread Edwards Robert (air0rae)
Dangit. Outlook closed on me before I could paste in the link. http://www.cfconf.com/cfun2k/tagposter.pdf It's dated 2000, so it probably is not much newer then 4.5 -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 8:35 AM To: CF-Talk

RE: CF Tag Reference PDF

2003-03-10 Thread David Collie (itndac)
where? -Original Message- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED] Sent: 10 March 2003 14:39 To: CF-Talk Subject: RE: CF Tag Reference PDF There is a slightly newer poster that I found on TeraTech's website -Original Message- From: Dave Carabetta [mailto:[EMAIL

Re: CF Tag Reference PDF

2003-03-10 Thread Christian Cantrell
I don't know how these would look printed out, but you might give them a try: http://download.macromedia.com/pub/coldfusion/documentation/ cfmx_cfml_reference.pdf http://download.macromedia.com/pub/coldfusion/documentation/ cfml_quick_ref.pdf Christian On Monday, March 10, 2003, at 08:09

OT: SQL Error with Syntax

2003-03-10 Thread Paul Giesenhagen
OK, I cannot see where this SYNTAX error is can anyone else see the possible problem? Below are two queries, both are the same, one is PRE-CF (variables) one is POST CF after CF processes the variables that makes it a query. (WHERE weight = apos;30apos;) Is just what is outputted in the

Re: OT: SQL Error with Syntax

2003-03-10 Thread Randell B Adkins
If the weight field is number then it should be weight = 30 and not weight = '30' [EMAIL PROTECTED] 03/10/03 09:58AM OK, I cannot see where this SYNTAX error is can anyone else see the possible problem? Below are two queries, both are the same, one is PRE-CF (variables) one is POST CF after

SOT: QA / Testing - Use Case Scenarios?

2003-03-10 Thread Chris Alvarado
Hello all, Hoping to get some opinions etc here. I am trying to rationalize to the powers that be that some form of Use Case Scenarios would greatly improves quality of work. Does anyone out there have any good examples / definitions of solid testing plans / use case scenarios? I realize that

RE: window.close question?

2003-03-10 Thread Matthew Small
I used to think that the situation you want to happen was impossible until I found this link: http://aspalliance.com/peterbrunone/impossible.asp Matt Small -Original Message- From: Jann VanOver [mailto:[EMAIL PROTECTED] Sent: Sunday, March 09, 2003 1:09 PM To: CF-Talk Subject: Re:

Re: SQL Error with Syntax

2003-03-10 Thread Justin Scott
I'm not sure if SQL Server has issues with having an integer as the first character of a table name, but I suspect that is where the problem is. It's generally a good idea to not start any variable, table or column names with an integer, lest you run into weird issues. I would try wrapping the

RE: flash integrated website creation system

2003-03-10 Thread Kevin Graeme
Uwe, look into the XML source capabilities of Flash. If you're just looking for something like a standard image with some dynamically defined text over it, that is quite possible. Have the text module in Flash look for some variable text passed to it from an outside source like XML. -Kevin

Re: OT: SQL Error with Syntax

2003-03-10 Thread Justin Scott
Quoting integers in SQL Server is valid, and can help protect against some hack attempts. -Justin Scott - Original Message - From: Randell B Adkins [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 10, 2003 10:00 AM Subject: Re: OT: SQL Error with Syntax If the

Foxpro databases: does CF use indexes?

2003-03-10 Thread Ed Gordon
Management here has seen time-to-production decimated since I introduced Cold Fusion. Yet, doubt remains about it's efficiency reading the legacy Foxpro databases. If I have CF read some Foxpro database files (.dbf), will it use the database index files (.cdx) automatically? How could I tell?

OT: Broken Actionscript Dictionary Links

2003-03-10 Thread Joshua Miller
Macromedians, The ActionScript dictionary online is really screwed-up in places. For example: http://www.macromedia.com/support/flash/action_scripts/actionscript_dict ionary/actionscript_dictionary241.html Click on the setSelectedIndex() function for more information, it takes you to the POP()

RE: Broken Actionscript Dictionary Links

2003-03-10 Thread Debbie Dickerson
Thanks. I've passed along the info to the appropriate person. Deb -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 10:30 AM To: CF-Talk Subject: OT: Broken Actionscript Dictionary Links Macromedians, The ActionScript dictionary online is

Re: Foxpro databases: does CF use indexes?

2003-03-10 Thread Jochem van Dieten
Ed Gordon wrote: Management here has seen time-to-production decimated since I introduced Cold Fusion. Yet, doubt remains about it's efficiency reading the legacy Foxpro databases. If I have CF read some Foxpro database files (.dbf), will it use the database index files (.cdx)

RE: Subject: MM will OWN my Devex Submissions?

2003-03-10 Thread Kevin Graeme
I think you're right to be concerned. I remember when Apple did this with their online iDisk accounts and Yahoo with their Geocities accounts. In all these cases we can guess that the intent is that they just need to have the right to copy and redistribute the material which is the purpose of the

RE: Subject: MM will OWN my Devex Submissions?

2003-03-10 Thread Todd
Shouldn't this stuff be posted on macromedia 'list' at houseoffusion.com? I believe that's why that list exists...? This isn't code related (distribution of code, yes, code related, no). Just curious, ~Todd At 09:52 AM 3/10/2003 -0600, you wrote: I think you're right to be concerned. I

RE: address validation software/systems

2003-03-10 Thread Dan O'Keefe
Way back when, I integrated one for superletter.com with a company by the name of First Logic. It worked using a COM object, which takes your input and send an XML packet, which you receive back. Worked pretty nicely as I remember, and was fairly easy to integrate.

CFMX Linux JDBCPool Timeout

2003-03-10 Thread Paul Hassinger
Just wondering if anyone has had this problem. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ:

RE: Subject: MM will OWN my Devex Submissions?

2003-03-10 Thread Kevin Graeme
If people are concerned about it, then it should be discussed everywhere. If they would rather ignore it, then it should be taken to some rarely traveled list that nobody is on. I've said my piece. -Kevin -Original Message- From: Todd [mailto:[EMAIL PROTECTED] Sent: Monday, March 10,

RE: Subject: MM will OWN my Devex Submissions?

2003-03-10 Thread Todd
Right, but putting it on the Macromedia list would actually get this in front of MORE Macromedians and actually request feedback from them. I'm not disagreeing with your statements at all in your previous emails and support you and others in getting this clarified with MM. I don't have

Remove_ALL_connectors.bat?

2003-03-10 Thread Aidan Whitehall
When you run Remove_ALL_connectors.bat, is it working correctly if it removes *all* ISAPI filters in the Master Web Site in IIS and not just the JRun Connector Filter? I'd interpreted the ALL in the filename to mean the JRun Connector filter for all web sites, not all ISAPI filters for all web

RE: Foxpro databases: does CF use indexes?

2003-03-10 Thread Jack Ince
Foxpro is independent of CF. When you submit you cfquery all data gathering is passed off to Foxpro. From there Foxpro will proceed just like it was a Foxpro request, and will use any index it can. I assume that your management has upgraded to Visual FP if they are so concerned about the speed.

RE: Remove_ALL_connectors.bat?

2003-03-10 Thread Dave Watts
When you run Remove_ALL_connectors.bat, is it working correctly if it removes *all* ISAPI filters in the Master Web Site in IIS and not just the JRun Connector Filter? I'd interpreted the ALL in the filename to mean the JRun Connector filter for all web sites, not all ISAPI filters

Extracting Dates From DB

2003-03-10 Thread Double Down, Inc.
I have two date questions that I need some help with. First question: I need to extract a records where the member id and current date match. The date is in the SQL DB as a datetime field. I tried using the date format function in the query but could not get it to work. Second question: I am

RE: Extracting Dates From DB

2003-03-10 Thread Tony Weeg
all kinds of suggestions, why don't you send over some code you are currently trying, and then im sure we can fix 'er right up. ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting

Anyone seen this or know what it means?

2003-03-10 Thread Julian McNamara
A user got this message after completing one of the forms in our application. W2k server/CFMX/SQL Server 200. I did notice they were using a MAC for what it's worth. I pasted the SQL displayed in the error msg directly into the SQL Server and it executed without a problem. Any clues? tia Julian

RE: Subject: MM will OWN my Devex Submissions?

2003-03-10 Thread Matt Robertson
My take on the non-commercial side of the agreement is that MM or anyone else can do what they want with a non-commercial submission. My licensing terms are pretty broad: Use and distribute freely. No warranties express or implied. If I upload freebie code it really is alright with me if

RE: Anyone seen this or know what it means?

2003-03-10 Thread David Collie (itndac)
Have you trimmed all your inputs from browser? Mac maybe adding in that extra CR/LF? -Original Message- From: Julian McNamara [mailto:[EMAIL PROTECTED] Sent: 10 March 2003 17:04 To: CF-Talk Subject: Anyone seen this or know what it means? A user got this message after completing one of

CF Server and MS Exchange

2003-03-10 Thread Luis Lebron
I am having a problem getting the MS Exchange 5.5 server to allow the CF Server to send mail. The only way I have gotten it to work is by setting up Exchange as an open relay which is a serious security problems. The machines are both on the same net. Any ideas? thanks, Luis R. Lebron Project

RE: CF Server and MS Exchange

2003-03-10 Thread Craig Dudley
Just allow the IP of the cf server to relay? -Original Message- From: Luis Lebron [mailto:[EMAIL PROTECTED] Sent: 10 March 2003 17:10 To: CF-Talk Subject: CF Server and MS Exchange I am having a problem getting the MS Exchange 5.5 server to allow the CF Server to send mail. The only

RE: Remove_ALL_connectors.bat?

2003-03-10 Thread Aidan Whitehall
No, that sounds like a bug if it really did that. It should only remove JRun connectors, I think. Yeah, me too, but I wanted to double-check what the intended operation was. Anticipating the uninstallation being less-than-straightforward, I went through every web site, including the Master,

sql2k vs mySQL vs postgresql (for win2k)

2003-03-10 Thread dan martin
Thanks very much for the information. It looks like it is definitely worth more investigation. Both alternatives to sql2k look very promising for my purposes. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4

Re: Loading of allaire.controls2.CFTreeApplet.class fails

2003-03-10 Thread Benjamin Petz [rotorMedien]
I've already Patch the Coldfusion System, thats. Thanks for that tip, Neil. The Problem was, that the permissions of the CFJava2.jar-file arent right! Setting this correct, leads thereto that the CFTree Applet run super-duper ;) Benjamin Petz On Wed, 5 Feb 2003 12:53:12 - Robertson-Ravo,

RE: Restrict IP range for machines that use RDS

2003-03-10 Thread Aidan Whitehall
Best practice is to do this for live sites anyway. Well (and this is déjà vu, having just had this conversation recently on the CF-Developer list), it *is* damned handy for very minor changes (simple text edits, global variable value alterations, etc) and when your offline copy is half-way

RE: CF Server and MS Exchange

2003-03-10 Thread Luis Lebron
Tried that and I can't get it to work. -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 11:17 AM To: CF-Talk Subject: RE: CF Server and MS Exchange Just allow the IP of the cf server to relay? -Original Message- From: Luis Lebron

RE: Remove_ALL_connectors.bat?

2003-03-10 Thread Dave Watts
Anticipating the uninstallation being less-than- straightforward, I went through every web site, including the Master, and made a note of the default documents, script mappings and ISAPI filters in them, so they could be recreated manually if it all went pear shaped. In the future, you

RE: CF Server and MS Exchange

2003-03-10 Thread Craig Dudley
Hmm ok, that's how I've got it working here, but then it's exchange2k. I have no experience with 5.5, sorry. -Original Message- From: Luis Lebron [mailto:[EMAIL PROTECTED] Sent: 10 March 2003 17:23 To: CF-Talk Subject: RE: CF Server and MS Exchange Tried that and I can't get it to

RE: Foxpro databases: does CF use indexes?

2003-03-10 Thread Dan O'Keefe
My memory of using VFP databases with CF was not a good one and seem to remember running into the same issues. I then turned to getting the data into SQL. I realize that may not be an option for you. You might want to check some ASP forums and see if that have any threads on using these databases.

RE: Anyone seen this or know what it means?

2003-03-10 Thread Dave Watts
A user got this message after completing one of the forms in our application. W2k server/CFMX/SQL Server 200. I did notice they were using a MAC for what it's worth. I pasted the SQL displayed in the error msg directly into the SQL Server and it executed without a problem. Any clues?

HELP PLEASE!!!!

2003-03-10 Thread Scott Wilhelm
I keep getting the following error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Invalid bracketing of name '[EMAIL PROTECTED]'. SQL = UPDATE Staff SET LastName = 11, FirstName = 21, Building = West

CFMAIL and us-ascii/utf-8 charsets

2003-03-10 Thread David Grabbe
I've finally got a multipart email working with CFMAIL under CFMX -- with many thanks to Bob Everland and his CF_EmailEveryone tag. However, I've run into a slight problem with character sets. Because of copying/pasting text (from various origins) into a form to build a newsletter,

RE: Restrict IP range for machines that use RDS

2003-03-10 Thread Barney Boisvert
Enter version control. Then it's a snap to get the current production version to make edits to. Or you could just FTP the current version down from production, edit it, and then replace, but that's not nearly as handy. -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]

RE: HELP PLEASE!!!!

2003-03-10 Thread Haggerty, Mike
I don't know the exact fix, but I can tell you a little more about what Access is saying. I have seen this wonderful error before within Access while designing forms. Generally, it only comes up when you have built a form control containing a dot or a bracket in the name, which makes Access

CF5.0 And CFMX date formats

2003-03-10 Thread Deva, Ramesh
Hi , This problems has not yet solved.. really appreciate if u have any ideas.. I have written following code to display date.. cfquery name=getDate datasource=DSN_Test select D_DATE from employee /cfquery cfoutput query=getDate #D_DATE# /cfoutput

changing MX stand alone server root

2003-03-10 Thread Smith, Matthew P -CONT(DYN)
Where do I change the web root for the MX stand alone server? Also, what would be the best solution for be able to point between different roots as needed? This is for a local install, and I often need to change as I work on different sites. Is it possible to use multiple port mappings like

Dreamweaver changing code on me

2003-03-10 Thread Cantrell, Adam
I've been gradually moving to DreamweaverMX as my web IDE... just because. Today I was writing (hand coding) a form in code-view. I saved it to my web server and tried running it - didn't work correctly. Looked at the HTML source... WTF - what's all this garbage in here? I opened the file up in

RE: HELP PLEASE!!!!

2003-03-10 Thread Michael Kear
IF you're using SQLServer, it's very finicky about double and single quotes. Double quotes in your values means for SQL to set the values equal to the column name .. e.g. set the column LastName equal to the column 11. But of course you don't have a column called 11. However single quotes tell

RE: HELP PLEASE!!!!

2003-03-10 Thread Matthew Small
You've got to replace your double quotes with single quotes around the text values, otherwise SQL thinks you're trying to update a column. Old: SET LastName = #form.lname#, New: SET LastName = '#form.lname#', Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings

RE: HELP PLEASE!!!! - SOLVED

2003-03-10 Thread Scott Wilhelm
Thanks everyone for the help! Scott -Original Message- From: Michael Kear [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 1:32 PM To: CF-Talk Subject: RE: HELP PLEASE IF you're using SQLServer, it's very finicky about double and single quotes. Double quotes in your

Re: HELP PLEASE!!!!

2003-03-10 Thread Justin Scott
Perhaps try using single quotes instead of double quotes around the values. -Justin Scott - Original Message - From: Scott Wilhelm [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 10, 2003 1:08 PM Subject: HELP PLEASE I keep getting the following error:

RE: changing MX stand alone server root

2003-03-10 Thread Dave Watts
Where do I change the web root for the MX stand alone server? All configuration options for it are here: http://www.macromedia.com/support/coldfusion/adv_development/config_builtin_ webserver/ Also, what would be the best solution for be able to point between different roots as needed? This

Changing from HTTPS to HTTP for normal pages

2003-03-10 Thread Issac Rosa
What's the best way to setup the page links so that when you go to a secure page via https and then go to a non-secure page the links use http? Do I need to hard code the full url? Thanks, Issac ~| Archives:

changing MX stand alone server root

2003-03-10 Thread Matthew Smith
Thanks Dave! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This

RE: Dreamweaver changing code on me

2003-03-10 Thread Cantrell, Adam
I was experiencing a known bug in the original version of DreamweaverMX. I installed the latest updater - so-far-so-good. My buttons in the toolbars are still all grayed out. Any idea on that one? Adam. -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED] Sent:

Inserting date/time stamp

2003-03-10 Thread FlashGuy
Hi, I have a form that I want to insert the date and time when the form is opened. This will also be saved to a database when saved. Whats the best way of also creating a automatic reference no which increments when a new form is opened? Any ideas...

RE: Inserting date/time stamp

2003-03-10 Thread Raymond Camden
Do you want to know the time when the form was 'opened' (viewed you mean) or actually saved? For example, I may hit your form at 12:01 PM, and it may take me 5 minutes to fill it out. So would you want 12:01 PM stored, or 12:06 PM, the time when the form was actually submitted? If you want the

RE: Inserting date/time stamp

2003-03-10 Thread Ben Doom
You could always use an application variable. I'm not sure what that has to do with a date/time object. Just out of curiosity, if this is going to a database, can't you just create a unique self-incrementing field and use that? -- Ben Doom Programmer General Lackey Moonbow Software,

CF 5 location of undelivered mail folder

2003-03-10 Thread Boardwine, David L.
Hello All, Is there a way to change the location of the undelivered mail folder in CF 5? I'd really to place it on another drive (instead of the boot drive of my webserver). TIA, David L. Boardwine Senior Analyst Ohio Department of Development/ITO Phone (614) 752-4431 [EMAIL PROTECTED]

Re: Changing from HTTPS to HTTP for normal pages

2003-03-10 Thread Jim McAtee
- Original Message - From: Issac Rosa [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 10, 2003 11:59 AM Subject: Changing from HTTPS to HTTP for normal pages What's the best way to setup the page links so that when you go to a secure page via https and then go to a

RE: Inserting date/time stamp

2003-03-10 Thread FlashGuy
On Mon, 10 Mar 2003 13:19:13 -0600, Raymond Camden wrote: Do you want to know the time when the form was 'opened' (viewed you mean) or actually saved? I want the date and time the form was opened/created. For example, I may hit your form at 12:01 PM, and it may take me 5 minutes to fill it

MX Error

2003-03-10 Thread Bruce Sorge
I am receiving this error on a CFMX site. You have attempted to dereference a scalar variable of type class java.lang.String as a structure with members The section of code that it does not like is this piece that is wrapped inside a cfscript tag: if (UserType.RecordCount NEQ 0) {

Re: Inserting date/time stamp

2003-03-10 Thread Scott Weikert
Why not just have a date/time field in your DB that gets autofilled with the server time when you add the form data record when the user submits the form? At 02:13 PM 3/10/2003 -0500, you wrote: Hi, I have a form that I want to insert the date and time when the form is opened. This will also

RE: Inserting date/time stamp

2003-03-10 Thread FlashGuy
HmmmI also want the date and time displayed on my form. I did a cfoutput#now()#/cfoutput but I don't like the results. I want something like: Monday, March 10, 2003 at 2:26pm On Mon, 10 Mar 2003 13:19:13 -0600, Raymond Camden wrote: Do you want to know the time when the form was

Special Characters driving me nuts

2003-03-10 Thread Joshua Miller
Greetings, I've been fighting with user-input and special characters for days now, I'm starting to get really frustrated. Here's the scenario: 1. User enters data into a textarea field. This will usually contain several special characters (?/{}[]|\[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]*,

RE: Inserting date/time stamp

2003-03-10 Thread FlashGuy
On Mon, 10 Mar 2003 14:23:36 -0500, Ben Doom wrote: You could always use an application variable. I'm not sure what that has to do with a date/time object. Just out of curiosity, if this is going to a database, can't you just create a unique self-incrementing field and use that? How?

Sort XML without XSLT?

2003-03-10 Thread Michael J. Sammut
I am successfully displaying data on the web site, however, in some cases I can not use XSLT because of some formatting limitations (actually client peculiarities). My page looks like this so far: table cellspacing=0 cellpadding=0 width=100% cfloop index=i from=1 to=#getcontent.recordcount#

RE: Inserting date/time stamp

2003-03-10 Thread Douglas.Knudsen
see inline -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 2:27 PM To: CF-Talk Subject: RE: Inserting date/time stamp HmmmI also want the date and time displayed on my form. I did a cfoutput#now()#/cfoutput but I don't like the results.

RE: Inserting date/time stamp

2003-03-10 Thread Todd
Check your DateFormat() and TimeFormat() functions. It's there, check the help files. ~Todd At 02:26 PM 3/10/2003 -0500, you wrote: HmmmI also want the date and time displayed on my form. I did a cfoutput#now()#/cfoutput but I don't like the results. I want something like: Monday, March

RE: Inserting date/time stamp

2003-03-10 Thread Everett, Al
You need to format it. #DayOfWeekAsString(Now())#, #DateFormat(Now(), d, )# at #TimeFormat(Now(),h:mmtt)# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 2:27 PM To: CF-Talk Subject: RE: Inserting date/time stamp HmmmI also

RE: Inserting date/time stamp

2003-03-10 Thread Ben Doom
dateformat() and timeformat() should take care of display issues nicely for you. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: FlashGuy [mailto:[EMAIL PROTECTED] : Sent: Monday, March 10, 2003 2:27 PM : To: CF-Talk : Subject: RE:

Re: MX Error

2003-03-10 Thread Matthew Walker
Isn't usertype the name of your query record set? Here you are setting request.usertype equal to your entire record set (or you would be if you went without the quotes and hashes. Request.UserType = #UserType#; Perhaps you want... Request.UserType = UserType.usertype[1]; Matthew Walker

RE: Special Characters driving me nuts

2003-03-10 Thread Douglas.Knudsen
common PITA... I usually do a Replace(stringname, '', quot;) and a Replace(string, ', rsquo) assuming the and ' are stored in the DB as and ' respectively. Note for dumping data like this into JavaScript, escape them. Doug -Original Message- From: Joshua Miller [mailto:[EMAIL

  1   2   3   >