Re: deleting records
Sounds like you are missing some single quotes in your query statement. Maybe you can paste it here. Also, date is probably not the best unique identifier, depending on your application. It is always possible that two users could submit and have the form processed at the exact same time. Scott M. Berry :: [Staff Developer] annex.com, Inc. - http://www.annex.com/ - Original Message - From: "Kylie Lovelock" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, November 20, 2000 8:35 AM Subject: deleting records Evening all The continuing saga of my learning curve kinda goes like this I'm using UltraDev have a page displaying all of the records in a table, at the end of each record a have a form with a 'delete' button - everything displays beautifully. In theory, after I deleting a record, you return to the same page. But I am getting this error after clicking the delete button. Error Diagnostic Information ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (26:1) to (26:88). My date field is the unique identifier (access general date format, time etc included as not to double up). Any ideas where I'm going wrong? Thanks for your time Cheers Kylie Lovelock When confronted by a difficult problem, you can solve it easily by reducing the question to, "How would the Lone Ranger handle this?" ~~ 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 ~~ 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 Time formats
Hello, Try TimeFormat (and DateFormat if you want date) #TimeFormat(query.columnname, "hh:mm tt")# Scott M. Berry :: [Staff Developer] annex.com, Inc. - http://www.annex.com/ - Original Message - From: "Kevin Willyerd" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, November 20, 2000 8:54 AM Subject: OT: SQL Time formats Hey all, I have a field stored as a smalldatetime in SQL 7. Using the convert function I can pull out the time in the format of hh:mm (Convert(char(5),dbo.event.datetime,8) as Time). How do I have the output of the time in the format hh:mmAM (or PM)? I am taking what I have now and converting it using cold fusion functions. Kevin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ 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: Kooky Form Field/List question.
This list sucks. It is soo freaking slow that every idiot (including those who just love posting even though they have no idea how to answer a question) posts an answer to every question asked because they don't get the other's replies fast enough. Good bye. Scott M. Berry :: [Staff Developer] annex.com, Inc. - http://www.annex.com/ - Original Message - From: "Michael Thomas" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, November 20, 2000 9:10 AM Subject: Re: Kooky Form Field/List question. cfloop index="test" list="#FORM.fieldnames#" delimiters="," #test# : #Evaluate("FORM.#test#")# br /cfloop That'll work. Best Regards, Mike From: "Willy Ray" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Kooky Form Field/List question. Date: Mon, 20 Nov 2000 08:48:21 -0700 I work on a college campus, and frequently I'm asked by faculty/staff/students, why they can't just make a form in front page express and have it send them an email (and we don't have the server extensions). I have the hardest time explaining what a form handler is, and how frontpage just can't do it. So, I decided to make a generic Coldfusion form handler. Something that, provided it was passed an email address, subject line, and a redirect URL (for the success message), it would make an email to the address. Ok, this is the easy part. I have it already. The problem is, I need also to pass *any form fields* other than the ones required for the email in the body of the email. Biology is going to need different things on their form than accounting, see, so I want to make this thing totally generic. So, here's the problem. I can use the automatically-created FORM.fieldnames list to get the field names onto the email like this: cfloop index="test" list="#FORM.fieldnames#" delimiters="," #test# : br /cfloop This code puts the names of the form field onto the email. Easy. I can also test them for whether or not they're one of my required fields, and not print them if they are. What I can't do is print the VALUE of the form fields. Make sense? I was hoping I could do something like this: cfloop index="test" list="#FORM.fieldnames#" delimiters="," #test# : #FORM.#test## br /cfloop Yeah, but I can't. Any 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 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.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 ~~ 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 HOST for XXX content
You might contact the company I work for. www.annex.com Scott M. Berry :-: [Staff Developer] annex.com, Inc. - http://www.annex.com/ - Original Message - From: "Martin S" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, November 18, 2000 6:11 PM Subject: CF HOST for XXX content Anybody know of CF HOSTING SITES that allow XXX content? If so a list of a them would be great so I can compare them...also any personal recommendations would be great. More the meria!! From: "Brian L. Wolfsohn" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: What's running on my machine Date: Sat, 18 Nov 2000 18:44:27 -0500 IS it possible to have a .cfm template return the names of all applications created with cfapplication currently running on a given machine ?? ~~ 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 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.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 ~~ 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: db Conversion
Sure. Shoot them over. Scott M. Berry :-: [Staff Developer] annex.com, Inc. - http://www.annex.com/ - Original Message - From: "Peter Tilbrook" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, November 20, 2000 4:40 PM Subject: db Conversion Would someone out their be able to convert a couple of databases from Access 2000 back to 97? I've switched jobs and we are not using 2000 here (dammit). Cheers! ~~ 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 ~~ 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: displaying data from a table
I would assume that each row represents a record. Therefore, I would setup one main screen where users could search the records (by some identifying mark) or could select a record from a drop down lists of record. This selection would then send the user to a typical edit page, which would represent each column as some sort of field (text, checkbox, etc.) that the user could edit and then press a submit button to update the information. That is generally how we do update forms. Scott M. Berry :-: [Staff Developer] annex.com, Inc. - http://www.annex.com/ - Original Message - From: "Phil Palmer" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, November 19, 2000 6:55 PM Subject: displaying data from a table Dear All When displaying rows of data from a database table I have been using CFGRID. The user then selects a row in the table and clicks on a button to perform some action. (Delete or Change for example). Is this the way most people do this sort of thing? Is there other ways of displaying data in this way (not using CFGRID) and then letting the user scroll through it selecting one or more rows before performing some action on those rows? I was thinking of displaying the data in a table with a check box in each row to allow them to select that row. Then I am not sure how to process the form once they submit. Any thoughts appreciated. Regards Phil Palmer ~~ 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 ~~ 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: Deleting Session Variables
Session variables are stored in an array. You can kill the array (arraydelete()) but that will kill all the vars and Allaire does not recommend that. You can probably do some nifty functions by converting the array to a list, and finding out the position of the var you want to delete and then doing a arraydeleteat() for that var.. not sure.. guessing here. Scott M. Berry :-: [Staff Developer] annex.com, Inc. - http://www.annex.com/ - Original Message - From: "Scott Wolf" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, November 19, 2000 10:52 PM Subject: Deleting Session Variables I know this question was asked just a couple of days ago, but I lost all of my old e-mail when I formatted my HD. How can I remove a session variable completely? I know I can change the value using CFSET (i.e. CFSET Session.LoggedIn = "1") but I don't know how to remove it altogether. Please let me know if you can. Thanks! Scott Wolf ~~ 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 ~~ 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
Security
Hello, One of my friends and coworker posted here about how to secure a web app. He suggested storing part of the tickcount in a database and as a cookie, and then verify that the cookie exists and that the numbers are the same. I was wondering if there was a way to store a cookie that is some sort of session ID that CF assigns to each session, so all that would have to be done is a compare between the cookie and the session id. Any ideas? Scott M. Berry :-: [Staff Developer] annex.com, Inc. - http://www.annex.com/ - Original Message - From: "Jim McAtee" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, November 18, 2000 11:13 AM Subject: Re: HTTP Referrer Rather than trying to use http_referer in your login page, try the following. Depends a little on how you have your security system setup. If you're including at the top of every secured page a template/code snippet to detect if someone is currently logged in, have that bit of code note 'cgi.script_name', which is the requested template. When that code redirects to the login page, pass the template name to the login page and then pass it along as a hidden field. If your security scheme has different levels of access be sure to have it also verify that the user is permitted to access the page in question at the same time as you verify the username and password. Jim -Original Message- From: W Luke [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Saturday, November 18, 2000 10:59 AM Subject: Re: HTTP Referrer Relying on the referer to take a user back after loggin in is Not A Good Idea(tm). Microsoft's IIS does not send the http_referer when not in a secure section of a site (e.g. https://) Here is the microsoft article that tells of their reasoning... http://support.microsoft.com/support/kb/articles/Q178/0/66.ASP Thanks for the link. I'm running O'Reilly WebSite Pro, and have been testing this for the past few hours with IE, and it does seem to work very well. One /excellent/ way around this is to use the Fusebox custom tag CF_ReturnFuseAction by Steve Nelson. You don't even need to use any other part of Fusebox. It works like a charm in both IE and Netscape. You can find the tag on the Fusebox sit (www.fusebox.org) or in Allaire's Dev Exchange (http://devex.allaire.com/developer/gallery/info.cfm?ID=CA3477C0-2830-11D4- A A9700508B94F380method=Full ) --watch the word-wrapping Fusebox - that name continues to crop up! I'll take a look. Thanks, 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 ~~ 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
Have you ever read the docs? Not very descriptive. So, one could set a session cookie with a value of the cftoken and cfid and that would be individual throughout the server and application? And it wouldn't be easily obtainable by anyone else? Scott M. Berry :-: [Staff Developer] annex.com, Inc. - http://www.annex.com/ - Original Message - From: "Steve Bernard" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, November 18, 2000 3:13 PM Subject: RE: Security That's CF's, and most products, method of tracking sessions, i.e. tokens as cookies. It's all in the docs. Steve -Original Message----- From: Scott M. Berry [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 18, 2000 2:34 PM To: CF-Talk Subject: Security Hello, One of my friends and coworker posted here about how to secure a web app. He suggested storing part of the tickcount in a database and as a cookie, and then verify that the cookie exists and that the numbers are the same. I was wondering if there was a way to store a cookie that is some sort of session ID that CF assigns to each session, so all that would have to be done is a compare between the cookie and the session id. Any ideas? Scott M. Berry :-: [Staff Developer] annex.com, Inc. - http://www.annex.com/ - Original Message - From: "Jim McAtee" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, November 18, 2000 11:13 AM Subject: Re: HTTP Referrer Rather than trying to use http_referer in your login page, try the following. Depends a little on how you have your security system setup. If you're including at the top of every secured page a template/code snippet to detect if someone is currently logged in, have that bit of code note 'cgi.script_name', which is the requested template. When that code redirects to the login page, pass the template name to the login page and then pass it along as a hidden field. If your security scheme has different levels of access be sure to have it also verify that the user is permitted to access the page in question at the same time as you verify the username and password. Jim -Original Message- From: W Luke [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Saturday, November 18, 2000 10:59 AM Subject: Re: HTTP Referrer Relying on the referer to take a user back after loggin in is Not A Good Idea(tm). Microsoft's IIS does not send the http_referer when not in a secure section of a site (e.g. https://) Here is the microsoft article that tells of their reasoning... http://support.microsoft.com/support/kb/articles/Q178/0/66.ASP Thanks for the link. I'm running O'Reilly WebSite Pro, and have been testing this for the past few hours with IE, and it does seem to work very well. One /excellent/ way around this is to use the Fusebox custom tag CF_ReturnFuseAction by Steve Nelson. You don't even need to use any other part of Fusebox. It works like a charm in both IE and Netscape. You can find the tag on the Fusebox sit (www.fusebox.org) or in Allaire's Dev Exchange (http://devex.allaire.com/developer/gallery/info.cfm?ID=CA3477C0-2830-11D4- A A9700508B94F380method=Full ) --watch the word-wrapping Fusebox - that name continues to crop up! I'll take a look. Thanks, 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 ~~ 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 ~~ 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 ~~ 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: Development Environments
We do basically the same thing. We have on development server which we share. However, we try to make sure that only one developer is working on any one site's code at one time, so that we don't have to worry about version problems. Scott M. Berry :-: [Staff Developer] annex.com, Inc. - http://www.annex.com/ - Original Message - From: "Craig A. Zingerline" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, November 17, 2000 4:55 AM Subject: Development Environments Hello, What do most companies do as far as having a team-based development environment? We have a small team of developers sharing multiple projects and do our work on Win98 platforms and map to our NT server through CF Studio to write code. All of our beta sites are put there to make sure that we always have the most recent version. What do other people do and/or recommend? Thanks, Craig Craig A. Zingerline Advanced Media Productions Web Application Developer [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 ~~ 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: Hahah More
Thanks! I think I was playing around with that tag but wasn't having much luck. I will take another look. Scott M. Berry -- College of the Canyons Web Design 661.259.7800 x3630 http://www.coc.cc.ca.us - Original Message - From: "Larry Lyons" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 16, 2000 7:50 AM Subject: Re: Hahah More Scott, There's a very good tag in the Developer's gallery called CF_StockGrabber at http://devex.allaire.com/developer/gallery/info.cfm?id=CA3471D5-2830-11D4-AA 9700508B94F380method=full. For an example see http://www.pacel.com/investors.cfm. hth, larry -- Larry C. Lyons EBStor.com 8870 Rixlew Lane, Suite 204 Manassas, Virginia 20109-3795 tel: (703) 393-7930 fax: (703) 393-2659 Web: http://www.pacel.com http://www.ebstor.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- "Computer Simplistics Suppoer" [EMAIL PROTECTED] wrote in message news:000c01bfbed4$ec7380c0$[EMAIL PROTECTED]... Ok.. now that my weather is working =) I need stock quotes and a search function: Stock Quote: I just have yahoo opening in another window with the quote, however, I would like to include the quote in the page. Any services that provide this? Search: Just a simple web search, yahoo is fine. It again opens in another window, but I would like to include the results in my own page (sort of like a cfinclude). Any help on this? Can anyone tell I am working on a portal site? hahah Scott Berry -- Computer Simplistics Support "Simple Solutions for a Complex World" http://www.c-s.net 661-296-4315 -- -- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: New Window
I think I will take you up on that offer. Thanks! Scott M. Berry -- College of the Canyons Web Design 661.259.7800 x3630 http://www.coc.cc.ca.us - Original Message - From: "Jeff" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 15, 2000 8:53 PM Subject: Re: New Window scott, :~~ : From: Computer Simplistics Suppoer [EMAIL PROTECTED] : : What would be some JavaScript (I am assuming that : is what I would use) to open the results of a form in a : new window, one which I can control the size, toolbars, : resize, etc? :~~ first off, i'd like to invite you to join the js-jive list where this sort of question is not offtopic. in fact, this very question was asked and answered today. http://www.onelist.com/community/JS-Jive/ second, you can see an example of this implementation here: http://members.evolt.org/jeff/code/form_to_window/ good luck, .jeff name://jeff.howden game://web.development http://www.evolt.org/ mailto:[EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
SOT: CSS2
Ok.. just getting into using CSS for all my sites, seems the logical way to go. Question: Often times I will use two different colors for links... the link color in the body, and then on some links I will specify colors like: a href="link.html"font color="#00"Link/font/a How would this be accomplished in css? Scott M. Berry -- College of the Canyons Web Design 661.259.7800 x3630 http://www.coc.cc.ca.us -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Getting Key Field after Insert
Question: Does this initialize itself? If there is no data, will that query assume a 0 and start off at 1? I like this much better then using the Key in access, in that in Access it is a HARD key.. once a record is deleted, the key won't be reused and I have gaps in my listings. This method is a real world implementation, nice code. Scott M. Berry -- College of the Canyons Web Design 661.259.7800 x3630 http://www.coc.cc.ca.us - Original Message - From: "Jennifer" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 02, 2000 10:48 AM Subject: Re: Getting Key Field after Insert At 12:54 PM 5/2/00 -0400, you wrote: I am using Microsoft Access Autonumber to create Key fields for me. 1. Is this a wise thing to do? 2. If ok , anyone have a nice way of getting the key back. I am currently saving a temporary key in one the fields, then finding and changing. This seams like a lot of work to create an Insert. 3. If not, and this might explain all of the discussion about key creation, what was the consensous on the best way to generate a unique key? I generate keys in the page. That way, I don't have to search the database for the key-- I already have it. For this method, it is extremely important that you use CFTransaction. Otherwise you might get errors. cftransaction cfquery name="GetID" datasource="#application.Dsn#" SELECT MAX(UserID) as LastId FROM table; /cfquery cfset form.UserID=(GetId.LastID + 1) cfquery datasource="#application.Dsn#" insert into table (column) values (#column#'); /cfquery /cftransaction This code selects the largest ID number, adds one to it and sets that as the ID number of the new record. If you don't put this code in cftransaction, multiple simultaneous users could send records with the same id number. This method was recommended to me by Mr GuruMan Raymond Camden, and I've seen it mentioned here many times. It seems to be a relatively standard method. I haven't had any problems with it. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Getting Key Field after Insert
Haha.. so, you could just throw a CFIF in there and not even have to mess with the database. Cool, thanks! Scott M. Berry -- College of the Canyons Web Design 661.259.7800 x3630 http://www.coc.cc.ca.us - Original Message - From: "Jennifer" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 02, 2000 12:15 PM Subject: Re: Getting Key Field after Insert At 11:20 AM 5/2/00 -0700, you wrote: Question: Does this initialize itself? If there is no data, will that query assume a 0 and start off at 1? No, so what I did was created a dummy record with an id number of one, inserted a real record and deleted the dummy. I don't know of any reason that the dummy should be numbered one instead of zero; that's just the number I picked. Theoretically, you could want the number to start really high to make something look more impressive, so you could set the dummy to any id number that you want. (Some one I know did this in a site with listings similar to personal ads. Since the id numbers started at 10,000 and the id number was a URL parameter, it gave the illusion of 10,000 previously successful ads. Of course, it was just a sneaky trick.) I guess you could seed the ID within the code. You could set an ID seed to one (or whatever you wanted as the seed) and if there are no records returned (LastID wouldn't be valid, so you couldn't add to it) you could set the ID number to the seed. Then, any records after that would be built on the record with the ID number of the seed. So you would want to do this: cfset IDSeed = 1 cftransaction cfquery name="GetID" datasource="#application.Dsn#" SELECT MAX(UserID) as LastId FROM table; /cfquery cfif IsDefined('GetID.RecordCount') and GetID.RecordCount GTE 1 cfset form.UserID=(GetId.LastID + 1) cfelse cfset form.UserID=IDSeed /cfif cfquery datasource="#application.Dsn#" insert into table (column) values (#column#'); /cfquery /cftransaction I haven't actually tried this; I just thought of it. But I think it would work pretty nicely. I like this much better then using the Key in access, in that in Access it is a HARD key.. once a record is deleted, the key won't be reused and I have gaps in my listings. This method is a real world implementation, nice code. Well, I can't take credit for the code, but you should realize that the id numbers for deleted records won't be reused unless the deleted records had the largest ID numbers. However, if you want to clean up the id numbers after a while, you can set up a program to renumber them starting with some number. Scott M. Berry -- College of the Canyons Web Design 661.259.7800 x3630 http://www.coc.cc.ca.us - Original Message - From: "Jennifer" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 02, 2000 10:48 AM Subject: Re: Getting Key Field after Insert At 12:54 PM 5/2/00 -0400, you wrote: I am using Microsoft Access Autonumber to create Key fields for me. 1. Is this a wise thing to do? 2. If ok , anyone have a nice way of getting the key back. I am currently saving a temporary key in one the fields, then finding and changing. This seams like a lot of work to create an Insert. 3. If not, and this might explain all of the discussion about key creation, what was the consensous on the best way to generate a unique key? I generate keys in the page. That way, I don't have to search the database for the key-- I already have it. For this method, it is extremely important that you use CFTransaction. Otherwise you might get errors. cftransaction cfquery name="GetID" datasource="#application.Dsn#" SELECT MAX(UserID) as LastId FROM table; /cfquery cfset form.UserID=(GetId.LastID + 1) cfquery datasource="#application.Dsn#" insert into table (column) values (#column#'); /cfquery /cftransaction This code selects the largest ID number, adds one to it and sets that as the ID number of the new record. If you don't put this code in cftransaction, multiple simultaneous users could send records with the same id number. This method was recommended to me by Mr GuruMan Raymond Camden, and I've seen it mentioned here many times. It seems to be a relatively standard method. I haven't had any problems with it. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists
Re: Basic Query Question
Much Thanks! Scott Berry - Yahoo!GeoCities Senior Liaison http://www.geocities.com/~harryhoudini - Magic Castle Junior Society http://www.magiccastle.com/Juniors/index.html - College of the Canyons Web Design http://www.coc.cc.ca.us - Original Message - From: "Pete Freitag" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, April 22, 2000 11:59 PM Subject: RE: Basic Query Question WHERE Membername != '#Cookie.Memebername#' OR WHERE Membername '#Cookie.Membername#' See http://www.cfdev.com/resources/discussion/messages.cfm?id=7 For more SQL info ___ Pete Freitag CFDEV.COM Cold Fusion Developer Resources http://www.cfdev.com/ -Original Message----- From: Scott M. Berry [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 20, 2000 10:24 PM To: [EMAIL PROTECTED] Subject: Basic Query Question I need to do a query with his logic in it: WHERE Membername IS NOT '#Cookie.Membername#' How do I do a NOT in a WHERE? Scott Berry - Yahoo!GeoCities Senior Liaison http://www.geocities.com/~harryhoudini - Magic Castle Junior Society http://www.magiccastle.com/Juniors/index.html - College of the Canyons Web Design http://www.coc.cc.ca.us -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CheckBox
Ok.. checkbox question: I want to check in the action page to see if the check box was checked on the previous form page. Is that a IsDefined or a ParameterExists... in other words.. does it always exists, even if it wasn't checked, or do I just need to check if it exists? Thanks! Scott Berry - Yahoo!GeoCities Senior Liaison http://www.geocities.com/~harryhoudini - Magic Castle Junior Society http://www.magiccastle.com/Juniors/index.html - College of the Canyons Web Design http://www.coc.cc.ca.us -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Basic Query Question
I need to do a query with his logic in it: WHERE Membername IS NOT '#Cookie.Membername#' How do I do a NOT in a WHERE? Scott Berry - Yahoo!GeoCities Senior Liaison http://www.geocities.com/~harryhoudini - Magic Castle Junior Society http://www.magiccastle.com/Juniors/index.html - College of the Canyons Web Design http://www.coc.cc.ca.us -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: about updating with CFSCHEDULE
I am not sure what the original message is about exactly, but it kicked my mind into a question: I output the result of the scheduled tasks to a file. Say I want to keep a log (either appending to that file or in a database preferred).. how would I go about that? Right now it simply overwrites the last file in there, so I get one week's worth of results. My only thoughts were to make another schedule item to rename the file according to the date it was last done (to keep a list of files with results) but that is no ideal. Scott M. Berry -- College of the Canyons Web Design 661.259.7800 x3630 http://www.coc.cc.ca.us - Original Message - From: "Sharon DiOrio" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; "CF-Talk-HouseOfFusion" [EMAIL PROTECTED] Sent: Tuesday, April 11, 2000 8:33 AM Subject: Re: about updating with CFSCHEDULE Well, if you are going to update a template, you will need something to update it with. Usually, people store this in a database, and it will need to be retrieved with a query. Could you explain more what you are trying to do? Sharon At 11:05 AM 4/11/2000 -0300, Juan Manuel Tapiola wrote: Hello, I want to keep updated every day a template but I don't want this to depend on a query. Instead of that, I want to have a scheduling task to update this template every day. How do I do it? Is it a way to create application variables? Is it the best way? Thank you a lot in advance, Manuel Tapiola www.ciudadvideo.com --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarstsbodysts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Is 4.5.1 Solid
Not only do they use cached proxy servers, but they severely filter content. Wise words: "bad bad bad" =) Scott M. Berry -- College of the Canyons Web Design 661.259.7800 x3630 http://www.coc.cc.ca.us - Original Message - From: "Jennifer" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 11, 2000 10:59 AM Subject: Re: Is 4.5.1 Solid At 09:02 AM 4/10/00 -0700, you wrote: Hi Dick, We upgraded to 4.51 and it seemed to cure quite a few ills. So far no damage. We had previously installed the hot fixes for CFHTTP and CFMAIL and had switched some CFMAIL calls off to another machine so we didn't have many problems there. It now does allow the 20,000,000 AOL users that couldn't complete our pages do so...seems really strange to me that they would allow such crap to be issued as a release in the first place as an 'upgrade' ;) You can't really mean that. The problem is on AOL's end. CF Server now accommodates the problems on AOL's end. Do you honestly want Allaire to get accounts with every major ISP so they can check to see if the ISP's stupid procedures mess up the sites? I used to work at a hosting company and the focus was on video hosting. Every time we had a broadcast, we would get inundated with tech support calls from AOL users asking us why our site was broken. You can't imagine how many times I had to explain to people exactly why they needed to get a real ISP. AOL uses cached proxy servers and it is bad bad bad. The really funny calls were the AOL users who said "What do you mean you don't do tech support for AOL? You're the Internet, right?" The ISP who hosts many of my client's sites is considering switching to 4.5.1 as the active CF platform. There have been lots of threads re problems with various 4.5 versions... I am especially concerned with: CFHTTP regexps CFMAIL Anyone know of outstanding problems with 4.5.1? Any killer incompatibilities between 4.0 4.5 1? TIA Dick -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.