RE: CFSETTING "HTML Strings" *URGENT*
Benjamin, just escape the quotes with an extra quote. HTH, david -Original Message- From: bfalloon [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 7:05 AM To: CF-Talk Subject: CFSETTING "HTML Strings" *URGENT* Hello, Can someone help me with this problem? I want to create a string that contains HTML. Specifically a 'path' string to be outputted at the top of a page with variable content. The problem that I have is that I need to do something like this... Category Sub"> The problem is that because of the quotation marks within the string itself, it is terminating the CFSET command before it gets to the end of the string. I'm not sure if I should use the converted HTML ie. < becomes < and so on because I need to output 'functional' HTML on the page below this CFSET, not 'display' HTML. Can someone explain how this should be phrased. I may also need to append more string information onto the end of this string depending of other query results. Thanks in advance! Benjamin Falloon Objektmedia www.objekt.com.au ~~ 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: validation
Becky, this is what i do. the user submits their info and i do a check in the database on the processing page for the info they have just submitted. if it exists, i CFINCLUDE the previous page but display error messages as needed and pre-populate the fields they have filled out. if they don't exist, then i process the next query which adds them to the DB and then displays a confirmation. all you need is an if/else block where you check the record count of the select based on username/email/whatever. HTH. david -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 1:27 PM To: CF-Talk Subject: validation i want to have a form where i can insert a new user into my database. and i have that form but i want to be able to validate it before it submits this new user into my database. i want to check to make sure the person doesnt already exist. (it wont be me entering the data, so i dont want to have user input errors if they dont search thru the drop down list before adding a new person...resulting in duplicate people). someone told me to look thru the custom tags and i did...but i really dont see what i am looking for. can anyone give me any ideas or some direction? thanks for all your help, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
SQL2000 server not recognized by CF 4.5
I'm hoping someone can help with a problem i cannot figure out. i have a new box with Win2K, CF 4.5, and SQL2000. Installed everything this weekend without problems, but now i cannot get SQL and CF to play together. i try to set up the ODBC and my connection fails every time. the base SQL server that shows up as default on the ODBC admin does not connect, nor does the one that i create. not sure how to trouble shoot this problem at all. any help is greatly appreciated. d ~~ 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: SQL2000 server not recognized by CF 4.5 - continued...
Hello everyone, i sent an email two days ago about not being able to get CF and SQL2000 to talk to each other. i followed the instructions everyone sent me including installing the latest MDAC and still, i couldn't get them to talk to each other. i did finally get them to talk by checking the "use trusted connection" checkbox, but someone at work told me that i hadn't fixed any problem, i'd just gone around it. of course, i really don't know what he means by that at all. As you might have guessed, i'm new to server admin. Also, i can't even get an access DB to be recognized. CF just tells me the datasource cannot be verified. i've added it in my ODBC panel under SystemDSN, but the problem persists with getting CF to talk to databases. if anyone can shed any light onto this problem i would greatly appreciate it. thanks in advance. d -Original Message- From: Sean Daniels [mailto:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 12:25 PM To: CF-Talk Subject: Re: SQL2000 server not recognized by CF 4.5 On 4/23/01 1:52 PM David Baskin wrote: > I'm hoping someone can help with a problem i cannot figure out. i have a new > box with Win2K, CF 4.5, and SQL2000. Installed everything this weekend > without problems, but now i cannot get SQL and CF to play together. i try to > set up the ODBC and my connection fails every time. the base SQL server that > shows up as default on the ODBC admin does not connect, nor does the one > that i create. not sure how to trouble shoot this problem at all. any help > is greatly appreciated. Have you reinstalled the MDAC since installing CF 4.5? If not, pop the windows 2K CD in and run the upgrade and this will fix the MDAC that gets broken when you install CF 4.5. - Sean ~~ 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
question using IIf
I've been told that we should never use IIF and i just took that on blind faith. I've seen everyone using it for their changing table row background colors though so now i'm wondering if i've been told something in error. can anyone shed any light on this? thanks in advance. 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
CFSCRIPT and ListAppend
I'm using CFSCRIPT to run my form error checking and i'd like to keep a list of errors. i'm trying to use "ListAppend" in my script blocks, but it doesn't seem to be working. does ListAppend not work in cfscript? i'm using cfscript to improve processing speed. thanks for any help. errorString = ""; if(FORM.txt_dealerName EQ ""){ ListAppend(errorString, "Please enter a Dealer Name") ; } if(FORM.txt_address1 EQ ""){ ListAppend(errorString, "Please enter an address"); } if (FORM.txt_city EQ ""){ ListAppend(errorString, "Please enter a city"); } d ~~ 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
yet another cfscript question
I was trying to use try/catch in cfscript and i couldn't get it to work. i've checked all the documentation i can find (not much) and it doesn't say if you can or cannot use try/catch inside of cfscript. has anyone used it before? thanks for all the help. 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: OT - Good list for HTML questions
There's a great list at: http://webdesign-l.com/ been using it for a while and found it to be one of the best. HTH, d -Original Message- From: Perez, Bismark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 02, 2001 8:16 AM To: CF-Talk Subject: OT - Good list for HTML questions Hello there, Can somebody recommend a good list to ask HTML questions, I have this page which looks good under IE, but some how it looks terribly wrong under NS, or if there is a site that will shed light on how to do things so they'll be cross-browser... TIA Bismarck Perez ~~ 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
OT - Sys Admin Lists
Hello, i'm working on building my sys admin skills and i'm in need of a list that can answer some basic questions about hardware and OS for Win2K. Does anyone know of any good lists. Thanks. 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: SQL query help
Chad, you'd want to do this: SELECT DISTINCT COLOR FROM tblWhatever WHERE NAME = 'bar' david -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 1:16 PM To: CF-Talk Subject: SQL query help I have a database similar to this: SKU NAMECOLOR STYLE 1 bar blue12" 2 bar blue6" 3 bar blue5" 4 bar red 12" 5 bar red 6" 6 bar red 5" I want to find all the colors that 'bar' comes in. If i do a query on this to find all the colors for the NAME 'bar'. I get: blue blue blue red red red How do i get results like this? blue red Thanks in advanced Chad ~~ 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
1s and 01s
Hello, i'm passing a number from a form and then comparing it with a number pulled out of the DB (SQL server) but when i do the comparison it's against 1 (passed by the form) and 01 (passed by SQL). Can anyone tell me how to format the number coming from the form and CF to pass or be written as 01? Thanks. d ~~ 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
Locking Question
Hello, i'm setting a session variable in a template so i'm using cflock, but i'm getting an error on the scope attribute. i've checked the documentation and it doesn't list scope as valid, but it shows up in Studio and well, it just makes sense that you would use scope. Below is the code i was trying to use. Also, what is the "proper" timeout that should be used for locking session variables. Thanks for any help. d ~~ 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
Strange problem (or still asleep)
Hello, i'm running the code below and i'm not getting the expected results. i'm passing in a variable with the length of 5 so i would expect that the errorString would not be appended, but in fact it is. The same thing happens when i pass in a variable with the length of 9. I can't seem to figure out why this is happening. Can anyone help? Sorry if this is way basic. david code: script }else if((LEN(cleanZipcode) NEQ 5) OR (LEN(cleanZipcode) NEQ 9)){ errorString = ListAppend(errorString, "Please enter a valid zipcode (too long/short)", "|"); errorFlags = ListAppend(errorFlags, "zp", "|"); /script ~~ 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
encrypting url strings
Hello, i'm passing some parameters via the url string and i need to encrypt them. nothing fancy, i've just been told that people shouldn't be able to tell what the vars are and then decide to change them and see what happens. I checked the custom tag gallery and downloaded one tag, but it's a bad file so i can't use it. does anyone have any suggestions on how this can be easily done? thanks in advance. 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
Random Quotes & SQL
Hello, i've been tasked with creating a random quote app for a web site. The trouble i'm having is figuring out how to store the data in my table and then be able to retrieve data once the client has deleted a quote. For example, i can use a PK to define each quote and then just pull a random number within the range of quotes available (eg. 45 quotes, so a random number between 1 and 45), but the client wants to be able to modify or delete quotes so once a deletion occurs, it's possible that the random number chosen might just not exist. What is the SOP for something like this? If the record doesn't exist, select a different random number (seems like a lot of overhead) or is there a way that i should be keying the data to make the possibility of pulling an id that doesn't exist. Oh, i'm working with Access too. Thanks for any help. d ~~ 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
SQL trouble
Hello all, i'm having trouble with a query and i was hoping someone could help me find the solution to my problem. I run a query to get the ids of the objects a customer has stored. in this case it's two ids. then i run another query that gets all the details of these items and displays it. i run the following query to get the details: SELECT p.Year , p.Series , p.stockNum // more and more columns... FROM tblPreOwned p, tblMake m, tblWarranty w, tblModel mo WHERE p.vehicleMakeID = m.makeID AND p.warrantyID = w.wID AND (preID=0 OR p.preID=#preID# OR p.preID = 00) what happens though is that i end up getting back over 1300 records for the details query. it returns the same two objects over and over again. i'm not sure why this is happening and unfortunately my SQL skills are not the best. If anyone can tell me how to better structure this query to return the proper results i would greatly appreciate it. TIA. david Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFSCRIPT
Sorry if this is a dumb question, but i'm curious about CFSCRIPT. what language is the script written in? i've seen some examples that look like javascript, but i haven't been able to determine for sure what language is being used. Also, if anyone can point me to a source where i can learn more about it and why/where/when to use it, i'd appreciate it. thanks. 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: Two functions with a single onClick?
Les, here's some code for you. HTH. david -> Untitled run two javascript functions by clicking on this button: -Original Message- From: Les Irvin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 2:58 PM To: CF-Talk Subject: Two functions with a single onClick? Can more than one javascript function be performed with a single onClick? If so, how would it be written? Thanks, Les ~~ 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: Passing hidden fields
Carlos, there's an article at www.defusion.com that talks about this. the direct link is: http://www.defusion.com/articles/index.cfm?ArticleID=87 HTH. david -Original Message- From: Roque,Carlos [mailto:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 1:32 PM To: CF-Talk Subject: FW: Passing hidden fields I have a four page form with about 15 fields on each page. Is there an easy way to pass values from page to page in hidden fields without typing in each and every field again? Carlos Roque ~~ 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: (yet another) Javascript Question
Jeanne, it looks like you don't have and "(" ")" around your second if case. i think that will fix your problem. else if (ctrl.value > 1) { alert("Please enter a valid fleet size."); david -Original Message- From: Jeanne Sarfaty Glazer [mailto:[EMAIL PROTECTED]] Sent: Friday, March 02, 2001 11:10 AM To: CF-Talk Subject: (yet another) Javascript Question Hi Folks, If there's a more appropriate place to ask this question, please let me know - this list is so incredibly high volume,I'd hate to be erroneously contributing to it when I should send my question elsewhere. With that said: I'm doing Javascript validation and having trouble getting the following to work (it is supposed to only allow user to enter an integer between 1 and 1): function fleet_size_check(form) { ctrl = form.fleet_size; myRe=/^[0-9]{1,6}/; if (!myRe.test(ctrl.value)) { alert("Please enter a valid fleet size."); document.profile_info.fleet_size.focus(); return (true); } else if ctrl.value > 1 { alert("Please enter a valid fleet size."); document.profile_info.fleet_size.focus(); return (true); } else return (false); } The first "if" seems to work OK, but not the second. Any suggestions would be most appreciated. TIA, - - - Jeanne ~~ 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: Easy question I think:
Try this: select * from tblWhatever where columnValue % 2 = 0 the % sign is the symbol for the modulus operator. it's the same as division, but instead of the division value, it returns the remainder value. If the remainder value is 0 then it's an even number. HTH, d -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 9:31 AM To: CF-Talk Subject: Easy question I think: Can anyone give me a sql statement that tells me if a value is odd or even? select * from table where ? ~~ 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
Stored Proc - Odd message
I'm recompiling some stored procs and i'm now getting a message that i've never seen before and i have no idea what it means. the message is: Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'gxpStoreLocator'. The stored procedure will still be created. The gxpStoreLocator does exist so i don't understand the message. Has anyone seen this before and do you know what it means? Thanks. d ~~ 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 and Excel
Hello, i've been tasked with taking data out of a SQL database and inserting it into an excel spread sheet. I went to CFComet and read through their instructions and ran their sample code, but i cannot get it to work. I get the following error: Error Diagnostic Information Error trying to create object specified in the tag. COM error 0x80040154. Class not registered Does anyone know how best to connect and write to excel and if there is a good tutorial that i can learn from. Creating and connecting to objects is new to me, so i'm a little lost. Thanks for any help. 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
error when trying to connect to excel
I'm using code from CFComet to generate an excel spread sheet from a sql query but i'm having trouble getting the ado connection to open. I think perhaps the problem is that i'm replacing "MyDSN" (CFSET Datasource = "MyDSN") with the wrong value. I'm using the name of the datasource that i specified in the CF administrator, but when i talked to some microsoft guys here, they told me that they didn't think CF would translate that to the proper values for an ADO connection. Has anyone used this code before and if so, can you tell me what it is i'm doing wrong. Thanks for any help. d >> the line below generates the error CFSET oConn.Open(Datasource, UserName, Password, -1) >> the error: Error Diagnostic Information Arguments expected by object does not match arguments specified in the tag. Error building an argument list for: OPEN ~~ 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-POST - error when trying to connect to excel
I never saw this come across so i'm trying again. thanks for any help. -- I'm using code from CFComet to generate an excel spread sheet from a sql query but i'm having trouble getting the ado connection to open. I think perhaps the problem is that i'm replacing "MyDSN" (CFSET Datasource = "MyDSN") with the wrong value. I'm using the name of the datasource that i specified in the CF administrator, but when i talked to some microsoft guys here, they told me that they didn't think CF would translate that to the proper values for an ADO connection. Has anyone used this code before and if so, can you tell me what it is i'm doing wrong. Thanks for any help. d >> the line below generates the error CFSET oConn.Open(Datasource, UserName, Password, -1) >> the error: Error Diagnostic Information Arguments expected by object does not match arguments specified in the tag. Error building an argument list for: OPEN ~~ 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 Syntax
Nathan, if you have a comma delimited file with the data you want to import into a table you can do an import in Enterprise Mgr. right click on the table that you want the data in and go to all tasks > import data. point to the text file and follow the steps to import. HTH. d -Original Message- From: Nathan Chen [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 8:57 AM To: CF-Talk Subject: OT: SQL Syntax Hi, Everyone: Does anyone know how the syntax of selecting data from a text delimited file and inserting into an exiting table? I kind of remember Oracle database provides this kind of tool but not sure how. I am now using MS SQL Server 7.0 The simplied situation will something like this: a text file that consists of two columns, first_name, last_name.(tab delimited or space delimited). I need to select data in these columns and then insert them into a table that consists of two columns, first_name, last_name. I thought this would be a simple task but can't find any syntax in the SQL server books. Any help is appreciated. Nathan Chen ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists