Re: Host provider needed

2001-07-10 Thread Paris Lundis
does he need the shopping solution as well as the hosting? I have a complete store I worked on for most of last year that has been running flawlessly :) -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message-

Host provider needed

2001-07-10 Thread Bryan LaPlante
I have a friend that is looking for a Cold Fusion host that supports a web based shopping cart client so that he does not need to know programming to sell his products. Any body have suggestions. Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development ~~~

RE: Missing Native Driver Page in CF Server 5.0

2001-07-10 Thread JAIME HOI
I had confirmed my CF 5.0 is the Enterprise Edition. Have anyone else installed CF 5.0 already? Did you see your Native Drivers Page under the Data Source option? -Original Message- From: Marius Milosav [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 11, 2001 11:29 AM To: CF-Talk Sub

Printing & CFEXECUTE

2001-07-10 Thread Steve Reich
What's the command line parameter and flag to print a document? Can I choose the printer or is default all I get? I want to use it with CFEXECUTE to print to the web server's printer on our Intranet. Thanks, Steve ~~ Structure your ColdFusion cod

Re: OT - Allaire website

2001-07-10 Thread Steve Reich
> Is anyone else getting *very* slow searches on the Dev-Exchange site? Allaire's ColdFusion is slightly slower than Macromedia's ColdFusion. Positioning your tongue on the right side of your mouth while clicking the form buttons will help some, but keeping your Dev Exchange searches limited to t

RE: Missing Native Driver Page in CF Server 5.0

2001-07-10 Thread JAIME HOI
oh is it ? I dun remember installing the Professional edition because previously for CF 4.0 & 4.5 i have been using the Enterprise Edition. But i will check it out today again. Thanks! -Original Message- From: Marius Milosav [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 11, 2001 11:29

Re: Missing Native Driver Page in CF Server 5.0

2001-07-10 Thread Marius Milosav
Native drivers are available only on the Enterprise Edition. Probably you have the Professional one. Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "JAIME HOI" <[EM

Missing Native Driver Page in CF Server 5.0

2001-07-10 Thread JAIME HOI
hi i can't seem to find this Native Driver Page under Data Source setting in my CF Server 5.0. Any one out there tried this already? Victory is in the mind of those who believe and who believe the longest ~~ Structure your ColdFusion

CF2001 just 2 weeks away

2001-07-10 Thread Michael Smith
ColdFusion Event - CF2001 -- Will you be ahead in ColdFusion this year? You can get ahead in YOUR ColdFusion skills with CF2001 - The Third Annual TeraTech ColdFusion Conference with MDCFUG and CPCUG! Saturday 7/28/01 and Sunday 7/29/01. NIH, Be

RE: Print without bringing print dialogue?

2001-07-10 Thread Stephen Kellogg
Here's my .02cents worth. I will point out that (at least in IE 5.5 not sure about NS or lower versions of IE) you can print directly to someone's printer when a page loads, without popping up a dialog box and without them having to click on anything. I have been doing this now for sometime intern

SOT: Macromedia release SiteSpring beta

2001-07-10 Thread Peter Tilbrook
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Macromedia have released the first beta of their news product, SiteSpring. See attp://www.macromedia.com/products/sitespring/ :) Peter Tilbrook Chief Web Developer Lunar Power Internet Technologies Unit 1, 26-28 Winchcombe Court Mitchell, ACT, 2911

Re: Form builder software

2001-07-10 Thread Stephen M Aylor
scan into Omniform 4.0 Edit/tweak the OCR results will automatically recognize "MOST" paperform "fields" and assigna generic name. from OmniForm - File save as PDF Open the pdf form in full version of Adobe acrobat and edit form fields names/formatting This is now your online form/template.

Re: Mailings that appear to be from humans?

2001-07-10 Thread Yvette Ingram
Jeff: You can use this: to="Human<[EMAIL PROTECTED]>" Yvette Ingram Brainbench Certified ColdFusion 4.5 Programmer Email: [EMAIL PROTECTED] or [EMAIL PROTECTED] ICQ: 21200397 Website: http://www.tkisolutions.com - Original Message - From: "Jeff Green" <[EMAIL PROTECTED]> To: "CF-Ta

RE: Mailings that appear to be from humans?

2001-07-10 Thread Lee Fuller
Create the "From" as "John Doe <[EMAIL PROTECTED]>". That will handle it for you. Lee Fuller Chief Technical Officer PrimeDNA Corporation / AAA Web Hosting Corporation "We ARE the net." http://www.aaawebhosting.com > -Original Message- > From: Jeff Green [mailto:[EMAIL PROTECTED]]

Mailings that appear to be from humans?

2001-07-10 Thread Jeff Green
Hi all, I want to send mail with cfmail but when receiving the mail I want it to appear as if its from a human name opposed to an email address. Example: From: John Doe Opposed to From: [EMAIL PROTECTED] Anyone have any ideas on how to do this? btw I understand that the mail still must come

RE: Client Variables NOT going away though I try

2001-07-10 Thread Dylan Bromby
have you tried the DeleteClientVariable() function? -Original Message- From: Stephen R. Cassady [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 2:59 PM To: CF-Talk Subject: Client Variables NOT going away though I try I'm having the darnedest time trying to delete client files

Re: How do I list query results in a random order fashion??

2001-07-10 Thread Kevin Miller
Try this: 1. Pull back the query unsorted. 2. Create a while-do loop that picks a random record from the query 3. Display the record 4. Delete the record from the record set 5. Go back to step 2. Kevin >>> [EMAIL PROTECTED] 07/10/01 03:44PM >>> Dear Cf'ers: I have the below query that gets co

RE: How do I list query results in a random order fashion??

2001-07-10 Thread Bruce, Rodney
Don't know if its the easiest or best, but one way is place your query output into an array say qarray Use RandRange() to generate random numbers use CFloop to loop through array Simple code: mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 3:45 PM To: CF-Talk Subject: How do I list quer

How do I list query results in a random order fashion??

2001-07-10 Thread Tom Forbes
Dear Cf'ers: I have the below query that gets companies alphabetically (stupid, eh?) - the problem is, the companies don't like it because, being ordered by company name, it gives preference to those that begin with the first letters of the alphabet. Can anyone think of a way to order this lis

RE: URL Hacks - Solution

2001-07-10 Thread Lee Fuller
Josh, Do keep us all posted as to the outcome of all this. There are those of us who will, no doubt, want to jump right on any solutions you find. If you need a list to keep up with this, let me know and I'll create a temporary (or permanent if needed) list to accommodate. Take care... Lee Fu

Re: dbtype=dynamic

2001-07-10 Thread tom muck
I think Dave is right -- it only seems to work with ODBC connection strings, not OLEDB. tom "Deb Dickerson" <[EMAIL PROTECTED]> wrote in message 013401c10987$6b458e40$[EMAIL PROTECTED]">news:013401c10987$6b458e40$[EMAIL PROTECTED]... > You might be able to find something in this Microsoft artic

Client Variables NOT going away though I try

2001-07-10 Thread Stephen R. Cassady
I'm having the darnedest time trying to delete client files on browser close or after a period of time. I'm even trying to follow Hal Helms great "Tracking State Management with Cold Fusion" to run this correctly. Even running the code below - the CFID and CFTOKEN are exactly the same, and are un

RE: Debug output

2001-07-10 Thread Mike Kear
-Original Message- From: Justin [mailto:[EMAIL PROTECTED]] Subject: RE: Debug output Try putting after your at the end of your pages. Better yet, you could put it in onrequestend.cfm, then you wouldn't have to modify all your pages. Justin Hansen - [EMAIL PROTECTED] Web Application D

CF Studio Preference File

2001-07-10 Thread Bruce Holm
Does anyone know where the CF Studio preference file is located? I'm guessing that maybe it needs to be thrown away and recreated. I'm specifically looking for the one the contains Options>Settings... for RDS or file transfers. Bruce - Original Message - From: "Bruce Holm" <[EMAIL PROTEC

RE: URL Hacks - Solution

2001-07-10 Thread Josh R
>From: "Paris Lundis" <[EMAIL PROTECTED]> >Subject: RE: URL Hacks - Solution >I think the script is a good first attempt and seems to address the URL >hack threads previously that have gone around. Thank you. My feelings exactly. As usual, Dave Watts was right when he said this script doesn't c

What are YOUR settings? (CF Security)

2001-07-10 Thread Lee Fuller
I'm not sure anyone wants the whole world to know what their CF servers are set to allow/disallow when it comes to tags. But I'm very interested in knowing the suggestions/feelings/examples of others when it comes to the tags that they allow on their servers. Specifically, ISPs/WHPs are my inter

Re: dbtype=dynamic

2001-07-10 Thread Deb Dickerson
You might be able to find something in this Microsoft article that might help. http://support.microsoft.com/support/kb/articles/q193/3/32.asp Debbie - Original Message - From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 5:07 PM Subject:

RE: Text Field Size Limits?

2001-07-10 Thread Bruce, Rodney
Don't know why yours is truncating, I also use Access Memo fields and have some that are over 3,000 chars. I also use to enter/edit these fields. Sorry no help, just info -Original Message- From: ehoma [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 2:20 PM To: CF-Talk Subjec

RE: Accessing outlook/exchange folders?

2001-07-10 Thread Kelly Matthews
It's possible takes a bit of programming though... I have a site that pulls all .msg files via cold fusion throws them in a verity collection, then sucks some additional information into a SQL database. Completely different from what you are trying to do but thought I would mention it http://www

RE: HTML Question with Netscape 4 and 6

2001-07-10 Thread Kelly Matthews
yep netscape doesn't forgive forgetting /td tags... geeezzz -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 3:17 PM To: CF-Talk Subject: OT: HTML Question with Netscape 4 and 6 Can someone please tell me why these pages completely mes

RE: HTML Question with Netscape 4 and 6

2001-07-10 Thread Christian L. Watt
After your inner table end tag, put an ending row tag also, just a /td CW -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 3:29 PM To: CF-Talk Subject: RE: HTML Question with Netscape 4 and 6 and once again, i think we need to do something a

RE: Form builder software

2001-07-10 Thread Christian L. Watt
I would just use adobe acrobat. Will do everything you want... CW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 2:10 PM To: CF-Talk Subject: SOT: Form builder software Hi all, I need to find a better solution than html forms to mee

Text Field Size Limits?

2001-07-10 Thread ehoma
Hi, I'm wondering about size limitations on text fields and/or memo fields. We are using Access to create our table and I was using a text field that I believe limited me to about 255 characters. The boss wanted more so I changed it to a memo field but it seem that the data is still truncating

RE: Column names containing a # sign

2001-07-10 Thread Christian L. Watt
Try tripleing your # signs. I know this sounds crazy, but had a similar instance and table_Name### worked like a charm. CW -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 12:50 PM To: CF-Talk Subject: Re: Column names containing a # sign

Accessing outlook/exchange folders?

2001-07-10 Thread Wayne Putterill
A client has asked if CF can access public folders in Outlook, word and excel documents are held in these folders and they would like them to be available on a private website. I have little experience of Outlook and Exchange so I am stumped on this, I was wondering if anyone had done it before -

RE: dbtype=dynamic

2001-07-10 Thread Dave Watts
> Has anyone tried to connect to a database thru the new > connection string method? I've successfully connected with > ODBC DSNless connection strings, but when I try an OLE DB > connection string, the cfquery fails. Does it work only > with DSNLess connections? According to the docs, DBTYPE

Re: file uploads without using CFFILE

2001-07-10 Thread Dick Applebaum
Hi Joe Does the host have ASP? If so, just incorporate it into your program flow as if you used a stand-alone CFTemplate to perform the upload and save the file: Template1.cfm... Present upload form - Action specifies ASP template Template2.asp... Upload, Save and rename the file & inv

Re: Turn off double-spacing on rds xfer

2001-07-10 Thread Bruce Holm
But it is set to Unix already. Any other ideas? Bruce [EMAIL PROTECTED] - Original Message - From: "Garza, Jeff" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 11:17 AM Subject: RE: Turn off double-spacing on rds xfer > F8 -> File Settings -> Check

RE: HTML Question with Netscape 4 and 6

2001-07-10 Thread Dylan Bromby
and once again, i think we need to do something about that "web developer extraordinaire" in the signature file... -Original Message- From: Jann VanOver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 1:21 PM To: CF-Talk Subject: RE: HTML Question with Netscape 4 and 6 Like you

RE: file uploads without using CFFILE

2001-07-10 Thread Jann VanOver
If your hosting provider allows CFX, there's a CFX_File in the Allaire dev exchange that would do the job. -Original Message- From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 10:46 AM To: CF-Talk Subject: file uploads without using CFFILE If hosted at

RE: HTML Question with Netscape 4 and 6

2001-07-10 Thread Jann VanOver
Like you said, you've got a firewall -- I get "cannot find server" with that URL. -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 12:17 PM To: CF-Talk Subject: OT: HTML Question with Netscape 4 and 6 Can someone please tell me why these p

Protectiong an application

2001-07-10 Thread Frank Mamone
Hi, I am trying to protect an application using Advanced Security. I'm defining the resource as an Application. I followed various tutorials step by step but still it ignores the NT User group defined in the policy for the rule. I'm just wondering, how does it know which application to apply the

Problem calling Oracle stored procedures (PL/SQL functions) by using CFSTOREDPROC

2001-07-10 Thread Joel Parramore
Hello folks, I'm trying to call an Oracle stored procedure (a PL/SQL function) from ColdFusion using and have been unable to do so. When I call the function, I get the following error: Oracle Error Code = 6550 ORA-06550: line 1, column 7: PLS-00221: 'FSELECTSTATE' is not a procedure or is und

SOT: Form builder software

2001-07-10 Thread Rick Lamb
Hi all, I need to find a better solution than html forms to meet my clients needs. My client has a bunch of paper forms and documents that he wants to use online. I've tried creating these in html but the lack of formatting and print control is causing some problems. Not to mention the huge amoun

RE: Column names containing a # sign

2001-07-10 Thread ccook22
So much for directly to Tristram. Anyways try the below and then just alias them as another name to reference in your CF code select [product#] as productnumber, [item#] as itemnumber from whatever #productnumber# #itemnumber# CC Casey C Cook/TMG/CSC@CSC on 07/10/2001 02:26:59 PM

RE: A page call in any IMG tag???

2001-07-10 Thread Jeff Green
I just want to give DJ a big thanks, this really helped alot! Oh and he ment to say CFContent not CFObject :) Jeff -Original Message- From: DJ Riebesell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 11:18 AM To: '[EMAIL PROTECTED]' Subject: RE: A page call in any IMG tag???

Re: Verity exclude sub-directories?

2001-07-10 Thread Joseph Thompson
I did see a "pathindex" tag at CFHacker.com http://www.cfhacker.com/ > I'm working with Verity and have a questionis there a way to exclude > certain sub-directories from being indexed in the collection? I have a few > 'procedure' directories that I don't want coming up in the user search.

RE: Column names containing a # sign

2001-07-10 Thread Bruce, Rodney
try SELECT tblone.[colum##] as colum from tblone; #test.colum# seems to work -Original Message- From: Tristram Charnley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 12:09 PM To: CF-Talk Subject: RE: Column names containing a # sign I

file uploads without using CFFILE

2001-07-10 Thread Joe Sheble aka Wizaerd
If hosted at an outside hosting provider, and that provider has CFFILE turned off, what other alternatives are there for uploading files from the client to the server. CFFTP won't work because it's expected to work via FTP server to server. This is for CF 4.5. Is there perhaps a free COM ob

dbtype=dynamic

2001-07-10 Thread tom muck
Has anyone tried to connect to a database thru the new connection string method? I've successfully connected with ODBC DSNless connection strings, but when I try an OLE DB connection string, the cfquery fails. Does it work only with DSNLess connections? tom ~

Re: Column names containing a # sign

2001-07-10 Thread Michael Lugassy
Try calling the "#" with its respectebly chr(num) I don't know which asacii code is "#" but try this (although it may sounds silly): (let's say the 19 ASCII code is "#")... UPDATE Registration#chr(19)# SET . bla bla bla It might help because I've seen cases where the char itself and the chr

RE: Column names containing a # sign

2001-07-10 Thread ccook22
Sometimes it takes forever for my e-mails to show up on cf-talk so Im forwarding this to you directly. Casey Cook -- Forwarded by Casey C Cook/TMG/CSC on 07/10/2001 02:23 PM --- Casey C Cook/TMG/CSC 07/10/2001 02:22 PM To: [EMAIL PROTECTED] cc: Sub

RE: Column names containing a # sign

2001-07-10 Thread ccook22
Try: select [product#], [item#] from whatever Casey Cook "Tristram Charnley" <[EMAIL PROTECTED]> on 07/10/2001 02:09:08 PM Please respond to [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> cc: Subject: RE: Column names containing a # sign I already tried double ## signs and aliasing

OT: HTML Question with Netscape 4 and 6

2001-07-10 Thread Robert Everland
Can someone please tell me why these pages completely mess up in Netscape 4 and 6 besides the obvious fact that they are the most horrid browsers on the face of the earth. http://209.215.124.4/community/index.cfm If you have any problems on here let me know, I have a firewall on this machine. Rob

Verity exclude sub-directories?

2001-07-10 Thread Deborah Carroll
I'm working with Verity and have a questionis there a way to exclude certain sub-directories from being indexed in the collection? I have a few 'procedure' directories that I don't want coming up in the user search. Thanks for your help! Deborah ~~

Verity exclude sub-directories?

2001-07-10 Thread Deborah Carroll
I'm working with Verity and have a questionis there a way to exclude certain sub-directories from being indexed in the collection? I have a few 'procedure' directories that I don't want coming up in the user search. Thanks for your help! Deborah ~~~

QuerySetCell on CF 5

2001-07-10 Thread Scott Van Vliet
Have any of you had prolems with the QuerySetCell() function on CF Server 5. I just upgraded to CF 5EE this morning, and I am having problems on pages that use this function. Here is the error: Unhandled System exception ! The error occurred while processing an element with a general identifi

RE: Column names containing a # sign

2001-07-10 Thread Tristram Charnley
I already tried double ## signs and aliasing - it doesn't work. I get the very strange error: Syntax error in date in query expression. There's no date type field anywhere in the table Tristram Charnley ~~ Structure your ColdFusion code with Fus

ONCR Cybercash

2001-07-10 Thread Todd A Dancer
Howdy All Has anyone experienced any problems installing the ONCR-CyberCash tag in CF5? I'm getting errors in the install routine. I've tried contacting ONCR for SEVERAL days now, and I've been unable to reach anyone. Needless to say, I'm a bit miffed by their less-than-prompt response to my vari

RE: OT - Allaire website

2001-07-10 Thread Lee Fuller
Can't say I've had that happen. Most of my Dev-Exchange searches take less than 20 seconds.. tops. Lee Fuller Chief Technical Officer PrimeDNA Corporation / AAA Web Hosting Corporation "We ARE the net." http://www.aaawebhosting.com > -Original Message- > From: Zac Belado [mailto:[EMA

RE: Debug output

2001-07-10 Thread Justin
Try putting after your at the end of your pages. Better yet, you could put it in onrequestend.cfm, then you wouldn't have to modify all your pages. Justin Hansen - [EMAIL PROTECTED] Web Application Developer Interactive Business Solutions, Inc 816-221-5200 ext. 1305 -Original Message-

RE: Turn off double-spacing on rds xfer

2001-07-10 Thread Garza, Jeff
F8 -> File Settings -> Check Format When Saving = Unix HTH, Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 8:53 AM To: CF-

Re: CF-TALK

2001-07-10 Thread Bruce Holm
This msg showed up right away...my earlier post finally showed up, nearly 2 hrs after posting it. Strange... - Original Message - From: "Bruce Holm" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 10:26 AM Subject: CF-TALK > This list is acting strang

RE: OT - Allaire website

2001-07-10 Thread Rich Tretola
Its been like that for a while. Rich -Original Message- From: Zac Belado [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 1:51 PM To: CF-Talk Subject: OT - Allaire website Is anyone else getting *very* slow searches on the Dev-Exchange site? I've been doing searches for the last

Re: OT - Allaire website

2001-07-10 Thread Todd Ashworth
Yes .. I was complaining about that just a few minutes ago. Moving between most of the pages in the devex section are slow .. not just the search. Todd - Original Message - From: "Zac Belado" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 1:51 PM Subj

OT - Allaire website

2001-07-10 Thread Zac Belado
Is anyone else getting *very* slow searches on the Dev-Exchange site? I've been doing searches for the last few days and routinely get results that take 2 to 3 minutes to return -- Zac Belado Application Developer Bayleaf Software #300 948 Homer Street, Vancouver, BC, V6B 2W7 Ph: 604.683.1288

A page call in any IMG tag???

2001-07-10 Thread Jeff Green
Hi all, I was looking at an email the other day and there was a .jsp page url in the src attribute of an image tag. example: I figure that this is how they track if someone read the email, and would like to do something similar. Has anyone ever heard of, or done this? Or if anyone has any id

Need db advice

2001-07-10 Thread Terri Stocke
Hey all, Need some advice here. I have an app that functions somewhat like an old library card catalog index. It allows users to input market studies with an abstract, as well as the location of the material. The customer (our marketing dept.) wants a reference number to be generated in the

RE: Column names containing a # sign

2001-07-10 Thread Russel Madere
Try replacing the single # with a double # in the column name... i.e. field#name would be field##name in your CFQuery block. > -Original Message- > From: Tristram Charnley [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 10, 2001 11:18 AM > To: CF-Talk > Subject: Column names containing

RE: Regex?

2001-07-10 Thread Mike Sullivan
If you have linux, use sed. something like: cat something.cfm|sed -e \ 'y/ABCDEFGHIJKLMNOPQRSTUVWXYZ/abcdefghijklmnopqrstuvwxyz/' | \ somethingelse.cfm that will do a character by character transformation. Mike > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROT

Turn off double-spacing on rds xfer

2001-07-10 Thread Bruce Holm
Short version: Does anyone know where the setting is in CF Studio 4.5 for preventing my files (that are transfered via RDS) from being converted to double-spacing (the lines of code?) Long version? When I first loaded CF Studio 4.5 about a year ago, all was fine. But the last 4 months, when I

RE: Column names containing a # sign

2001-07-10 Thread Daniel Lancelot
have you tried doubling your # ie product# = product## etc - cf should convert that to a single # before passing to db... -Original Message- From: Tristram Charnley [mailto:[EMAIL PROTECTED]] Sent: 10 July 2001 17:18 To: CF-Talk Subject: Column names containing a # sign Hi I've been

RE: Column names containing a # sign

2001-07-10 Thread Bruce, Rodney
You can always go back and smack the DB creator Not a solution, but may lower the stress level :o) but seriously, if the person that created the DB is still around, I hope someone explained to him, that you should NEVER put special chars in column names. -Original Message- From: Howar

Re: Debug output

2001-07-10 Thread Ricq Pattay
Just change the font color as the last line in your template, like so: Be sure NOT to include a closing tag. The font color you set here will carry over to all the CF debug stuff at the bottom of the page. Ricq Pattay ~ [EMAIL PROTECTED] Senior Analyst/Programmer College of Veterinary Medi

Re: Debug output

2001-07-10 Thread Howie Hamlin
View Source from the browser works for me. Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Join the DevCon community at www.coolfusion.com/devcon - Original Message --

CF-TALK

2001-07-10 Thread Bruce Holm
This list is acting strange... I am seeing some duplicate msgs posted. When I post, it doesn't show up (at least not after about an hour.) I didn't get any error msgs. What's up? ~~ Structure your ColdFusion code with Fusebox. Get the official boo

RE: Column names containing a # sign

2001-07-10 Thread Howarth, Craig (IBK-NY)
Two solutions: 1) Try escaping the names, as in Product##, in the CFQUERY and use a alias SELECT Product## AS ProductNum FROM whatever 2) Create a view on your database server that assigns an alias to each offending column. Always access the t

Re: CFFTP

2001-07-10 Thread Richard Ramos
Here's a simple backup page I have to backup some files of ours daily. I use CF's Scheduler to run this every night. Richard Ramos Network Administrator Softitler Net, Inc. www.softitler.com [EMAIL PROTECTED] --- backup.cfm --- --- End file --- - Original Message - From: "Chad Gra

Re: Column names containing a # sign

2001-07-10 Thread Clint Tredway
Try doing Product## and Registration## HTH -- Original Message -- From: "Tristram Charnley" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 10 Jul 2001 17:17:58 +0100 Hi I've been given a database containing column names such as Product# a

Column names containing a # sign

2001-07-10 Thread Tristram Charnley
Hi I've been given a database containing column names such as Product# and Registration# I've tried using aliases and backticks on these columns in my query to no effect - the # sign throws CF each time. Changing the column names isn't an option unfortunately. Any suggestions greatfully receive

CFFTP

2001-07-10 Thread Chad Gray
Anyone have example code for sending a file via CFFTP? 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/ Un

Debug output

2001-07-10 Thread stas
Is there a way to capture CFAS's debug output and format it? My problem is that if I develop a site that has a dark background, I can't see any debug information because the text is dark too. I am mainly interested in looking at SQL statements, I know you can see most other information (passed var

RE: Regex?

2001-07-10 Thread Garza, Jeff
I'd use a cfm template for this... I'm assuming you have CF running on the server where the image files are at. Do a CFDIRECTORY to get the files. Loop over the file list and to a followed by This should effectively take care of your problem. Jeff Garza Lead Developer/Webmaster Spectrum As

RE: Help needed with CFCONTENT

2001-07-10 Thread Bruce, Rodney
Jochem Thanks for your suggestions so far. I like to shoot the web browser developers, tho not the customer :o) But I think I have not explained very well, or am not understanding. I am on an NT 4.0/SP6a server, using ColdFusion 4.5.1.(hopefully to upgr

Re: cfloop and group

2001-07-10 Thread Jennifer Knoblock
Bryan Love wrote: > wow. > > First of all it looks like you've forgotten to use #innerloop# anywhere in > your code. The query is hard-coded to use [1] and [2] from the second > dimension of your array. Perhaps each item in the first dimension contains > a sub-array of only two items (documen

RE: RESERVED/KEYWORDS

2001-07-10 Thread David Shadovitz
Depends on the database, since most vendors have extensions to standard SQL. For MS Access, see "reserved words" in the online Help index. The Oracle SQL Reference (http://helios.a.tu-berlin.de:8000/wg73-doc/server/sql73/ch201.html) lists Oracle- and ANSI-reserved words. -David On Tuesday,

RE: ? about CF and Sybase

2001-07-10 Thread Dylan Bromby
you *must* have the sybase open client installed on the machine you're connecting with if you want to use the native drivers. and you need version 11.1.0 with update 11.1.1 applied. ODBC does *not* require the sybase open client though. we connect to a remote sybase DS using ODBC. works great. -

Re: MSXML, XML, outputting attributes?

2001-07-10 Thread Carl
So, "//" should probably be used once to get at the root node? What other methods are faster than using the "//" xpath statement? In my code I used the following effectively: nodeOffer_Id = service.selectSingleNode("Offer_Id"); Offer_Code = service.selectSingleNode("Offer_Id/@Offer_Code"); O

SOT: Regex?

2001-07-10 Thread kay
Hi all, Sorry for this slightly off topic post - I have exceedingly stupid (and cheap) clients and need to know if this is possible. This client has created a huge site himself, incorporating gallery pages with hundreds of images, both thumnails and high quality versions. Considering everythin

RE: Temporarily disabling DB constraints

2001-07-10 Thread Alistair Davidson
In enterprise manager, you can go into the table properties, find the constraint in the dropdown box and uncheck 'ENABLE CONSTRAINT FOR REPLICATION'. That works in SQL 7, I don't know about 2000 -Original Message- From: stas [mailto:[EMAIL PROTECTED]] Sent: 10 July 2001 16:00 To: CF-Talk

RE: RESERVED/KEYWORDS

2001-07-10 Thread Lomvardias, Christopher
Access Reserved words can be found at: http://support.microsoft.com/support/kb/articles/q109/3/12.asp SQL Server Reserved words can be found in the SQL Server Books Online. Chris -- Chris Lomvardias [EMAIL PROTECTED] Syscom, Inc. 4

? about CF and Sybase

2001-07-10 Thread Chris Alvarado
I am trying to get CF to use the Sybase native drivers and whenever CF tries to verify the connection to the Sybase server it fails. here is what i have in the CF administrator in case maybe im overlooking something or im doing something wrong. Data Source Name: abc123 Description: description

RE: RESERVED/KEYWORDS

2001-07-10 Thread Mike Townend
Ben Forta SQL in 10 minutes lists them all at the back Very very usfull if you've accidently called a field date... Not sure of a web resource tho Mike -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 16:01 To: CF-Talk Subject: RESERVE

RE: RESERVED/KEYWORDS

2001-07-10 Thread Lomvardias, Christopher
And for Access 2000 http://support.microsoft.com/support/kb/articles/q209/1/87.asp Chris -- Chris Lomvardias [EMAIL PROTECTED] Syscom, Inc. 400 E. Pratt Street, Suite 300 Baltimore, MD 21202 (410)539-3737 x1722 voice (410)539-7302

RE: RESERVED/KEYWORDS

2001-07-10 Thread Andy Ewings
Don't think so because each poece of database software will have a different list of keywords as a keyword in one db may not be one in another. Your best bet would be to look at documentation pertaining to your database product. --

RESERVED/KEYWORDS

2001-07-10 Thread James Taavon
Hey Everyone, I wanted to know if there is somewhere on the web that lists reserved and keywords to prevent me from using them in my database by accidently. James ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www

Temporarily disabling DB constraints

2001-07-10 Thread stas
Hello, I'm using MS SQL2000 and need to replicate data from one box to another. The process is failing because of certain constraints. Is there a non-hack workaround to this issue? Thanks. ~~ Structure your ColdFusion code with Fusebox. Get the o

Re: MSXML, XML, outputting attributes?

2001-07-10 Thread Edward Smith
Just a note, try to avoid using "//" in xpath - its has serious performance problem potential. Its essentially saying, "scan the whole DOM and look for any 'book' nodes." I don't think that this is what you want. In your real code, you are already in the "Service_Availability" node, so you don'

RE: Using a text file as a datasource

2001-07-10 Thread Paul Bowley
Thanks chaps...spot on. > -Original Message- > From: Philip Arnold - ASP [SMTP:[EMAIL PROTECTED]] > Sent: 10 July 2001 14:49 > To: CF-Talk > Subject: RE: Using a text file as a datasource > > > I'm trying to set up a text or csv file as a datasource in the CF > > administrator. E

Announcement: CF_ResendUndeliverableMail3 released

2001-07-10 Thread Cameron Childress
In addition to the capabilities of the V2 of this tag, V3 adds the following functionalities: - Respool undelivered mail to a list of different SMTP servers. - Move (not delete) perpetually failing mail after X days. - Admin notification of perpetually failing mail, including number of messages f

  1   2   >