RE: database.ldb
I'm probably off the track (or on a different planet)but is there not a syntax problem in the code??? The closing tag after the select * and before the from Haroon Williams Group IT Investec Bank Tel 011 286 7529 Fax 011 286 7522 Cell 082 853 4286 Email [EMAIL PROTECTED] [EMAIL PROTECTED] 04/26/01 01:03AM If you are running 4.5.1 there is a Release button in the Administrator to unlock the dB's. -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Thursday, 26 April 2001 08:53 To: CF-Talk Subject: database.ldb ok i hate access. i use this to unlock this db but it wont work now does anyone else have another idea? cfquery name=Unlock datasource=catlingalleries dbtype=ODBC Select * From ImageManager Where lock=damnyou /cfquery thanks Jay Patton Web Design / Application Design Web Pro USA p. 406.549.3337 ext. 203 p. 1.888.5WEBPRO ext. 203 e. [EMAIL PROTECTED] url. www.webpro-usa.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: CFX_IMAGE
Dain, Once again you've proved you da man. We've been playing around with it for some time and found it v. powerful. We started to use it to do dynamic banner ads, simple graphing (until CFGRAPH is complete) and other image admin tasks etc. but its always a bit of hit or miss with the syntax from the docs and hence costs us in dev time. A nice simple 'this is what you can do, this is what you can't' guide would be a jolly nice thing to do. --- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -Original Message- From: Dain Anderson [mailto:[EMAIL PROTECTED]] Sent: 25 April 2001 20:32 To: CF-Talk Subject: Re: CFX_IMAGE Rich, I'd be happy to, and I even thought about it at one point, but I didn't think there were that many people who still used it (considering it's not on Allaire's Dev Center). I had a bit of a time figuring it out at first, but once I got it, I found that the options are limitless (mostly). If Jukka is reading this, I'd like to ask him if I can host the tag at CF Comet. Right now, I think Intrafoundation.com is the only site that has Jukka's permission to post it (AFAIK). Dain Anderson Caretaker, CF Comet http://www.cfcomet.com/ - Original Message - From: Rich Wild [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 3:54 AM Subject: RE: CFX_IMAGE Yeah - Fantastic cfx but its a pity that I just can't decipher the documentation for it. I hope Jukka (if he's reading) isn't insulted, but its not the clearest thing in the world and there are a lot of crucial typos. Would it be too much to ask someone who comprehensively knows IML syntax to write a clearer guide? --- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -Original Message- From: Dain Anderson [mailto:[EMAIL PROTECTED]] Sent: 25 April 2001 09:00 To: CF-Talk Subject: Re: CFX_IMAGE I've used CFX_Image in a heavy production environment. In fact, we used it to literally *create* images on-the-fly from other images as well as text, replacing over 1,000 heading images, using the IML language provided by the tag (it kicks ass). I can't tell you how great that tag is -- with a little trial and error, you'll find that it's the best tag for this type of image creation and manipulation. Period. Dain Anderson Caretaker, CF Comet http://www.cfcomet.com/ - Original Message - From: Michael Lugassy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 4:37 AM Subject: Re: CFX_IMAGE I've heard there are some problem with concurent conncetions to CFX.,.. true?| Kay Smoljak [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I'm about to use the tag CFX_IMAGE extensivley on my new project. Is it reliable enough? Is there anything I should consider? mem
Moving data from table to table
Hi Everyone, Got a bit of a dilema : I have a table for user details with a field schedule_num which contains the total number of forms filled out by a person. I have another table for the forms. This has a field with the users user_id and with the field schedule_id which is supposed to contain a counting number for each form. Now schedule_id is a unique number but I don't want to use autonumbering for it. This is because when a user wants to see their forms they should only see the numbers 1 to schedule_num with their forms and not a autonumbered 20324. Now someone has gone and wiped the schedule_id field from my forms table and rather than hand code all 3000 records I was wondering if there was anyway I could get the schedule_num from user_details for each user and then loop from 1 to schedule_num updating the forms table's schedule_id so that I had my schedule_id's back. So basically If the user has 5 forms Name : User_id : Form1 1 Form2 1 Form3 1 Form4 1 Form5 1 (generic names used) How can I make it look like : Name: User_id: Schedule_id: Form1 1 1 Form2 1 2 Form3 1 3 Form4 1 4 Form5 1 5 I have tried my hand at the code, but the loops are too long and the browser times out. cfquery name=qGetSchedID datasource=RTRE SELECT user_id, schedule_num FROM User_details WHERE schedule_num 0 /cfquery cfoutput query=qGetSchedID cfloop index=i from=1 to=#qGetSchedID step=1 cfquery name=qUpdateWrksSched datasource=RTRE Update works_schedule SET schedule_id = #i# WHERE user_id = #qGetSchedID.user_id# /cfquery /cfloop /cfoutput Any help appreciated. Thanks, Kunal Bhatia __ Web Programmer CSC Ph: 02 6246 8715Mobile: 0411022234Email: [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Decoding information from a Get method submission
Loryn, I think this is what you're asking but forgive me if I've misunderstood the question: All of your form input values, when submitted with a GET command, will be accessible from the URL. This means that any variables from your form can be accessed on the form action's target template from within the URL scope. An example: Your form contains form action=process.cfm method=get input type=hidden name=this value=sausage /form When submitted, the url in the browser will show: http://www.funjunkie.co.uk/process.cfm?this=sausage Which you can access as 'url.this' so cfoutput#url.this#/cfoutput will show 'sausage' This doesn't have to apply to forms submitted with GET only - any variable put into the URL can be accessed like this. If you have multiple values in your form, you'll be able to access them individually as 'url.nameofthisvariable1' and 'url.nameofthisvariable2' etc etc. Be aware that if you have checkboxes in your form and they are not checked then they won't be passed in the url. --- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -Original Message- From: Loryn C Williams [mailto:[EMAIL PROTECTED]] Sent: 25 April 2001 19:44 To: CF-Talk Subject: Decoding information from a Get method submission All, I am running up against a problem I have never encountered before an am hoping to get a bit of help here. I have searched the docs and mail-archive already with no success. I have a cf form that is being accessed by an html form that MUST submit data using the get method. How do I pull the query information and split the variables? I've done it with cgi scripting, but don't know where to begin for this. Any help will be appreciated. Thanks in Advance Loryn Williams ~~ 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: Cfmail
Thanks for all your help! I do have a correct from field entry. And my mail server is not on the ORBS, now what do i do? I really need to these emails go through to the webaddresses, such as yahoo, hotmail...etc... This is the code i use. If there are any suggestions..please help! cfquery datasource=#ds# name=EmailList Select * From Email /cfquery CFLOOP query=EmailList cfmail server=sandvalley.net from=[EMAIL PROTECTED] to=#Email# subject=YallaNesa3ed Notification #Day(Now())#/#Month(Now())#/#Year(Now())# #mail_body# /cfmail /CFLOOP --- Dennis Powers [EMAIL PROTECTED] wrote: Heidi, Be sure that you have valid email address domains in the from field and that it is properly formatted. The large mail providers will reject mail from bogus domains or with no return address. Also check to be sure your e-mail server is not on the ORBS list http://www.orbs.org/ as an open relay mail site. To further trouble shoot, check to see what errors your mail server is receiving when trying to connect and send to one of the big web-mail's Best Regards, Dennis Powers UXB Internet (203) 879-2844 http://www.uxbinfo.com/ -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 9:42 AM To: CF-Talk Subject: Cfmail Hi! I have a question regarding cfmail. It's really strange. I used the cfmail tag to send an email, but it is not going through to the webemails such as excite, yahoo, hotmail..etc..but it goes through to my pop3 account just fine. Does anybody have an idea why that would be case or how to fix it? thanks! = Heidi Belal ICQ# 32127109 http://m3.easyspace.com/hmbelal A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ 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: Storing structures in a DB
as for normalizing; with a globally designed DB - it is not necessary; the logic is ported into the App. Well, sorry to bore people with this now slightly OT thread, but there's the rub - by storing all the data in one table you have thrown away all the inherent business-modelling capability of a relational database and made far *more* work for the developers, not less. Not only that, but you lose the ability of the DB design to serve as a central authoritative design document describing the enterprise rules. Not to mention performance and the fact that the database is now practically un-optimisable by the DBMS and un-tunable by the DBA. I worked on a client-server project exactly 10 years ago where the database designer tried the same approach. It didn't work. Obviously times have changed but.. the upside needs to be pretty good to outweigh all that. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: Whats happening to Spectra
No Rumour, it will be discontinued after the next maintenance release 1.5.1. The plan is to take the core components / services and port them into the app server - which in my opinion is the way forward... So ColdFusion developers are going to get some of the Spectra functionality in future releases of ColdFusion Application Server? If so... great! Any ideas what we are going to get? -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ~~ 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
Contact Management App.
Anyone know of a CF contact app? basic profile.contact info? ..brian ~~ 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: Whats happening to Spectra
That's correct a select suite of services will be ported into the application server (may only be enterprise edition, can't say... :-) The content management is sure to be inlcuded - as for the others, you have to look at the other products Macromedia do and then make an educated guess; e.g. Likeminds etc... Hope this helps. N !- Neil Clark Senior Web Applications Engineer Spectra / CF / XML MCB Digital Premier Macromedia Partner Tel: 020 8941 3232 Fax: 020 8941 4333 e-mail: [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
hosting
Have any of you rented a dedicated server? Could you give me your opinons of where to rent it from? = Heidi Belal ICQ# 32127109 http://m3.easyspace.com/hmbelal A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ 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
cf server certification
Does anybody know how the cf server professional is certified? i.e. per installation on computer or if a company buys it, it can be installed any number of types? thanks! = Heidi Belal ICQ# 32127109 http://m3.easyspace.com/hmbelal A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ 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
cf server certification
Does anybody know how the cf server professional is certified? i.e. per installation on computer or if a company buys it, it can be installed any number of types? thanks! = Heidi Belal ICQ# 32127109 http://m3.easyspace.com/hmbelal A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ 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: hosting
In the UK we rent dedicated servers from Londonweb (londonweb.net) - premier hosting partner with Macromaire/Allmedia - they know their stuff (prices range from about £7.5k pa to £10k+ pa depending on size, etc) - we currently have 3 dedicated servers with them, we also have 5 dedicated servers with NISS (academic hosting for UK government), 1 with UUNet and 1 with PSINet - all fine, but had to buy CF server software for all except Londonweb - which includes server and MS SQL prices in rental. J -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 10:37 To: CF-Talk Subject: hosting Have any of you rented a dedicated server? Could you give me your opinons of where to rent it from? Heidi Belal ICQ# 32127109 http://m3.easyspace.com/hmbelal A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ 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
slightly OT ADO vs DAO
Hi all, I know this is slightly OT, but I wanted to get peoples opinions about ADO vs DAO in ACCESS2000. It's not something I'd looked at before to be honest, so was looking for general feedback, info on each etc, TIA Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: slightly OT ADO vs DAO
I I reckon DAO...although that could start a war on here! Basically DAO was written for the JET engine so goes hane in hand with Access. ADO is more of a generic data access method - tries to be everything to every data source (and does it well!)can't say I've done any performance testing between the 2 using Access but I imagine there aint much in it. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 10:51 To: CF-Talk Subject: slightly OT ADO vs DAO Hi all, I know this is slightly OT, but I wanted to get peoples opinions about ADO vs DAO in ACCESS2000. It's not something I'd looked at before to be honest, so was looking for general feedback, info on each etc, TIA Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: slightly OT ADO vs DAO
DAO is a dead-end. ADO is more future-proof. Nick -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 10:51 AM To: CF-Talk Subject: slightly OT ADO vs DAO Hi all, I know this is slightly OT, but I wanted to get peoples opinions about ADO vs DAO in ACCESS2000. It's not something I'd looked at before to be honest, so was looking for general feedback, info on each etc, TIA Will ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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
Writing 0 to a binary file.
Hi there, The quick: I'm trying to write out binary files, i.e. just a whole bunch of numbers, what's the best way of doing this. The slightly longer: I'm trying to write out a binary file, that can contains the value 0, and it doesn't seem possible (in any simple, fast way). Here's the background. I'm trying to read in and write out .wbmp graphic files. I can read in a file with the following snippit... !--- Read in the binary file, as though it were text --- cffile action=read file=c:\temp\myFile.wbmp variable=inputFile !--- // now loop through the file outputting the results. For us to be able to // see anything meaningful, I'm using asc(), to give me the ASCII value of // the byte we just read in, and the formatBaseN to give me the hex value, // just like old skool debugging tools :) --- cfoutput cfloop index=thisPos from=1 to #len(inputFile)# #asc(mid(inputFile,thisPos,1))# - #ucase(formatBaseN(asc(mid(inputFile,thisPos,1)),16)# - #mid(inputFile,thisPos,1)# br /cfloop /cfoutput which may give me the results: 0 - 0 - 0 - 0 - 92 - 5C - \ 65 - 41 - A 0 - 0 - 77 - 4D - M 116 - 74 - t 0 - 0 - 0 - 0 - --- Now I want to write these results back to a file, normally I'd do something like (which I'm sure is a very wrong way of doing it)... cfset outputFile = '' cfset outputValues = '0,0,92,65,0,77,116,0,0' cfloop index=thisValue from=1 to=#listLen(outputValues)# cfset outputfile = '#outputfile##chr(listGetAt(outputValues,thisValue)#' /cfloop cffile action=write file=c:\temp\newFile.wbmp output=#outputFile# addnewline=No However reading that back in just gives me; 92 - 5C - \ 65 - 41 - A 77 - 4D - M 116 - 74 - t It's lost the 0's chr(0) = null, which may explain the problem. --- I *can* do it with the following... !--- here's the binary data I want to send out --- cfset outputValues = '0,0,92,65,0,77,116,0,0' !--- read in a file, where I know the first value is 0 --- cffile action=read file=c:\temp\myFile.wbmp variable=inputFile !--- create a new file, into which I'm going to put my data --- cffile action=write file=c:\temp\newFile.wbmp output='' addnewline=No !--- loop through the list of values, in the hope we are going to write the value out --- cfloop index=thisPos from=1 to=#listLen(outputValues)# !--- if my value is 0, then I'm going to have to use cunning methods to write a value of 0 out to the file --- cfif listGetAt(outputValues,thisPos) EQ 0 cffile action=append file=c:\temp\newFile.wbmp output=#mid(inputFile,1,1)# addnewline=No cfelse cffile action=append file=c:\temp\newFile.wbmp output=#chr(listGetAt(outputValues,thisPos))# addnewline=No /cfif /cfloop The above give me what I want, but with loads of disk accessing, basically I just want to speed it all up! Thanks for any help, Dan. This message is intended only for the use of the person(s) (the intended recipient(s)) to whom it is addressed. It may contain information which is privileged and confidential within the meaning of the applicable law. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views held by Live Information Systems Limited. ~~ 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
Last Visit Weirdness
Guys, I'm having some major weirdness with Last Visit, basically it's updating the date when the session starts as opposed to doing it when it ends This seems a little weird because when I pull the last visit from the CGlobal and CData tables, it's giving me a date and time that are three or soo seconds before the current date and time Even though I've been to the site before. HELP!!! This is doing my NUT!!! Does anyone have any experience of this kind of behaviour. Or could someone confirm that I am in fact loosing my mind... :o) best wishes, -= Ed Problems cannot be solved at the same level of awareness which created them. - Albert Einstein ~~ 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: Sending mail with coldfusion
a little question David: how can you send 24000+ emails at a time with CF? do you use some wait mechanism between mails ? ~Juan - Original Message - From: David Hannum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 26, 2001 2:50 AM Subject: Re: Sending mail with coldfusion I use CFMAIL here to send out 24,000+ emails at a time. Never have a problem. Are you sure it's not your SMTP server that's choking? Just a thought. Dave - Original Message - From: William J Wheatley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 5:11 PM Subject: Sending mail with coldfusion Ok i have just about had it with CF mail =). With the bulk of the mail we send out it just eventually fills the spool at about 12,000 or so and then Dies nothing else goes out, no errors in any of the logs but the mail just wont go out and its in the /opt/coldfusion/mail directory has anyone come up with an alternative to sending mail then using CFMAIL? Because i swear even trying to send 1 CFMAIL to a hundred people does not cut it..its a major issue. Thanks for the quick help! Bill Wheatley Director of Development AEPS INC Allaire ColdFusion Consulting Partner Allaire Certified ColdFusion Developer http://www.aeps.com ICQ: 417645 954-472-6684 X303 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 unauthorized 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
hosting
Another question with regards to hosting! I know this isn't very relevant but i'd really like to learn! if you have a server and are going to sell hosting space on it, how do you devise the cost at which to sell the space? I'm also interesed to know a lot more on hosting etc..so if you could recommend some where were i can find information on it..it would be great! Thanks! :) = Heidi Belal ICQ# 32127109 http://m3.easyspace.com/hmbelal A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ 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: hosting
You wet your finger and then stick it in the air only kidding - Here are some factors that affect cost: Physical web space given (Mb's) Database utilities (MS SQL, ORACLE, etc) Email accounts Support CGI Bin + any other Server Side utilities (such as CF) -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 11:36 To: CF-Talk Subject: hosting Another question with regards to hosting! I know this isn't very relevant but i'd really like to learn! if you have a server and are going to sell hosting space on it, how do you devise the cost at which to sell the space? I'm also interesed to know a lot more on hosting etc..so if you could recommend some where were i can find information on it..it would be great! Thanks! :) = Heidi Belal ICQ# 32127109 http://m3.easyspace.com/hmbelal A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ 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: hosting
It's very much up to the individual company - how do you want to set the server up? How much space allocation are you going to offer? What kind of support are you going to give? Can you/your server provider offer 99% up time? Do you want to offer mail? If so should you get a dedicated mail/chat server too? Are you going to hire support/telephone staff to assist users? Does everyone get a ftp account? Stats server? Limited/monitored IP/bandwidth? Will you offer database connectivity at cost or extra? After about 100 to 200 mb server space do you want to advise the client/s to rent their own server? The list goes on, but do some research around the industry - we thought that our prices where competitive, but when we did research we realised that we were Vastly overcharging for smaller spaces, also we host some of our NZ clients and they expect to pay no more that $100 NZ per year for a 10mb site WITH coldfusion and SQL support and connectivity - best thing to do is to do some of your own research - go to Allaire.com - find hosting partners - contact them about hiring space/renting whole servers, etc and go global - UK is a one site high rate market - US is a multi-server farm huge power low cost market - NZ/OZ is a one site/server low money market etc, etc. J (probably best to continue this off list.) -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 11:36 To: CF-Talk Subject: hosting Another question with regards to hosting! I know this isn't very relevant but i'd really like to learn! if you have a server and are going to sell hosting space on it, how do you devise the cost at which to sell the space? I'm also interesed to know a lot more on hosting etc..so if you could recommend some where were i can find information on it..it would be great! Thanks! :) = Heidi Belal ICQ# 32127109 http://m3.easyspace.com/hmbelal A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ 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
Semaphore CF
does any one here have any experience to imputing data into semaphore using cold fusion. semaphore, doesn't want any one to see there accounting data that's in FoxPro. they want to charge us for any little add on. so any info on doing inputs into the db would be appreciated. thank you -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 ~~ 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: SQL Server 2000 warning
David, It's funny how timing works...I had just read this email from another list I am on and then came across yoursso I did an old copy/paste job. Hi All, I am the king of OT posts this week, but y'all know yer stuff, so... Every time I change a SQL Server TABLE, any VIEWS associated with that table are f***ed up until I open the view, make a small change (like add or delete a line at the bottom of the SQL code in the view), and save the view. This is especially noticeable when I add or remove table colums. IS THERE ANY WAY TO FORCE A VIEW TO REFRESH after a change to a table upon which it is based? I have one table that is the basis for five different views, and each time I have to go and play with those views after I make a change to the table, even thought the change I make does not directly affect the output of any of those views. Thanks, .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Marc Funaro, President Advantex Technical Consulting Services 5547 State Highway 12 Norwich, NY 13815 Phone: 607-336-6895 Fax: 801-383-4864 Internet: http://www.advantex.net Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] .. . . . . . . . . . . . . . . . . . . . . . . . . . . . Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Sending mail with coldfusion
Bill, There are several other issues with CFMAIL that led us to abandon it (such as strict RFC compliant email servers like QMail, etc.). If you are on a Win32 setup, you may want to look at the AspMail COM object from www.serverobjects.com This component is heavy duty with a list of heavy hitters using it. Some of it's functions allow: multiple file attachments custom headers(X-Mailer, etc.) Word wrapping at n characters Several other mail headers(priority,return-receipt, etc.) PGP Encryption I think it sells for $50. Someone has also written a custom tag for an easy interface to it. -Original Message- From: William J Wheatley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 5:11 PM To: CF-Talk Subject: Sending mail with coldfusion Ok i have just about had it with CF mail =). With the bulk of the mail we send out it just eventually fills the spool at about 12,000 or so and then Dies nothing else goes out, no errors in any of the logs but the mail just wont go out and its in the /opt/coldfusion/mail directory has anyone come up with an alternative to sending mail then using CFMAIL? Because i swear even trying to send 1 CFMAIL to a hundred people does not cut it..its a major issue. Thanks for the quick help! Bill Wheatley Director of Development AEPS INC Allaire ColdFusion Consulting Partner Allaire Certified ColdFusion Developer http://www.aeps.com ICQ: 417645 954-472-6684 X303 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 unauthorized 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
Random form variables problem
Hi everyone, I've an unusual problem. Sometimes (random, and luckily not often) I have a situation where one form variable (but not always the same) is not being passed to the action template. Form method is post. Any ideas? Thanks Abe ~~ 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: refresh page
Ok having a little trouble figuring out what you are meaning is not refreshing but heres my best guess =) IF the content is not refreshing on the web browser maybe you want to try your browser cache and set your browser to reload page on each visit that could help fix your problem -) Bill Wheatley Director of Development AEPS INC Allaire ColdFusion Consulting Partner Allaire Certified ColdFusion Developer http://www.aeps.com ICQ: 417645 954-472-6684 X303 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 unauthorized alterations to this e-mail or attachment to it - Original Message - From: Haryono ... [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 9:28 PM Subject: refresh page Hallo, I want to ask something. I use cflocation to move to page editlecture.cfm. cflocation url=editlecture.cfm addtoken=No But at page editlecture.cfm, the content of editlecture.cfm not refresh. ( I use page editlecture.cfm to display list of lecture) Can you help me? ~~ 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: Random form variables problem
Are you passing a form filed of type file?. What is the type of the filed that is not appearing? -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Dondana Alberto [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 13:19 To: CF-Talk Subject: Random form variables problem Hi everyone, I've an unusual problem. Sometimes (random, and luckily not often) I have a situation where one form variable (but not always the same) is not being passed to the action template. Form method is post. Any ideas? Thanks Abe ~~ 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: Random form variables problem
Dondana, What browser are you using? I have heard that this is a known bug in Netscape 6 if you are using that... --- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -Original Message- From: Dondana Alberto [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 13:19 To: CF-Talk Subject: Random form variables problem Hi everyone, I've an unusual problem. Sometimes (random, and luckily not often) I have a situation where one form variable (but not always the same) is not being passed to the action template. Form method is post. Any ideas? Thanks Abe ~~ 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: Cfmail
try specifying the the IP of the server instead of the domain. -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 1:11 AM To: CF-Talk Subject: RE: Cfmail Thanks for all your help! I do have a correct from field entry. And my mail server is not on the ORBS, now what do i do? I really need to these emails go through to the webaddresses, such as yahoo, hotmail...etc... This is the code i use. If there are any suggestions..please help! cfquery datasource=#ds# name=EmailList Select * From Email /cfquery CFLOOP query=EmailList cfmail server=sandvalley.net from=[EMAIL PROTECTED] to=#Email# subject=YallaNesa3ed Notification #Day(Now())#/#Month(Now())#/#Year(Now())# #mail_body# /cfmail /CFLOOP --- Dennis Powers [EMAIL PROTECTED] wrote: Heidi, Be sure that you have valid email address domains in the from field and that it is properly formatted. The large mail providers will reject mail from bogus domains or with no return address. Also check to be sure your e-mail server is not on the ORBS list http://www.orbs.org/ as an open relay mail site. To further trouble shoot, check to see what errors your mail server is receiving when trying to connect and send to one of the big web-mail's Best Regards, Dennis Powers UXB Internet (203) 879-2844 http://www.uxbinfo.com/ -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 9:42 AM To: CF-Talk Subject: Cfmail Hi! I have a question regarding cfmail. It's really strange. I used the cfmail tag to send an email, but it is not going through to the webemails such as excite, yahoo, hotmail..etc..but it goes through to my pop3 account just fine. Does anybody have an idea why that would be case or how to fix it? thanks! = Heidi Belal ICQ# 32127109 http://m3.easyspace.com/hmbelal A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ 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: Cfmail
you might also want to try changing the x-mailer value. some sites filter out allaire coldfusion as the mailer because they think it might be a bulk mailer and/or spam. -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 1:11 AM To: CF-Talk Subject: RE: Cfmail Thanks for all your help! I do have a correct from field entry. And my mail server is not on the ORBS, now what do i do? I really need to these emails go through to the webaddresses, such as yahoo, hotmail...etc... This is the code i use. If there are any suggestions..please help! cfquery datasource=#ds# name=EmailList Select * From Email /cfquery CFLOOP query=EmailList cfmail server=sandvalley.net from=[EMAIL PROTECTED] to=#Email# subject=YallaNesa3ed Notification #Day(Now())#/#Month(Now())#/#Year(Now())# #mail_body# /cfmail /CFLOOP --- Dennis Powers [EMAIL PROTECTED] wrote: Heidi, Be sure that you have valid email address domains in the from field and that it is properly formatted. The large mail providers will reject mail from bogus domains or with no return address. Also check to be sure your e-mail server is not on the ORBS list http://www.orbs.org/ as an open relay mail site. To further trouble shoot, check to see what errors your mail server is receiving when trying to connect and send to one of the big web-mail's Best Regards, Dennis Powers UXB Internet (203) 879-2844 http://www.uxbinfo.com/ -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 9:42 AM To: CF-Talk Subject: Cfmail Hi! I have a question regarding cfmail. It's really strange. I used the cfmail tag to send an email, but it is not going through to the webemails such as excite, yahoo, hotmail..etc..but it goes through to my pop3 account just fine. Does anybody have an idea why that would be case or how to fix it? thanks! = Heidi Belal ICQ# 32127109 http://m3.easyspace.com/hmbelal A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ 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: Random form variables problem
I'm passing text fields, checkbox and radio button, but the problem appears only with text fields. There is no pattern with the browser version or model (most of users works with IE 4/5). This is an example code: cfform action=actionurl.cfm?variable=#nameofavariable# method=POST enablecab=No cfinput type=Text name=nameofthevariable value=#query.variable# required=No size=20 maxlength=16 cfinput type=Text name=nameofthevariable1 value=#query.variable1# required=No size=20 cfinput type=Text name=nameofthevariable2 value=#query.variable2# required=No size=20 cfinput type=Radio name=tipo value=1 ... /cfform ~~ 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: Cfmail
Have a look at your CF mail log file which is typically in: cf installed folder\mail\log\ Let us know if there's anything in there... HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server - Original Message - From: Heidi Belal [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 26, 2001 4:11 AM Subject: RE: Cfmail Thanks for all your help! I do have a correct from field entry. And my mail server is not on the ORBS, now what do i do? I really need to these emails go through to the webaddresses, such as yahoo, hotmail...etc... This is the code i use. If there are any suggestions..please help! ~~ 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: slightly OT ADO vs DAO
Thats how I saw it too. As I'm new to this side of things, can you tell me, is it possible to use both in an Access DB? Cheers Will -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 11:03 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Nick has got a point that there is no guarantee of support for DAO (or RDO come to that) but I can't see MS dropping uspport for something that ties in so closely with a db that is so widely used -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 10:58 To: CF-Talk Subject: RE: slightly OT ADO vs DAO DAO is a dead-end. ADO is more future-proof. Nick -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 10:51 AM To: CF-Talk Subject: slightly OT ADO vs DAO Hi all, I know this is slightly OT, but I wanted to get peoples opinions about ADO vs DAO in ACCESS2000. It's not something I'd looked at before to be honest, so was looking for general feedback, info on each etc, TIA Will ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: Cfmail
Heidi: You also may want to stremline your code from: CFLOOP query=EmailList cfmail server=sandvalley.net from=[EMAIL PROTECTED] to=#Email# subject=YallaNesa3ed Notification #Day(Now())#/#Month(Now())#/#Year(Now())# #mail_body# /cfmail /CFLOOP ---to--- cfmail query=EmailList server=sandvalley.net from=[EMAIL PROTECTED] to=#EmailList.Email# subject=YallaNesa3ed Notification #Day(Now())#/#Month(Now())#/#Year(Now())# #mail_body# /cfmail no need for the loop the query will output each email individually. Just another thought. Dan -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 4:11 AM To: CF-Talk Subject: RE: Cfmail Thanks for all your help! I do have a correct from field entry. And my mail server is not on the ORBS, now what do i do? I really need to these emails go through to the webaddresses, such as yahoo, hotmail...etc... This is the code i use. If there are any suggestions..please help! cfquery datasource=#ds# name=EmailList Select * From Email /cfquery CFLOOP query=EmailList cfmail server=sandvalley.net from=[EMAIL PROTECTED] to=#Email# subject=YallaNesa3ed Notification #Day(Now())#/#Month(Now())#/#Year(Now())# #mail_body# /cfmail /CFLOOP --- Dennis Powers [EMAIL PROTECTED] wrote: Heidi, Be sure that you have valid email address domains in the from field and that it is properly formatted. The large mail providers will reject mail from bogus domains or with no return address. Also check to be sure your e-mail server is not on the ORBS list http://www.orbs.org/ as an open relay mail site. To further trouble shoot, check to see what errors your mail server is receiving when trying to connect and send to one of the big web-mail's Best Regards, Dennis Powers UXB Internet (203) 879-2844 http://www.uxbinfo.com/ -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 9:42 AM To: CF-Talk Subject: Cfmail Hi! I have a question regarding cfmail. It's really strange. I used the cfmail tag to send an email, but it is not going through to the webemails such as excite, yahoo, hotmail..etc..but it goes through to my pop3 account just fine. Does anybody have an idea why that would be case or how to fix it? thanks! = Heidi Belal ICQ# 32127109 http://m3.easyspace.com/hmbelal A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ 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: slightly OT ADO vs DAO
Yeh I think so. My use of DAO/ADO/RDO was through VB. Just used each to create connection and query objects and run them against the db. I'm not sure if you can choose which you want to use directly in Access although I haven't used Access for a While and things may have changed in 2000!) -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 14:30 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Thats how I saw it too. As I'm new to this side of things, can you tell me, is it possible to use both in an Access DB? Cheers Will -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 11:03 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Nick has got a point that there is no guarantee of support for DAO (or RDO come to that) but I can't see MS dropping uspport for something that ties in so closely with a db that is so widely used -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 10:58 To: CF-Talk Subject: RE: slightly OT ADO vs DAO DAO is a dead-end. ADO is more future-proof. Nick -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 10:51 AM To: CF-Talk Subject: slightly OT ADO vs DAO Hi all, I know this is slightly OT, but I wanted to get peoples opinions about ADO vs DAO in ACCESS2000. It's not something I'd looked at before to be honest, so was looking for general feedback, info on each etc, TIA Will ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: Random form variables problem
If a checkbox is unchecked, then that form variable will not be passed via either a POST or GET action. -Dan -Original Message- From: Dondana Alberto [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 9:16 AM To: CF-Talk Subject: Re: Random form variables problem I'm passing text fields, checkbox and radio button, but the problem appears only with text fields. There is no pattern with the browser version or model (most of users works with IE 4/5). This is an example code: cfform action=actionurl.cfm?variable=#nameofavariable# method=POST enablecab=No cfinput type=Text name=nameofthevariable value=#query.variable# required=No size=20 maxlength=16 cfinput type=Text name=nameofthevariable1 value=#query.variable1# required=No size=20 cfinput type=Text name=nameofthevariable2 value=#query.variable2# required=No size=20 cfinput type=Radio name=tipo value=1 ... /cfform ~~ 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: Random form variables problem
Donna As a test try using a normal form as opposed to a coldfusion form to see if this is what's causing the prob. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Dondana Alberto [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 14:16 To: CF-Talk Subject: Re: Random form variables problem I'm passing text fields, checkbox and radio button, but the problem appears only with text fields. There is no pattern with the browser version or model (most of users works with IE 4/5). This is an example code: cfform action=actionurl.cfm?variable=#nameofavariable# method=POST enablecab=No cfinput type=Text name=nameofthevariable value=#query.variable# required=No size=20 maxlength=16 cfinput type=Text name=nameofthevariable1 value=#query.variable1# required=No size=20 cfinput type=Text name=nameofthevariable2 value=#query.variable2# required=No size=20 cfinput type=Radio name=tipo value=1 ... /cfform ~~ 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: Cfmail
actually, i send out 50,000+ emails and when i do, i found it's more efficient to CFLOOP over the query. -Original Message- From: Daniel H [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 6:45 AM To: CF-Talk Subject: RE: Cfmail Heidi: You also may want to stremline your code from: CFLOOP query=EmailList cfmail server=sandvalley.net from=[EMAIL PROTECTED] to=#Email# subject=YallaNesa3ed Notification #Day(Now())#/#Month(Now())#/#Year(Now())# #mail_body# /cfmail /CFLOOP ---to--- cfmail query=EmailList server=sandvalley.net from=[EMAIL PROTECTED] to=#EmailList.Email# subject=YallaNesa3ed Notification #Day(Now())#/#Month(Now())#/#Year(Now())# #mail_body# /cfmail no need for the loop the query will output each email individually. Just another thought. Dan -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 4:11 AM To: CF-Talk Subject: RE: Cfmail Thanks for all your help! I do have a correct from field entry. And my mail server is not on the ORBS, now what do i do? I really need to these emails go through to the webaddresses, such as yahoo, hotmail...etc... This is the code i use. If there are any suggestions..please help! cfquery datasource=#ds# name=EmailList Select * From Email /cfquery CFLOOP query=EmailList cfmail server=sandvalley.net from=[EMAIL PROTECTED] to=#Email# subject=YallaNesa3ed Notification #Day(Now())#/#Month(Now())#/#Year(Now())# #mail_body# /cfmail /CFLOOP --- Dennis Powers [EMAIL PROTECTED] wrote: Heidi, Be sure that you have valid email address domains in the from field and that it is properly formatted. The large mail providers will reject mail from bogus domains or with no return address. Also check to be sure your e-mail server is not on the ORBS list http://www.orbs.org/ as an open relay mail site. To further trouble shoot, check to see what errors your mail server is receiving when trying to connect and send to one of the big web-mail's Best Regards, Dennis Powers UXB Internet (203) 879-2844 http://www.uxbinfo.com/ -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 9:42 AM To: CF-Talk Subject: Cfmail Hi! I have a question regarding cfmail. It's really strange. I used the cfmail tag to send an email, but it is not going through to the webemails such as excite, yahoo, hotmail..etc..but it goes through to my pop3 account just fine. Does anybody have an idea why that would be case or how to fix it? thanks! = Heidi Belal ICQ# 32127109 http://m3.easyspace.com/hmbelal A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ 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
Syntax error or sharing violation
can anyone here see what the problem with this statement is ? cfquery name=news datasource=cosmos1 dbtype=ODBC UPDATE waiting_room_news set headline = '#headline#', subtitle = '#subtitle#', body = '#body#', author = '#author#', expdate = '#expdate#', cfif #audience# EQ 'Keep old value' audience = '#oldaudience#' cfelse audience = '#audience#' /cfif, datestamp = '#date#', !---Set the approval field back to 0 --- live = 0, where id = #id# /cfquery This is the error message I am getting: Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (20:1) to (20:56). Date/Time: 04/26/01 14:50:44 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 95; DigExt) Remote Address: 129.153.207.20 HTTP Referer: http://uk1web2:8080/menutest/authorise/edit_news.cfm?id=5country=World Widecontent=news Template: E:\Inetpub\publicsite\menutest\authorise\edit_news_action.cfm Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [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: refresh page
Here is some code that we use at the top of the pages we don't want to have cached (refreshed every time) hope it helps. meta http-equiv=Expires content=0 !--- setup our expire times for NN and MSIE --- cfoutput !--- MSIE (Fri, 30 Oct 1998 14:19:41 GMT) --- cfset MSIEtimestamp='#dateformat(now(),DDD)#,#dateformat(now(),DD)# #dateformat(now(),Mmm)# #timeformat(now(),HH:MM:SS)#' !--- Netscape (Wednesday, Apr 26 2000 17:45:25 PM) --- cfset NETSCAPEtimestamp='#dateformat(now(),)#,#dateformat(now(),MMM)# #dateformat(now(),dd)# #dateformat(now(),YYY)# #timeformat(now(),HH:MM:SS tt)#' /cfoutput !--- tell HTTP Header to force expire of pate - nocache --- cfif HTTP_USER_AGENT contains MSIE cfheader name=Expires value=cfoutput#MSIEtimestamp#/cfoutput cfheader name=Pragma value=no-cache cfheader name=cache-control value=no-cache, no-store, must-revalidate cfelse cfheader name=Expires value=cfoutput#NETSCAPEtimestamp#/cfoutput cfheader name=Pragma value=no-cache cfheader name=cache-control value=no-cache, no-store, must-revalidate /cfif Steven Semrau SRA International, Inc. Senior Member, Professional Staff [EMAIL PROTECTED] [EMAIL PROTECTED] Com: (703) 805-1095 DSN: (703) 655-1095 -Original Message- From: Haryono ... [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 9:29 PM To: CF-Talk Subject: refresh page Hallo, I want to ask something. I use cflocation to move to page editlecture.cfm. cflocation url=editlecture.cfm addtoken=No But at page editlecture.cfm, the content of editlecture.cfm not refresh. ( I use page editlecture.cfm to display list of lecture) Can you help me? ~~ 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: slightly OT ADO vs DAO
Cheers Andy, Its just I'm writing some VBA and gettings errors which I think are caused by using DAO syntax in a ADO database, but that doesn't make too much sense to me?? Cheers Will -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 14:41 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Yeh I think so. My use of DAO/ADO/RDO was through VB. Just used each to create connection and query objects and run them against the db. I'm not sure if you can choose which you want to use directly in Access although I haven't used Access for a While and things may have changed in 2000!) -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 14:30 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Thats how I saw it too. As I'm new to this side of things, can you tell me, is it possible to use both in an Access DB? Cheers Will -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 11:03 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Nick has got a point that there is no guarantee of support for DAO (or RDO come to that) but I can't see MS dropping uspport for something that ties in so closely with a db that is so widely used -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 10:58 To: CF-Talk Subject: RE: slightly OT ADO vs DAO DAO is a dead-end. ADO is more future-proof. Nick -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 10:51 AM To: CF-Talk Subject: slightly OT ADO vs DAO Hi all, I know this is slightly OT, but I wanted to get peoples opinions about ADO vs DAO in ACCESS2000. It's not something I'd looked at before to be honest, so was looking for general feedback, info on each etc, TIA Will ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: Syntax error or sharing violation
live = 0, should be live =0 no comma. -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 6:52 AM To: CF-Talk Subject: Syntax error or sharing violation can anyone here see what the problem with this statement is ? cfquery name=news datasource=cosmos1 dbtype=ODBC UPDATE waiting_room_news set headline = '#headline#', subtitle = '#subtitle#', body = '#body#', author = '#author#', expdate = '#expdate#', cfif #audience# EQ 'Keep old value' audience = '#oldaudience#' cfelse audience = '#audience#' /cfif, datestamp = '#date#', !---Set the approval field back to 0 --- live = 0, where id = #id# /cfquery This is the error message I am getting: Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (20:1) to (20:56). Date/Time: 04/26/01 14:50:44 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 95; DigExt) Remote Address: 129.153.207.20 HTTP Referer: http://uk1web2:8080/menutest/authorise/edit_news.cfm?id=5country=World Widecontent=news Template: E:\Inetpub\publicsite\menutest\authorise\edit_news_action.cfm Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [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: Syntax error or sharing violation
I've done this so many times! The comma in the last item is the culprit: live = 0, where id = #id# /cfquery Greg Creedon cf handyman for hire! Got something that needs getting done? Call the cf handyman! [EMAIL PROTECTED] -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 9:52 AM To: CF-Talk Subject: Syntax error or sharing violation can anyone here see what the problem with this statement is ? cfquery name=news datasource=cosmos1 dbtype=ODBC UPDATE waiting_room_news set headline = '#headline#', subtitle = '#subtitle#', body = '#body#', author = '#author#', expdate = '#expdate#', cfif #audience# EQ 'Keep old value' audience = '#oldaudience#' cfelse audience = '#audience#' /cfif, datestamp = '#date#', !---Set the approval field back to 0 --- live = 0, where id = #id# /cfquery This is the error message I am getting: Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (20:1) to (20:56). Date/Time: 04/26/01 14:50:44 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 95; DigExt) Remote Address: 129.153.207.20 HTTP Referer: http://uk1web2:8080/menutest/authorise/edit_news.cfm?id=5country=World Widecontent=news Template: E:\Inetpub\publicsite\menutest\authorise\edit_news_action.cfm Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [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: slightly OT ADO vs DAO
If you are using VBA you should be able to choose which connection method you use without any problem. As far as I can remember the code in the module/class you are creating is separate from the mdb.I'm not sure what you mean when you say in an ADO database. The database is just a database - ADO is purely used as a method of interogating it. As I said earlier - it's been a while since I used Access/VBA so may be way off! -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 15:10 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Cheers Andy, Its just I'm writing some VBA and gettings errors which I think are caused by using DAO syntax in a ADO database, but that doesn't make too much sense to me?? Cheers Will -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 14:41 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Yeh I think so. My use of DAO/ADO/RDO was through VB. Just used each to create connection and query objects and run them against the db. I'm not sure if you can choose which you want to use directly in Access although I haven't used Access for a While and things may have changed in 2000!) -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 14:30 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Thats how I saw it too. As I'm new to this side of things, can you tell me, is it possible to use both in an Access DB? Cheers Will -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 11:03 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Nick has got a point that there is no guarantee of support for DAO (or RDO come to that) but I can't see MS dropping uspport for something that ties in so closely with a db that is so widely used -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please
space in Cfinput problem PLEASE HELP
Hi! i am using cfinput to get the data for updation!. and i get only decimal values from the database , my users instead of keying in values like 1234 leave a blank space and enter like 1 234 which gives an error , suggest me and gimme the coding to avoid this situation , please gimme the coding for an alert! message if they key in data wrongly this is my code --- cfinput name=physicians_identified value=#ident_phys_result# type=text message=Physicians Identified needs to be a number between 0 and range=0, validate=integer REQUIRED=Yes - this is the error i get when they give the space in between . --- An unexpected token 2 was found following tier_1_ident_phys=1. Expected tokens may include: . SQLSTATE=42601 Please help -paul Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ ~~ 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
space in Cfinput problem PLEASE HELP
Hi! i am using cfinput to get the data for updation!. and i get only decimal values from the database , my users instead of keying in values like 1234 leave a blank space and enter like 1 234 which gives an error , suggest me and gimme the coding to avoid this situation , please gimme the coding for an alert! message if they key in data wrongly this is my code --- cfinput name=physicians_identified value=#ident_phys_result# type=text message=Physicians Identified needs to be a number between 0 and range=0, validate=integer REQUIRED=Yes - this is the error i get when they give the space in between . --- An unexpected token 2 was found following tier_1_ident_phys=1. Expected tokens may include: . SQLSTATE=42601 Please help -paul Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ ~~ 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: Syntax error or sharing violation
no comma after live=0 - Original Message - From: Darren Adams [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 26, 2001 9:52 AM Subject: Syntax error or sharing violation can anyone here see what the problem with this statement is ? cfquery name=news datasource=cosmos1 dbtype=ODBC UPDATE waiting_room_news set headline = '#headline#', subtitle = '#subtitle#', body = '#body#', author = '#author#', expdate = '#expdate#', cfif #audience# EQ 'Keep old value' audience = '#oldaudience#' cfelse audience = '#audience#' /cfif, datestamp = '#date#', !---Set the approval field back to 0 --- live = 0, where id = #id# /cfquery This is the error message I am getting: Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (20:1) to (20:56). Date/Time: 04/26/01 14:50:44 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 95; DigExt) Remote Address: 129.153.207.20 HTTP Referer: http://uk1web2:8080/menutest/authorise/edit_news.cfm?id=5country=World Widecontent=news Template: E:\Inetpub\publicsite\menutest\authorise\edit_news_action.cfm Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [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: using NT accounts for username/password login authentication
Matt, I have set up CFA with the new user Directory and I can see the LDAP schema with [Add/Remove Users for Policy LetThemIn from User Directory Distributors] and I have access to LDAP via the Account Managers account on our test LDAP server. I am thinking that I need to be more specific about Search Root, Lookup Start and Lookup End. I have; Search Root o=gmu.edu Lookup Start ((objectclass=* (uid=)) Lookup End ou=people,o=gmu.edu I have found some examples on the net but nothing specific in the manuals. I am following the examples in Chapter 6 of Allarie's Advanced Application Development manual on the server side setup and I am using their SuperGadgets templates for authentication. When I try to login to the SuperGadgets I get Error Diagnostic Information CFAuthenticate Tag Error. Invalid User 'dvadar' for Security Context 'Extranet'. (This is a valid user on our test LDAP server.) I have our email administrator is reviewing their LDAP environmental settings to see if they have some security settings that might be preventing my authentication attempts. We do have privacy flags for students that desire to not have any email and phone information to be made available. I have also used the CFLDAP tags and have been able to query the directory. I have also attempted to delete a test account with an account that did not have the appropriate access and I got an error message that the account had insufficient access. I did not proceed with CFLDAP because authentication through the server settings seemed to be a more appropriate method. With all that being said, I believe that I need to be more specific with the Lookup Start and Lookup End. Any insight that you could provide would be greatly appreciated. Jerre Matt Eschenbaum wrote: Set up the LDAP in the CFA as a new user Directory. You will need to point it to the LDAP server (via IP or Domain Name). You will need an account with sufficient privileges, search root, Lookup start, and the lookup end. You can then set a context to use the cfauthenticate tag. This can be time consuming but once done works rather well. Depending on your access to the LDAP server schema, you can also utilize the CFLDAP tag to authenticate as well as query for information on the server. Sincerely, Matthew M. Eschenbaum Allaire Certified Professional DevTech Inc. [EMAIL PROTECTED] 206.956.0888 www.dev-tech.com -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 1:21 PM To: CF-Talk Subject: RE: using NT accounts for username/password login authentication um...you did post to the list. :) ldap is a different animal. i've never really used it for authentication, besides Win2K's ACLs being LDAP-compliant. you're probably going to want to look into Advanced Security. it can use an LDAP database for suthentication. of course, it's a BEAST to setup. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Jerre Hale [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 3:52 PM To: CF-Talk Subject: Re: using NT accounts for username/password login authentication Chris, Sorry to respond to you this way. I subscribed to this list only today. I am looking for help on authenticating users against an ldap directory but have not quite gotten there yet and I cannot see how to post to the list. Any pointers on how to post to the list would be appreciated. Then I will be more descriptive in my question. Thanks, Jerre Christopher Olive, CIO wrote: if you're running IIS, just switch off anonymous access. users will be prompted for their NT password, and the ACL on that directory/file will take over. if they're not authorized, they get a 403.1 error. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Philip Humeniuk [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 12:09 PM To: CF-Talk Subject: Re: using NT accounts for username/password login authentication How would you go about accessing the NT accounts and use those username/password for login authentication rather than accessing an MS Access database? Has anyone done this before? ~~ 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: Syntax error or sharing violation
It's what you call extending functionality to an authoring tool and copying pages then deleting fields you dont want and accidentally living commas in. That is so infuriating !! -Original Message- From: Greg Creedon [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 15:06 To: CF-Talk Subject: RE: Syntax error or sharing violation I've done this so many times! The comma in the last item is the culprit: live = 0, where id = #id# /cfquery Greg Creedon cf handyman for hire! Got something that needs getting done? Call the cf handyman! [EMAIL PROTECTED] -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 9:52 AM To: CF-Talk Subject: Syntax error or sharing violation can anyone here see what the problem with this statement is ? cfquery name=news datasource=cosmos1 dbtype=ODBC UPDATE waiting_room_news set headline = '#headline#', subtitle = '#subtitle#', body = '#body#', author = '#author#', expdate = '#expdate#', cfif #audience# EQ 'Keep old value' audience = '#oldaudience#' cfelse audience = '#audience#' /cfif, datestamp = '#date#', !---Set the approval field back to 0 --- live = 0, where id = #id# /cfquery This is the error message I am getting: Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (20:1) to (20:56). Date/Time: 04/26/01 14:50:44 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 95; DigExt) Remote Address: 129.153.207.20 HTTP Referer: http://uk1web2:8080/menutest/authorise/edit_news.cfm?id=5country=World Widecontent=news Template: E:\Inetpub\publicsite\menutest\authorise\edit_news_action.cfm Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [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: Syntax error or sharing violation
ARRRGGG Talk about not seeing the wood for the trees !! dont you justy hate it when you get silly little things like that ? -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 15:08 To: CF-Talk Subject: RE: Syntax error or sharing violation live = 0, should be live =0 no comma. -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 6:52 AM To: CF-Talk Subject: Syntax error or sharing violation can anyone here see what the problem with this statement is ? cfquery name=news datasource=cosmos1 dbtype=ODBC UPDATE waiting_room_news set headline = '#headline#', subtitle = '#subtitle#', body = '#body#', author = '#author#', expdate = '#expdate#', cfif #audience# EQ 'Keep old value' audience = '#oldaudience#' cfelse audience = '#audience#' /cfif, datestamp = '#date#', !---Set the approval field back to 0 --- live = 0, where id = #id# /cfquery This is the error message I am getting: Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (20:1) to (20:56). Date/Time: 04/26/01 14:50:44 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 95; DigExt) Remote Address: 129.153.207.20 HTTP Referer: http://uk1web2:8080/menutest/authorise/edit_news.cfm?id=5country=World Widecontent=news Template: E:\Inetpub\publicsite\menutest\authorise\edit_news_action.cfm Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [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: slightly OT ADO vs DAO
Well, thats what I thought too, to be honest, but a more experienced VBA developer than me said the errors were due to this difference between DAO and ADO. I will try using ADO syntax and see if that works. Thanks for all your input Andy Will -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 15:15 To: CF-Talk Subject: RE: slightly OT ADO vs DAO If you are using VBA you should be able to choose which connection method you use without any problem. As far as I can remember the code in the module/class you are creating is separate from the mdb.I'm not sure what you mean when you say in an ADO database. The database is just a database - ADO is purely used as a method of interogating it. As I said earlier - it's been a while since I used Access/VBA so may be way off! -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 15:10 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Cheers Andy, Its just I'm writing some VBA and gettings errors which I think are caused by using DAO syntax in a ADO database, but that doesn't make too much sense to me?? Cheers Will -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 14:41 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Yeh I think so. My use of DAO/ADO/RDO was through VB. Just used each to create connection and query objects and run them against the db. I'm not sure if you can choose which you want to use directly in Access although I haven't used Access for a While and things may have changed in 2000!) -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 14:30 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Thats how I saw it too. As I'm new to this side of things, can you tell me, is it possible to use both in an Access DB? Cheers Will -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 11:03 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Nick has got a point that there is no guarantee of support for DAO (or RDO come to that) but I can't see MS dropping uspport for something that ties in so closely with a db that is so widely used -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or
Security Question - Revisited
Good day all, Yesterday, Joshua Meekhof suggested using the hash() function to hash up user passwords before inserting them into the database. Seems like this would work. However, when I try it, it fails. Maybe I am doing something wrong. Here is the code: Password: input type=password name=password This goes to action page: cfset hashedpword=hash(form.password) cfquery name=update datasource=#request.mainDSN# UPDATE users SET password='#hashedpword#' WHERE userID=#form.userID# /cfquery Finally, on the login page I pass the plain text password to the login action page, which has this code: cfset hashedpword=hash(form.password) cfquery name=checkuser datasource=#request.mainDSN# SELECT * FROM users WHERE userName='#form.userName#' AND password='#hashedpword#' /cfquery This query returns no records. Does the hash() function return a random value? If so, Joshua, how do you compare the user's login to what you have in the DB? Any help in this regard would be appreciated. Thanks. Marwan Saidi Webmaster CED - Concord IS [EMAIL PROTECTED] 407.741.8645 ** 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. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.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: using variable list from a multiple select/form (warning: lon g)
Something like
WHERE Users.UserId IN (#ListQualify(form.NOTIFY,')#)
And then
cfset Dear = ValueList(Users.Username)
-David
On Thursday, April 26, 2001 6:48 AM, [EMAIL PROTECTED]
[SMTP:[EMAIL PROTECTED]] wrote:
This works great if only one choice is selected. But it chokes on multiple
choices. The query runs right, but comes back with zero records found.
Say the call taker chooses OSAAH and RBOLTON from the email notify list. In
this case #form.notify# equals 'OSAAH,RBOLTON' so iMIS is looking for
'OSAAH,RBOLTON' and coming up empty. How do it get it to look for 'OSAAH'
AND 'RBOLTON'? And then report the two UserName(s) back to go together in
the Dear __ line of the email as #Dear#? The rest of the code generates one
email that goes to both recipients.
:-)
Oriole
In a message dated Wed, 25 Apr 2001 7:19:46 PM Eastern Daylight Time, Matt
Eschenbaum [EMAIL PROTECTED] writes:
Your trying to do to many loops. Try this and let me know if works for
you.
CFLOOP INDEX=get_count
LIST=#form.notify#
CFQUERY NAME=notify_email DATASOURCE=iMIS Enterprise
SELECT Users.UserName
FROM Users Users
WHERE (Users.UserId='#form.NOTIFY#')
/cfquery
cfset Dear = Users.Username
!--- CFMAIL FROM=[EMAIL PROTECTED]
TO=#form.notify#@dineout.org
SUBJECT=Help Desk Request for Follow-up
SERVER=mail.dineout.org
Dear #Dear# !--- this doesn't work right, just yet -- but it will ---
/cfloop
Sincerely,
Matthew M. Eschenbaum
Allaire Certified Professional
DevTech Inc.
[EMAIL PROTECTED]
206.956.0888
www.dev-tech.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 3:45 PM
To: CF-Talk
Subject: using variable list from a multiple select/form (warning: long)
Hello all,
I am having trouble using a particular variable. This is a long email
because I am trying to provide enough information to give a clear picture of
my problem (which is probably quite simple and I probably should be able to
solve it on my own ...)
I have a form variable (called NOTIFY) which comes from a drop-down option
(dynamically populated) which allows for multiple choices. The variable
arrives on the action page (where the data is inserted in a table, that
works
no problem) as a comma delimited list. Once it arrives at the action page,
it
serves two functions. It's email address creation function works
beautifully. But then I need to use it to query our membership database to
pull out the actual name of the person so that the email message is more
user
friendly ... (the CN in an email address just won't do for Dear , you
know how that goes).
What I think I need to do it
1. Count the number of items in the list
2. Run it through a list loop to parse each item out as a separate variable
3. Run the query to the membership database to get the UserNames, using the
newly created variables.
4. Run it through a query to put it back in a new variable for output in the
single email that is generated.
But I don't know how to count the items or run the list loop. Can you help
me?
Here's the code for the select from the form, populated by an earlier query:
SELECT NAME=NOTIFY
SIZE=8
MULTIPLE
CFOUTPUT QUERY=notify
OPTION VALUE=#NOTIFY##NOTIFY#
/cfoutput
OPTION VALUE= No Report
/SELECT
And this is what I have in the action form, so far:
!--- First, test to see if the call taker has chosen to notify anyone. If
no notification targets have been selected, the CFMAIL tag will be skipped.
---
CFIF IsDefined('form.NOTIFY')
!--- Query to convert NOTIFY from the iMIS UserID to the UserName for a
more
user-friendly message in the email ---
CFLOOP INDEX=get_count
LIST=#form.notify#
DELIMITERS=,
/CFLOOP
CFOUTPUT
#get_count.RecordCount#
/CFOUTPUT
CFSET to=#get_count.RecordCount#)
CFLOOP INDEX=notify_emal
FROM=1
TO=#to#
CFQUERY NAME=notify_email DATASOURCE=iMIS Enterprise
SELECT Users.UserName
FROM Users Users
WHERE (Users.UserId='#form.NOTIFY#')
/cfquery
/CFLOOP
CFSET Dear=
CFLOOP QUERY=who_to_notify
CFSET Dear=ListAppend(Dear, '#who_to_notify.UserName#')
/CFLOOP
!--- Loops over CFMAIL tag so that multiple email recipients can be
inserted
---
CFLOOP INDEX=Notify_whom
LIST=Notify
DELIMITERS=, (closes at the end of the mail, I have not included
all of that...)
!--- Mails follow-up request/notification to all selected staff members,
based on iMIS UserID selected in the users/NOTIFY field of the form ---
!--- CFMAIL FROM=[EMAIL PROTECTED]
TO=#form.notify#@dineout.org
SUBJECT=Help Desk Request for Follow-up
SERVER=mail.dineout.org
Dear #Dear# !--- this doesn't work right, just yet -- but it will ---
@@@
Help!!
RE: space in Cfinput problem PLEASE HELP
Here is a JS I use to validate only numbers:
function errHandler(txt) {
alert(txt);
}
function checkNum(field) {
var validChars=0123456789;
var temp;
for(i=0; i field.value.length; i++) {
temp = + field.value.substring(i, i+1);
if (validChars.indexOf(temp) == -1) {
field.value='';
field.focus();
errHandler(Numbers are only allowed in this field.);
}
}
}
Then on your form tag input
input type=text name=firstNumbers size=7 maxlength=7 value=
style=text-align: right; onkeyup=checkNum(this)
Steven Semrau
SRA International, Inc.
Senior Member, Professional Staff
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Com: (703) 805-1095
DSN: (703) 655-1095
-Original Message-
From: paul . [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 26, 2001 10:23 AM
To: CF-Talk
Subject: space in Cfinput problem PLEASE HELP
Hi!
i am using cfinput to get the data for updation!.
and i get only decimal values from the database , my users instead of keying
in values like 1234 leave a blank space and enter like
1 234
which gives an error , suggest me and gimme the coding to avoid this
situation , please gimme the coding for an alert! message if they key in
data wrongly
this is my code
---
cfinput name=physicians_identified value=#ident_phys_result#
type=text message=Physicians Identified needs to be a number between 0
and range=0, validate=integer REQUIRED=Yes
-
this is the error i get when they give the space in between .
---
An unexpected token 2 was found following tier_1_ident_phys=1. Expected
tokens may include: . SQLSTATE=42601
Please help
-paul
Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
~~
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: Random form variables problem
I'll try to do. Tks Abe ~~ 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: slightly OT ADO vs DAO
What he probably means is that you have a mixture of ADO and DAO syntax in your VBA. If you create a connection object using DAO then all other code using this connection object needs to be DAO. If you do this I can't see there being a problem -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 15:41 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Well, thats what I thought too, to be honest, but a more experienced VBA developer than me said the errors were due to this difference between DAO and ADO. I will try using ADO syntax and see if that works. Thanks for all your input Andy Will -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 15:15 To: CF-Talk Subject: RE: slightly OT ADO vs DAO If you are using VBA you should be able to choose which connection method you use without any problem. As far as I can remember the code in the module/class you are creating is separate from the mdb.I'm not sure what you mean when you say in an ADO database. The database is just a database - ADO is purely used as a method of interogating it. As I said earlier - it's been a while since I used Access/VBA so may be way off! -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 15:10 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Cheers Andy, Its just I'm writing some VBA and gettings errors which I think are caused by using DAO syntax in a ADO database, but that doesn't make too much sense to me?? Cheers Will -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 14:41 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Yeh I think so. My use of DAO/ADO/RDO was through VB. Just used each to create connection and query objects and run them against the db. I'm not sure if you can choose which you want to use directly in Access although I haven't used Access for a While and things may have changed in 2000!) -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly
RE: cf server certification
My understanding of the CF server licenses (professional or enterprise) is that it is a *per computer* license. So, if you want to install CF on multiple machines, you need to buy multiple copies. HTH, Evan -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 5:39 AM To: CF-Talk Subject: cf server certification Does anybody know how the cf server professional is certified? i.e. per installation on computer or if a company buys it, it can be installed any number of types? thanks! = Heidi Belal ICQ# 32127109 http://m3.easyspace.com/hmbelal A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ 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: slightly OT ADO vs DAO
You can use either ysntax but you have to add a reference to the ado or dao library in the project in the sam way as you do for a vb project. Go to tools references and choose one or both. -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 15:41 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Well, thats what I thought too, to be honest, but a more experienced VBA developer than me said the errors were due to this difference between DAO and ADO. I will try using ADO syntax and see if that works. Thanks for all your input Andy Will -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 15:15 To: CF-Talk Subject: RE: slightly OT ADO vs DAO If you are using VBA you should be able to choose which connection method you use without any problem. As far as I can remember the code in the module/class you are creating is separate from the mdb.I'm not sure what you mean when you say in an ADO database. The database is just a database - ADO is purely used as a method of interogating it. As I said earlier - it's been a while since I used Access/VBA so may be way off! -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 15:10 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Cheers Andy, Its just I'm writing some VBA and gettings errors which I think are caused by using DAO syntax in a ADO database, but that doesn't make too much sense to me?? Cheers Will -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 14:41 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Yeh I think so. My use of DAO/ADO/RDO was through VB. Just used each to create connection and query objects and run them against the db. I'm not sure if you can choose which you want to use directly in Access although I haven't used Access for a While and things may have changed in 2000!) -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 14:30 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Thats how I saw it too. As I'm new to this side of things, can you tell me, is it possible to use both in an Access DB? Cheers Will -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 11:03 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Nick has got a point that there is no guarantee of support for DAO (or RDO come to that) but I can't see MS dropping uspport for something that ties in so closely with a db that is so widely used -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890
Report
Hi Every one, I have an access table having 3 fields Date, Quantity and Amount. I am working on a report where I have to calculate the Quantity and Amount on quarterly bases for last year and this year. I tried using the function Quarter but an unable to reach any solution.Please help!! Thanks in advance Shally. ~~ 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: Syntax error or sharing violation
I don't think that you need single quotes around the Date, additionally try formatting the date using CreateODBCDate(date). Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 6:52 AM To: CF-Talk Subject: Syntax error or sharing violation can anyone here see what the problem with this statement is ? cfquery name=news datasource=cosmos1 dbtype=ODBC UPDATE waiting_room_news set headline = '#headline#', subtitle = '#subtitle#', body = '#body#', author = '#author#', expdate = '#expdate#', cfif #audience# EQ 'Keep old value' audience = '#oldaudience#' cfelse audience = '#audience#' /cfif, datestamp = '#date#', !---Set the approval field back to 0 --- live = 0, where id = #id# /cfquery This is the error message I am getting: Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (20:1) to (20:56). Date/Time: 04/26/01 14:50:44 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 95; DigExt) Remote Address: 129.153.207.20 HTTP Referer: http://uk1web2:8080/menutest/authorise/edit_news.cfm?id=5country=World Widecontent=news Template: E:\Inetpub\publicsite\menutest\authorise\edit_news_action.cfm Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [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: Security Question - Revisited
Marwan, Here's how I take care of the situation. The database field that stores your password needs to be a 32 (var)character. When validating a user I select based upon the username only, and then I compare the database password with the hashed user password. Something like the following is how I use this: cfif qryPersonGet.recordcount AND NOT Compare(qryPersonGet.password, Hash(trim(form.password))) !--- Set session variables here...--- /cfif Josh ~~ 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: Netscape 6
And people wunder why no one bothers to suport it :-) -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: 25 April 2001 14:52 To: CF-Talk Subject: RE: Netscape 6 That is a known bug in Netscape 6. The latest updates have not yet fixed the problem. Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Mike Provoost [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 12:47 AM To: CF-Talk Subject: Netscape 6 Has anyone else had problems with coldfusion and netscape 6? For some reason, it seems to lose form vars when they're passed to the action page. My code works in Netscape 4.x and IE so I know it's not a code issue. Has anyone else had this problem? Thanks in Advance. -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: Report
Considering you didn't paste any errors that you have received with this the first thing I suggest you do is change the name of your date field from 'Date' to something else like 'myDate'. 'Date' is a reserved word in SQL and frequently causes problems because Access will not warn you of this when you are creating a table. Chris -Original Message- From: Shally [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 10:05 AM To: CF-Talk Subject: Report Hi Every one, I have an access table having 3 fields Date, Quantity and Amount. I am working on a report where I have to calculate the Quantity and Amount on quarterly bases for last year and this year. I tried using the function Quarter but an unable to reach any solution.Please help!! Thanks in advance Shally. ~~ 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: Contact Management App.
MS Access 2000 will create the data source for you. It's a wizard option. You just create the code to match their Script At 01:36 AM 4/26/2001 -0700, you wrote: Anyone know of a CF contact app? basic profile.contact info? ..brian ~~ 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
uploading multiple files
Hi all-- I have a form that uses multiple cffile action=upload to upload multiple files(images and PDFs). In the past, when using cffile I have used 'file.clientFile' to save the file name so that I can read the correct file later from a known directory. If I am uploading multiple files on one form, how do I know which name goes with which file? thanks in advance for any help :) ~~ 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: Security Question - Revisited
I have not used the hash function but this is the code straight from allaires website: CFIF Hash(Form.Password) IS NOT MyQuery.PasswordHash CFLOCATION URL=unauthenticated.cfm /CFIF I beleive your code should work. Do you have CF Server 4.5? (use #server.coldfusion.productversion# to find the version of CF Server) -Original Message- From: Saidi; Marwan [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 7:40 AM To: CF-Talk Subject: Security Question - Revisited Good day all, Yesterday, Joshua Meekhof suggested using the hash() function to hash up user passwords before inserting them into the database. Seems like this would work. However, when I try it, it fails. Maybe I am doing something wrong. Here is the code: Password: input type=password name=password This goes to action page: cfset hashedpword=hash(form.password) cfquery name=update datasource=#request.mainDSN# UPDATE users SET password='#hashedpword#' WHERE userID=#form.userID# /cfquery Finally, on the login page I pass the plain text password to the login action page, which has this code: cfset hashedpword=hash(form.password) cfquery name=checkuser datasource=#request.mainDSN# SELECT * FROM users WHERE userName='#form.userName#' AND password='#hashedpword#' /cfquery This query returns no records. Does the hash() function return a random value? If so, Joshua, how do you compare the user's login to what you have in the DB? Any help in this regard would be appreciated. Thanks. Marwan Saidi Webmaster CED - Concord IS [EMAIL PROTECTED] 407.741.8645 ** 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. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.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: Syntax error or sharing violation
It's the comma after your live=0 line live = 0, where id = #id# -Original Message- From: Garza, Jeff [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 8:09 AM To: CF-Talk Subject: RE: Syntax error or sharing violation I don't think that you need single quotes around the Date, additionally try formatting the date using CreateODBCDate(date). Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 6:52 AM To: CF-Talk Subject: Syntax error or sharing violation can anyone here see what the problem with this statement is ? cfquery name=news datasource=cosmos1 dbtype=ODBC UPDATE waiting_room_news set headline = '#headline#', subtitle = '#subtitle#', body = '#body#', author = '#author#', expdate = '#expdate#', cfif #audience# EQ 'Keep old value' audience = '#oldaudience#' cfelse audience = '#audience#' /cfif, datestamp = '#date#', !---Set the approval field back to 0 --- live = 0, where id = #id# /cfquery This is the error message I am getting: Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (20:1) to (20:56). Date/Time: 04/26/01 14:50:44 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 95; DigExt) Remote Address: 129.153.207.20 HTTP Referer: http://uk1web2:8080/menutest/authorise/edit_news.cfm?id=5country=World Widecontent=news Template: E:\Inetpub\publicsite\menutest\authorise\edit_news_action.cfm Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [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: uploading multiple files
i do this a lot. in your form, CFLOOP to create each upload form element. use the INDEX value as part of each form element name. then, in the code that handles the form, CFLOOP over the name of each form element using Evaluate() to get the actual value of each var name. -Original Message- From: Susan Matthews [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 9:04 AM To: CF-Talk Subject: uploading multiple files Hi all-- I have a form that uses multiple cffile action=upload to upload multiple files(images and PDFs). In the past, when using cffile I have used 'file.clientFile' to save the file name so that I can read the correct file later from a known directory. If I am uploading multiple files on one form, how do I know which name goes with which file? thanks in advance for any help :) ~~ 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: SQL UPDATE
Thanks Joeseph and Brian, Im really close nowwhats happening is the SubQuery is returning more than 1 row which wont work. If I put a MAX(Date1) it works but I get incorrect results. I get the MAX date for ALL the REFNO instead of just the single set. Any ideas how to get around that? I should have included a better data example prior, I modified it below. ID REFNO DATE1 1 123 04/25/2001 2 123 null 3 123 null 4 222 04/26/2001 5 222 null 6 222 null 7 333 04/27/2001 8 333 null So basically I want Null DATE1 for REFNO = 123 to be 04/25/2001 AND the Null DATE1 for REFNO = 222 to be 04/26/2001. I have several thousands of records like this and would like to do it in a single pass, in fact Ill need to run this thing daily. Im trying this now but get multiple results from the SubQuery: UPDATE mytable SET DATE1 = (SELECT DATE1 FROM mytable WHERE REFNO = REFNO ANDDATE1 IS NOT NULL) WHERE DATE1 IS NULL -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] If there are many fields you'll need this instead: UPDATE mytable m SET DATE1 = (SELECT DATE1 FROM mytable t WHERE m.REFNO = t.REFNO ANDDATE1 IS NOT NULL) WHERE DATE1 IS NULL I'm not sure if you can alias a table in an UPDATE statement, but I think you can Bryan Love ACP -Original Message- From: Cruz, Joseph [mailto:[EMAIL PROTECTED]] UPDATE mytable SET DATE1 = (SELECT DATE1 FROM mytable WHERE REFNO = 123 ANDID = 1) WHERE DATE1 IS NULL That should do it for you. As long as the subquery returns only one row, this will work. Joe ~~ 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
dll to correct 100%CPU due to messages in /mail/spool/
I recall a while ago there was a .dll which was supposed to correct a problem with undelivered messages in C:\CFUSION\\mail\spool\ causing CFServer to use use 100% of the CPU time. Can someone point me to it? I tried searching the archives to no avail _ Get your FREE download of MSN Explorer at http://explorer.msn.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Win2K TCP/IP on road
Use netswitcher work great for that purpose. http://www.netswitcher.com Thank You, Peter Peter J. MacDonald II Creative Computing, Inc. 100 Middle Street Lincoln, RI 02865 Phone: 401.727.0183 x123 Fax: 401.727.4998 Portable: 401.965.3661 E-MAIL: [EMAIL PROTECTED] Web Page: www.creatcomp.com -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 21, 2001 3:30 PM To: CF-Talk Subject: OT: Win2K TCP/IP on road When I am on the road I need to configure TCP/IP to use DHCP but when I am home I need to use static ip. Is there any way to keep these two configurations so I don't have reenter ip everytime I change. I have tried using different hardware profiles but since I am using same adapter the change of ip propagates through all profiles when I change it. TIA ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Triggers?
Perfect. I didn't think you could do anything command-line. Neat. Anyone care to make it easy for me and tell me how to do it with Oracle 8? I also figured you could have a scheduled cf job that looked for some kind of flag in a db table that was updated by a stored procedure... You would have to have SQL server and Cold Fusion on the same machine, but, using a trigger to fire off xp_cmdshell and then running c:\cfusion\cfml.exe you could fire off a template. Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 10:17 AM To: CF-Talk Subject: CF Triggers? Has anyone thought of a way to fire off processing of a CF template from a database event? Just like a regular DB Triggering a Stored Procedure, but instead calling a CF template? What can regular triggers do? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange ~~ 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: uploading multiple files
you will use CFFILE in each iteration of the CFLOOP in the code that handles the original form. so from each CFFILE iteration, you get the file name of each uploaded file. -Original Message- From: Susan Matthews [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 10:41 AM To: CF-Talk Subject: RE: uploading multiple files Thank you. I'm not as familiar w/ file.clientFile as I should be. It may not even be what I need in this situation First form: cfloop index=x from=1 to=3 trtd valign=top cfif x is 1 bLarge Image:/b cfelseif x is 2 bThumbnail Image:/b cfelseif x is 3 bPrintable Version:/b /cfif /td tdinput type=File name=file_#x# size=25/td /tr /cfloop Then, in the receiving form... I understand how to loop thru and upload each file; but, I then need to save the name of each file in a single record to be read later. So, I have file_1, file_2, file_3. How do I get the actual file name of each one? (ex:myPicture.gif) Thank you!!! -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 12:26 PM To: CF-Talk Subject: RE: uploading multiple files i do this a lot. in your form, CFLOOP to create each upload form element. use the INDEX value as part of each form element name. then, in the code that handles the form, CFLOOP over the name of each form element using Evaluate() to get the actual value of each var name. -Original Message- From: Susan Matthews [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 9:04 AM To: CF-Talk Subject: uploading multiple files Hi all-- I have a form that uses multiple cffile action=upload to upload multiple files(images and PDFs). In the past, when using cffile I have used 'file.clientFile' to save the file name so that I can read the correct file later from a known directory. If I am uploading multiple files on one form, how do I know which name goes with which file? thanks in advance for any help :) ~~ 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: New CF5 Partner Hosting License
Here's a real interesting line from the announcement: The ColdFusion 5 Enterprise and Pro End-User License will no longer permit multiple ColdFusion applications and/or sites to be hosted on a single ColdFusion server. What the heck does this mean? What is the definitiion of multiple CF applications? If I create more than one application on a server then I need to pay more $$$? Howie - Original Message - From: Dylan Bromby [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 26, 2001 1:55 PM Subject: RE: New CF5 Partner Hosting License wow. i'm not sure this is a good idea. if macromedia increases the cost of CF dramatically, it makes it easier to choose alternatives whether they're free or in the same price range of whatever the pricing under these new terms turns out to be. -Original Message- From: Chris Colón [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 10:39 AM To: CF-Talk Subject: New CF5 Partner Hosting License Allaire's Partners just received an email announcing ColdFusion Server 5 Hosting Service Provider Edition, which consists of a new End-User License for commercial hosting service providers. The gist of it is that Hosting Providers will now be charged extra for the privilege of running multiple CF sites on a shared server. As far as I can tell, all the new features of CF5 will be in the Enterprise edition, so the only difference between Enterprise and Hosting is that the latter will cost more. Some value. I sent Allaire an email registering my strong disapproval of this new hosting partner penalty fee, pointing out that GoTech is already subjected to marketplace pressures due to the free nature of Microsoft's Active Server Page (ASP) technology, and Allaire/Macromedia's continual ratcheting up of ColdFusion's price is potentially debilitating to our efforts to deploy your product. Perhaps they see their only competition in the BEA/WebLogic/IBM/Oracle application server space. This may be the case for Enterprise, but there's no way this is the case with hosting providers. We're competing in the trenches with ASP, which is free on NT/2000, and at some point the benefits of the CF environment will be outweighed by its cost... Maybe I'm just jumping to conclusions, and this is actually (somehow) a benfit to hosting partners. Thoughts? ~~ 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: database.ldb
Jay, One trick you can do is create an empty database file in Access. Then use link tables under the FILE GET EXTERNAL DATA LINK TABLES menu option to link the blank database with your database.. Then select whatever tables you need to be linked. After that if you need to change tables etc, you do not have to worry about having to work with .ldb files etc. hth, larry -- Larry C. Lyons ColdFusion/Web Developer EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- Jay Patton wrote: thanks guys/gals i should have said that im not the host of this particular site so i cant reboot and fix it or use the release button in the administrator either... sorry about that. i got it though thanks again (this is why i dont use access) Jay Patton ~~ 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
ORACLE DATE INSERT ERROR.. Help.
I'm trying to insert a date into an Oracle table and get the following
error. Help!!
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Oracle][ODBC Oracle Driver][Oracle OCI]ORA-00917: missing comma.
SQL = INSERT INTO emirf (FIRST_NAME, REQUEST_DATE, LAST_NAME) VALUES (
'Lisa',to_date('26-Apr-2001','DD-MMM-','Lisa' )
Data Source = ADMS
Here is the CF code:
cfquery name=requestInsert datasource=#Application.SMInfo#
INSERT INTO emirf
(FIRST_NAME, REQUEST_DATE, LAST_NAME)
VALUES (
'#form.first_name#',to_date('#DateFormat(Now(),'DD-MMM-')#','DD-MMM-
','#form.last_name#') /cfquery
~~
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: New CF5 Partner Hosting License
The newsgroups and mailing lists are always full of people searching for decent good value CF hosting, if this makes it more difficult for companies to offer that service it could be very bad news for CF. - Original Message - From: Dylan Bromby [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 26, 2001 6:55 PM Subject: RE: New CF5 Partner Hosting License wow. i'm not sure this is a good idea. if macromedia increases the cost of CF dramatically, it makes it easier to choose alternatives whether they're free or in the same price range of whatever the pricing under these new terms turns out to be. -Original Message- From: Chris Colón [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 10:39 AM To: CF-Talk Subject: New CF5 Partner Hosting License Allaire's Partners just received an email announcing ColdFusion Server 5 Hosting Service Provider Edition, which consists of a new End-User License for commercial hosting service providers. The gist of it is that Hosting Providers will now be charged extra for the privilege of running multiple CF sites on a shared server. As far as I can tell, all the new features of CF5 will be in the Enterprise edition, so the only difference between Enterprise and Hosting is that the latter will cost more. Some value. I sent Allaire an email registering my strong disapproval of this new hosting partner penalty fee, pointing out that GoTech is already subjected to marketplace pressures due to the free nature of Microsoft's Active Server Page (ASP) technology, and Allaire/Macromedia's continual ratcheting up of ColdFusion's price is potentially debilitating to our efforts to deploy your product. Perhaps they see their only competition in the BEA/WebLogic/IBM/Oracle application server space. This may be the case for Enterprise, but there's no way this is the case with hosting providers. We're competing in the trenches with ASP, which is free on NT/2000, and at some point the benefits of the CF environment will be outweighed by its cost... Maybe I'm just jumping to conclusions, and this is actually (somehow) a benfit to hosting partners. Thoughts? ~~ 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: New CF5 Partner Hosting License
wow. i'm not sure this is a good idea. if macromedia increases the cost of CF dramatically, it makes it easier to choose alternatives whether they're free or in the same price range of whatever the pricing under these new terms turns out to be. Or makes it easier to not use the technology at all. Look at the effect of their price increases on the use of Generator. ~~ 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
javascript frame refresh function for IE4.07
Hi all
This might be a bit of a shot in the dark, but heres hoping.
I'm using the function below to autorefresh a nav bar upon login to provide
a customised menu depending upon access.
SCRIPT LANGUAGE=JavaScript
function UpdateNavBar(){
parent.left.window.location.href=http://127.0.0.1/travel/home/nav.cfm;;
return true;
}
/SCRIPT
BODY topmargin=8 onLoad=UpdateNavBar();
The trouble is it works fine on IE 5, but the client reporteed that dosn't
work (they use IE4.07).
Does anyone know a function which will??
TIA
Mark
Mark Smyth
Developer
Systems Union eBusiness Solutions
01865 880800
[EMAIL PROTECTED]
www.systemsunion.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: New CF5 Partner Hosting License
Here's a real interesting line from the announcement: The ColdFusion 5 Enterprise and Pro End-User License will no longer permit multiple ColdFusion applications and/or sites to be hosted on a single ColdFusion server. What the heck does this mean? What is the definitiion of multiple CF applications? If I create more than one application on a server then I need to pay more $$$? If that's true, we won't be moving to CF5. Sorry, Macromedia, but that would be a bad, bad licensing ploy on your part. I'm sure we're not unique in hosting about 20 CF sites of our own on one server. Ron Allen Hornbaker President/CTO Humankind Systems, Inc. http://humankindsystems.com mailto:[EMAIL PROTECTED] ..¸_¸.·´¯) http://www.BookCrossing.com ~ Read and Release! (¯`·.¸_¸. ~~ 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: New CF5 Partner Hosting License
Anyone seen a pricing structure for cf5? We're going to feel pretty ackward if they actually lower the prices. ;-) If not, then I agree with you. -Original Message- From: Chris Colón [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 12:39 PM To: CF-Talk Subject: New CF5 Partner Hosting License Allaire's Partners just received an email announcing ColdFusion Server 5 Hosting Service Provider Edition, which consists of a new End-User License for commercial hosting service providers. The gist of it is that Hosting Providers will now be charged extra for the privilege of running multiple CF sites on a shared server. As far as I can tell, all the new features of CF5 will be in the Enterprise edition, so the only difference between Enterprise and Hosting is that the latter will cost more. Some value. I sent Allaire an email registering my strong disapproval of this new hosting partner penalty fee, pointing out that GoTech is already subjected to marketplace pressures due to the free nature of Microsoft's Active Server Page (ASP) technology, and Allaire/Macromedia's continual ratcheting up of ColdFusion's price is potentially debilitating to our efforts to deploy your product. Perhaps they see their only competition in the BEA/WebLogic/IBM/Oracle application server space. This may be the case for Enterprise, but there's no way this is the case with hosting providers. We're competing in the trenches with ASP, which is free on NT/2000, and at some point the benefits of the CF environment will be outweighed by its cost... Maybe I'm just jumping to conclusions, and this is actually (somehow) a benfit to hosting partners. Thoughts? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ORACLE DATE INSERT ERROR.. Help.
Your parenthesis are incorrect... your CF code should be this
cfquery name=requestInsert datasource=#Application.SMInfo#
INSERT INTO emirf
(FIRST_NAME, REQUEST_DATE, LAST_NAME)
VALUES (
'#form.first_name#',
to_date('#DateFormat(Now(),'DD-MMM-')#','DD-MMM-'),
'#form.last_name#')
/cfquery
you missed the closing parenthesis on the to_date() function
-Original Message-
From: Greenberg, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 26, 2001 1:31 PM
To: CF-Talk
Subject: ORACLE DATE INSERT ERROR.. Help.
I'm trying to insert a date into an Oracle table and get the following
error. Help!!
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Oracle][ODBC Oracle Driver][Oracle OCI]ORA-00917: missing comma.
SQL = INSERT INTO emirf (FIRST_NAME, REQUEST_DATE, LAST_NAME) VALUES (
'Lisa',to_date('26-Apr-2001','DD-MMM-','Lisa' )
Data Source = ADMS
Here is the CF code:
cfquery name=requestInsert datasource=#Application.SMInfo#
INSERT INTO emirf
(FIRST_NAME, REQUEST_DATE, LAST_NAME)
VALUES (
'#form.first_name#',to_date('#DateFormat(Now(),'DD-MMM-')#','DD-MMM-
','#form.last_name#') /cfquery
~~
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: New CF5 Partner Hosting License
At 14:19 26/04/01 -0400 Howie Hamlin said Here's a real interesting line from the announcement: The ColdFusion 5 Enterprise and Pro End-User License will no longer permit multiple ColdFusion applications and/or sites to be hosted on a single ColdFusion server. What the heck does this mean? What is the definitiion of multiple CF applications? If I create more than one application on a server then I need to pay more $$$? Does this mean they may be pricing it to handle one application per Domain. Along the lines of some mail servers where you pay more to handle multiple Domains? I do not see how else they can differentiate Multiple Cold Fusion applications. It is the or sites that sounds like this is what they mean. Or am I way off track. Perhaps the base price will be less and you purchase a 10/20/50 or whatever Domains licence as required? Certainly sounds like a major change. Gordon ~~ 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: uploading multiple files
ohhh. Who knows what I was thinking. Thank you for your help! :) -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 2:15 PM To: CF-Talk Subject: RE: uploading multiple files you will use CFFILE in each iteration of the CFLOOP in the code that handles the original form. so from each CFFILE iteration, you get the file name of each uploaded file. -Original Message- From: Susan Matthews [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 10:41 AM To: CF-Talk Subject: RE: uploading multiple files Thank you. I'm not as familiar w/ file.clientFile as I should be. It may not even be what I need in this situation First form: cfloop index=x from=1 to=3 trtd valign=top cfif x is 1 bLarge Image:/b cfelseif x is 2 bThumbnail Image:/b cfelseif x is 3 bPrintable Version:/b /cfif /td tdinput type=File name=file_#x# size=25/td /tr /cfloop Then, in the receiving form... I understand how to loop thru and upload each file; but, I then need to save the name of each file in a single record to be read later. So, I have file_1, file_2, file_3. How do I get the actual file name of each one? (ex:myPicture.gif) Thank you!!! -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 12:26 PM To: CF-Talk Subject: RE: uploading multiple files i do this a lot. in your form, CFLOOP to create each upload form element. use the INDEX value as part of each form element name. then, in the code that handles the form, CFLOOP over the name of each form element using Evaluate() to get the actual value of each var name. -Original Message- From: Susan Matthews [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 9:04 AM To: CF-Talk Subject: uploading multiple files Hi all-- I have a form that uses multiple cffile action=upload to upload multiple files(images and PDFs). In the past, when using cffile I have used 'file.clientFile' to save the file name so that I can read the correct file later from a known directory. If I am uploading multiple files on one form, how do I know which name goes with which file? thanks in advance for any help :) ~~ 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
Row Color
How do I make a tr tag change for every row. I would like alternating row colors. 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: ORACLE DATE INSERT ERROR.. Help.
You're missing a ')'.
- Original Message -
From: Greenberg, Lisa [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, April 26, 2001 1:30 PM
Subject: ORACLE DATE INSERT ERROR.. Help.
I'm trying to insert a date into an Oracle table and get the following
error. Help!!
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Oracle][ODBC Oracle Driver][Oracle OCI]ORA-00917: missing comma.
SQL = INSERT INTO emirf (FIRST_NAME, REQUEST_DATE, LAST_NAME) VALUES (
'Lisa',to_date('26-Apr-2001','DD-MMM-','Lisa' )
Data Source = ADMS
Here is the CF code:
cfquery name=requestInsert datasource=#Application.SMInfo#
INSERT INTO emirf
(FIRST_NAME, REQUEST_DATE, LAST_NAME)
VALUES (
'#form.first_name#',to_date('#DateFormat(Now(),'DD-MMM-')#','DD-MMM-
','#form.last_name#') /cfquery
~~
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
?error?
what does this mean: Error Diagnostic Information ODBC Error Code = () Unable to get a connection to catlingalleries. The error occurred while processing an element with a general identifier of (CFUPDATE), occupying document position (1:1) to (4:88) in the template file d:\64.224.42.213\ControlPanel\ImageManager\UpdateInfo.cfm. I've checked my forms and everything is fine here is my cfupdate looks like this... cfupdate datasource=catlingalleries tablename=OtherImages dbtype=ODBC formfields=PictureID, ArtName, ArtistID, TypeID, Medium, Size, aDate, Price Thanks, Jay Patton Web Design / Application Design Web Pro USA p. 406.549.3337 ext. 203 p. 1.888.5WEBPRO ext. 203 e. [EMAIL PROTECTED] url. www.webpro-usa.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: ORACLE DATE INSERT ERROR.. Help.
You are missing a parenthesis after the completion of TO_Date section.
dave
At 11:30 AM 4/26/2001 -0700, you wrote:
I'm trying to insert a date into an Oracle table and get the following
error. Help!!
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Oracle][ODBC Oracle Driver][Oracle OCI]ORA-00917: missing comma.
SQL = INSERT INTO emirf (FIRST_NAME, REQUEST_DATE, LAST_NAME) VALUES (
'Lisa',to_date('26-Apr-2001','DD-MMM-','Lisa' )
Data Source = ADMS
Here is the CF code:
cfquery name=requestInsert datasource=#Application.SMInfo#
INSERT INTO emirf
(FIRST_NAME, REQUEST_DATE, LAST_NAME)
VALUES (
'#form.first_name#',to_date('#DateFormat(Now(),'DD-MMM-')#','DD-MMM-
','#form.last_name#') /cfquery
~~
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
BROWSER - WHY
Can anyone tell me why an application outside side of me LAN keeps the answer once a back button is hit and the SAME application inside of a LAN doesn't. Need help. Thank you for your time. Dave Clay Trusjoist.com Webmaster Dave Clay Internet Facilitator Trus Joist, A Weyerhaeuser Business 5995 Greenwood Plaza Blvd, Suite 100 Greenwood Village, CO 80111 303.770.8506 ~~ 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: New CF5 Partner Hosting License
Hi, Anyone seen a pricing structure for cf5? We're going to feel pretty ackward if they actually lower the prices. ;-) If not, then I agree with you. I wouldn't want to calculate the chances of CF5 Hosting Edition costing LESS than CF4.5 Pro -- It won't happen. Please, MacroMedia -- Prove me wrong! grin David ~~ 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: New CF5 Partner Hosting License
If that's true, we won't be moving to CF5. Sorry, Macromedia, but that would be a bad, bad licensing ploy on your part. I'm sure we're not unique in hosting about 20 CF sites of our own on one server. Might be an idea to send these opinions to the folks at Macromedia. Anyone know of an appropriate contact email address to send comments about this licence change? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ORACLE DATE INSERT ERROR.. Help.
I'm trying to insert a date into an Oracle table and get the following
error. Help!!
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Oracle][ODBC Oracle Driver][Oracle OCI]ORA-00917: missing comma.
SQL = INSERT INTO emirf (FIRST_NAME, REQUEST_DATE, LAST_NAME) VALUES (
'Lisa',to_date('26-Apr-2001','DD-MMM-','Lisa' )
Data Source = ADMS
In addition to the error pointed out by Chis, the format for an abbreviated
month is MON. I wrote it like this for a test:
select to_date('26-Apr-2001','DD-MON-') from dual;
It returns:
4/26/01
Russell Conway
HallofSports.com, Inc.
351 West 22nd Street
New York, NY 10011
P (646) 638-2500
F (561) 423-2674
http://www.hallofsports.com
.. . . where the legends live on
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Row Color
head of page --- cfparam name=end_trigger default=0 cfloop query=your_query cfset end_trigger = end_trigger + 1 cfif end_trigger mod 2 is 1 tr style=background-color: DD; cfelse tr /cfif /cfloop -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 2:40 PM To: CF-Talk Subject: Row Color How do I make a tr tag change for every row. I would like alternating row colors. 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: Row Color
TR bgcolor=###Iif(((CurrentRow MOD 2) is
0),de('FIRSTCOLOR'),de('SECONDCOLOR'))#
- Original Message -
From: Joshua Tipton [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, April 26, 2001 2:40 PM
Subject: Row Color
How do I make a tr tag change for every row. I would like alternating row
colors.
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: Row Color
tr bgcolor=#IIf(CurrentRow Mod 2, DE('FF'), DE('CF'))#
Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 26, 2001 11:40 AM
To: CF-Talk
Subject: Row Color
How do I make a tr tag change for every row. I would like alternating row
colors.
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
validating URLs with regex
REFind('^http://[\./-:0-9a-zA-Z]+$', URL)
I want to be able to validate the url.
This works
REFind('^http://[\./-:0-9a-zA-Z]+$', URL)
But I want to allow - _ ? = and alphanumeric characters in the query
string but not in the first part of the URL.
What do I need to add to
^http://[\./-:0-9a-zA-Z]+$
to make it work? Also, how can I make the s in https optional?
Thanks,
Sebastian
~~
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: New CF5 Partner Hosting License
At 14:19 26/04/01 -0400 Howie Hamlin said Here's a real interesting line from the announcement: The ColdFusion 5 Enterprise and Pro End-User License will no longer permit multiple ColdFusion applications and/or sites to be hosted on a single ColdFusion server. I've got 3 sites on my machine (HoF, FA and CT). They're all mine and not 'owned' by anyone else. Is this a hosting situation? The logical answer is no. CFHosting, VirtualScape and others have people renting space on box. The people don't own the box and there are multiple sites owned by multiple people. Is that a hosting situation? Logically, yes. The issue is making sure A/MM defines hosting properly. If they don't, then small guys like me and anyone else with more than one domain name will be hurt. On the other hand, if they're dropping the price for the 'single domain' version and keeping the price the same for the hosting version, then there's no real complaint. On the other hand, they use the term Hosting Service Providers throughout the document. While parts can apply to someone like me, the HSP doesn't. I think all they have to do is define what a HSP is. I know that A/MM is watching these lists and are gathering our reactions. I think they're going to come out with some solid information on this soon. I love you people but we are programmers and one of the psychological traits of a programmer is paranoia. How much is the question, but when we're all together we feed off each other. And of course, the paranoia may be totally real. :) ~~ 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: Row Color
tr bgcolor=#IIf(QueryNameHere.CurrentRow Mod 2, DE('E7'),
DE('99CC99'))#
that should do it
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
- Original Message -
From: Joshua Tipton [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, April 26, 2001 12:40 PM
Subject: Row Color
How do I make a tr tag change for every row. I would like alternating row
colors.
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: Row Color
#iif(mod currentrow,de(color1),de(color2))# -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 2:40 PM To: CF-Talk Subject: Row Color How do I make a tr tag change for every row. I would like alternating row colors. 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
