RE: CFLOCK Question
You could also declare local variables and assign them the value of the application variables. Then you wouldn't have to lock them when reading. -Original Message- From: Alex Puriche [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 17, 2000 2:02 PM To: [EMAIL PROTECTED] Subject: CFLOCK Question cf-talk, Last week I consulted with 2 CF Guru regarding locking application variables. And I received two different answers. I want to ask community to point me in the right direction. In Application.cfm I install application.3D_Array with around 100 of values. Later I _never_ rewrite, update or delete them. I _read_ them only. Am I need to lock each reading of those application.variables or I need to lock "installing" process (in Application.cfm) only??? Example you can see here: http://www.smartkonnections.com/Soap2/cfm/article/index.cfm -- Regards, Alex mailto:[EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Create Table Statement
DROP TABLE TABLENAME CASCADE CONSTRAINTS ; CREATE TABLE TABLENAME ( COL1 NUMBER(3) NOT NULL, COL2 VARCHAR2(2), COL3 VARCHAR2(30) DEFAULT USER NOT NULL, UPDATEDBY VARCHAR2(30) DEFAULT USER NOT NULL, DTCREATED DATE DEFAULT SYSDATE NOT NULL, DTUPDATED DATE DEFAULT SYSDATE NOT NULL, STATUS NUMBER(3) DEFAULT 1 NOT NULL, ACTV NUMBER(1) DEFAULT 1 NOT NULL, DESCRIPTIONVARCHAR2(50), GRANT SELECT ON TABLENAME TO READONLY; -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 18, 2000 10:31 AM To: [EMAIL PROTECTED] Subject: SQL Create Table Statement I am having major cranial flatulence today and can't remember how to write a create table statement. I don't have access to SQL server's book's online othewise I'd look up the syntax there. I'm also not the owner of the database so I can't use the enterprise manager. Any help would be appreciated. TIA, --Katrina Katrina Chapman Consultant Ameriquest Mortgage -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Passing a formfield along a multi-form page
Put the text you want to display into a variable. Pass the variable from page to page. When you want to display it, assign the variable to the textarea. -Original Message- From: Britta Wingenroth [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 18, 2000 11:18 AM To: [EMAIL PROTECTED] Subject: Passing a formfield along a multi-form page This should be so simple I've got a site going online on Friday, and I can't finish the shopping cart becuase of this! Please help! Thanks! I have a page of cfoutput in my form. I snared the whole page by repeating it and enclosing it in a textarea tag, like so: actual page output page output repeated Now this is pretty ugly, even set to row1 col1, but at least it works. The problem is that I can call this textarea on the next page and display it, but that's not what I want to do. I want to hide it on the first page it comes to and display it on the one that comes after that, so I have to pass it invisibly. I've tried and invisible field then trying to pass it inside the form and just assuming it is getting passed and putting a simple which outputs it in that page and does not hide it at all. How DO you do this? Thanks for any help! Britta -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: dynamic query
use the function preserveSingleQuotes() -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 18, 2000 12:16 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: dynamic query > I am trying something which may not be allowed. > > > > > Select * from property > #test# > > > I am getting a 37000 syntax error. I have tried this with > and without the single quotes and it gets the same error. Try this: SELECT * FROM PROPERTY #PreserveSingleQuotes(test)# Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Inserting a date and date manipulation questions.
There are many date functions you can use in CF for this. Go to: Tools/Expression Builder from the menu, then under Functions go to Date and Time. -Original Message- From: Jeff W [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 18, 2000 12:10 PM To: [EMAIL PROTECTED] Subject: Inserting a date and date manipulation questions. I need to insert a date into a table for a reminder type application. I am using Access as my datasource. A user would ask to be reminded in a given amount of time, say 2 weeks, 4 weeks, etc from the current date. I would like to put this data in a table for another application to e-mail out reminders. My sticking point is: 1. how would you insert the current date into the table?? and.. 2. how would you insert a future date?? IS there a good source for date manipulation?? Adding days, subtrackting months, etc... Thanks Jeff [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Variable Scope??
Brings up an interesting point. During my tenure of client-server development (VB,PowerBuilder,C) we always prefixed our variables with scope and type. For example, ls_name would be a "local" variable of type "string". However, in all the cf-talk threads, and books I rarely noticed this technique used. Is there a reason for this? The type may not be as useful, but the scope prefix would seem to eleviate the problem of multiple scoped variables with the same name. Any thoughts on this? -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Friday, May 19, 2000 3:47 AM To: [EMAIL PROTECTED] Subject: RE: Variable Scope?? > > Is there places that you do not want to scope variables? In other words, > it's very good practice to scope all your variables. Is there any places > that scoped variables would not work? > Hi Kevin, All variables are scoped whether you like it or not. Doing will create that variable in the scope 'variables'. Scoped variables only really stop working when you have variables with the same name in different scopes and you as the programmer aren't explicit about which variable from which scope you want to use. It can get really confusing if you're not careful... Never happened to me.. Honest Guv! ;o) Regards Stephen -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
maxrows with grouping in cfquery??
Can I use MAXROWS and STARTROW when using GROUPING with cfquery? It's doesn't seem to work. Has anybody used a combination of this successfully? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Problem
can't have "like =" use like for strings and = for numeric comparisons (i.e. like "rabbit" or = 2333 can't have =Size in your select statement. I'm not sure what you're trying to do with that part. -Original Message- From: MichaelFox [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 23, 2000 3:24 PM To: CFTALK Subject: SQL Problem This is a multi-part message in MIME format. --=_NextPart_000_001B_01BFC4CA.F0E5E7A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable This isn't really cold fusion related, but its close enough. I am coding a text search engine in ASP using MS Index Server. This SQL statement: SELECT FileName, DocTitle, DocSubject, DocCreatedTM, DocAuthor, vPath, = Size, Characterization FROM SCOPE() WHERE Characterization LIKE = ('""strText""') AND Path NOT LIKE '%vti%' ORDER BY FileName DESC" Gives me this error: Microsoft OLE DB Provider for Microsoft Index Server error '80040e14'=20 Incorrect syntax near (. Expected _STRING. SQLSTATE=3D42000=20 /support/search_new2.asp, line 88=20 Anyone got any ideas what to do? Thanks, -Mike --=_NextPart_000_001B_01BFC4CA.F0E5E7A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable This isn't really cold fusion related, = but its=20 close enough. I am coding a text search engine in ASP = using MS=20 Index Server. This SQL statement: SELECT FileName, DocTitle, DocSubject,=20 DocCreatedTM, DocAuthor, vPath, Size, Characterization FROM SCOPE() = WHERE=20 Characterization LIKE (‘""strText""') AND Path NOT LIKE = '%vti%' ORDER BY=20 FileName DESC" Gives me this error: Microsoft OLE DB Provider for Microsoft Index Server error '80040e14'=20 Incorrect syntax near (. Expected = _STRING.=20 SQLSTATE=3D42000=20 /support/search_new2.asp, line 88 Anyone got any ideas what to do? Thanks, -Mike --=_NextPart_000_001B_01BFC4CA.F0E5E7A0-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
how to write a good technical specification ???
Sorry for the off topic question but I'm having a hard time finding any information on this. Does anybody know of a good source on "how to write a good technical specification"? I've done a few internet searches and can't find anything good. Any help would be greatly appreciated. thanks, Troy Johnson -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Problem Declaring Stored Procedure with Max(blah)
If you're putting this in a sproc, you can wrap your select with conditional logic. Such as: Declare @Max_ID Integer If NOT isNull(@Max_ID) then select @Max_ID = max(IDField) + 1 from tablename Else @Max_ID = 0 End If I'm not sure if my syntax is correct (it's been a while) but you should get the jist of what i'm saying. Good luck. -Original Message- From: cftalk [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 17, 2000 1:48 PM To: [EMAIL PROTECTED] Subject: Problem Declaring Stored Procedure with Max(blah) I am trying to write a SP for SQL7 that is freaking on me. Everything below works GREAT unless the database is totally empty with no records in there. Well if there are no records in the db yet, the max(IDField) isn't working properly. If there is no records in the DB yet, I need to have @Max_ID set to '0'. Declare @Max_ID Integer Select @Max_ID = max(IDField) + 1 From tablename Ideas? Todd DeFrane CFBoards.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
trapping sql statement
Does anybody know a way to trap a sql statement so that it can be caught in a try/catch block? Is this supposed to be done when you select "show sql and datasource name" in the debug settings of CF Admin? It's not working for us, we only get the datasource name but no sql. thanks, Troy Johnson -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
isDefined() on session/application variables
Does anybody have any thoughts on weather you should always do an isDefined() before reading or writing a session/application variable? Why? thanks, tj -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
....scope or name
When using cflock to read/write session or application variables using CF Server 4.5 should I use the Name attribute or the Scope attribute? If I use Name will I still be able to set the different characteristics of the locking schema in CF Administratorwill they still work or do I need to use Scope for this? thank you, tj -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: isDefined() on session/application variables
with that would you also then agree that whenever you use ANY variable, no matter what scope, you should do an isDefined()? If not, why? -Original Message- From: Jeremy Allen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 27, 2000 10:38 AM To: [EMAIL PROTECTED] Subject: Re: isDefined() on session/application variables - Original Message - From: Troy Johnson <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 27, 2000 11:58 AM Subject: isDefined() on session/application variables Does anybody have any thoughts on weather you should always do an isDefined() before reading or writing a session/application variable? Why? thanks, tj !- That is one of those golden rules of programming. You cannot perform an operation on something that is not existant. Therefore, you must ensure that your variable exists before you can use it. Much like initalizing your variable you must also always be sure it exists given the nature of ColdFusion :) Jeremy Allen [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
SafeText.cfm ??
Does anybody know of any tags or event handlers that should be added to this that are not there by default and please explain why? thank you, Troy Johnson -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SafeText.cfm ??
SafeText.cfm is a custom tag I found in Developers Exchange on Allaire.com. What it does is remove or escape (your choice) any html or cf tags from you form fields. -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 28, 2000 6:51 PM To: [EMAIL PROTECTED] Subject: RE: SafeText.cfm ?? HUH? What is SafeText.cfm ? -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- > -Original Message- > From: Troy Johnson [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 28, 2000 10:00 AM > To: '[EMAIL PROTECTED]' > Subject: SafeText.cfm ?? > > > Does anybody know of any tags or event handlers that should be > added to this > that are not there by default and please explain why? > > thank you, > > Troy Johnson > > > -- > > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SafeText.cfm ??
Yes, but specifically which ones? There is a list already built into the tag. It has the following in it: Tags:(SCRIPT,OBJECT,APPLET,EMBED,FORM,LAYER,ILAYER,FRAME,IFRAME,FRAMESET,PAR AM,META) Event Handlers: (onClick,onDblClick,onKeyDown,onKeyPress,onKeyUp,onMouseDown,onMouseOut,onMo useUp,onMouseOver,onBlur,onChange,onFocus,onSelect,javascript:) Should there be any more that are NOT already in either of these lists that anybody can think of? thanks, tj -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 29, 2000 11:41 AM To: [EMAIL PROTECTED] Subject: RE: SafeText.cfm ?? Oh! I get it now. So you're asking whether there should be exclusions for event handlers (javascript) and DHTML, etc., right? Good point. Haven't got a clue. Maybe the authors of the two CF_SafeText tags have some input. (Ben??) ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- > -Original Message- > From: Troy Johnson [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 29, 2000 7:44 AM > To: '[EMAIL PROTECTED]' > Subject: RE: SafeText.cfm ?? > > > SafeText.cfm is a custom tag I found in Developers Exchange on > Allaire.com. > What it does is remove or escape (your choice) any html or cf > tags from you > form fields. > > > > -Original Message- > From: Mark Warrick [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 28, 2000 6:51 PM > To: [EMAIL PROTECTED] > Subject: RE: SafeText.cfm ?? > > > HUH? > > What is SafeText.cfm ? > > > -- > Mark Warrick > Phone: (714) 547-5386 > Efax.com Fax: (801) 730-7289 > Personal Email: [EMAIL PROTECTED] > Personal URL: http://www.warrick.net > Business Email: [EMAIL PROTECTED] > Business URL: http://www.fusioneers.com > ICQ: 346566 > -- > > > > -Original Message- > > From: Troy Johnson [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, June 28, 2000 10:00 AM > > To: '[EMAIL PROTECTED]' > > Subject: SafeText.cfm ?? > > > > > > Does anybody know of any tags or event handlers that should be > > added to this > > that are not there by default and please explain why? > > > > thank you, > > > > Troy Johnson > > > > > > -- > > > > Archives: http://www.eGroups.com/list/cf-talk > > To Unsubscribe visit > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=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=lists&body=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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Unsubscribe
I promised not to get involved in this thread BUT... Marcus...you are my hero. Let this be a warning to others. -Original Message- From: Marcus [mailto:[EMAIL PROTECTED]] Sent: Friday, June 30, 2000 7:23 AM To: [EMAIL PROTECTED] Subject: RE: Unsubscribe > I suspect that you may have subscribed with an address other than > [EMAIL PROTECTED] Perhaps you used [EMAIL PROTECTED], since that's the > one listed > in this email. You may have used an address in ivq.com, since > mail for that > domain also goes to your mail server, and you're the owner of that domain. > Or, perhaps, you registered with an email address in art21.com; > that's also > yours and also uses the same mail server. > > Or, it could be an email account at museumofsex.net - that's > yours too. Oh, > wait; there's no mail server record for that one. How about > mosex.com. That > one's still active. It does point to a different mail server, but > that mail > server could simply be forwarding to your regular mail account. Nice site, > by the way - like the restrained use of Flash, and the site itself looks > pretty interesting. Any site that can enlist Sandra Bernhard, Arianna > Huffington and Annie Sprinkle must have something going on. > > I'm tired, so I'll just list some of the other possibilities: > > shellymars.com > sexphanatic.com > erotogram.com > mosex.org > mosex.net > > I'd focus on the ones using the mail server hosted by netaxs.com first - > that's your best bet. Finally, you have at least three NIC handles. That's > kind of overkill, don't you think? > > I hope you find this helpful. he shoots, and he SCORES!!! Thats was a difficult three pointer from the outside seeing nothing but net! Swish! Marcus -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: still not working
doesn't surprise me :) -Original Message- From: Steve DeWitt [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 06, 2000 8:21 AM To: '[EMAIL PROTECTED]' Subject: RE: still not working if this is the exact code you have a comma missing in the values between '#phone#' and '#state#' -Original Message- From: gregg Kachel [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 06, 2000 8:18 AM To: [EMAIL PROTECTED] Subject: still not working Hi, thanks for all of your help. I'm still struggling with the connecting the two tables. I did as Mark suggested and checked for required fields, the only one I have is the primary keys wich are autonumbered (memberid for memberlist, id for members) I linked the tables together with memberID but that doesn't seem to help. Also as Nick suggested I took out the ''s from my number fields, and put the inserts in correct order. So far this is what i have: insert into memberlist(firstname,lastname, boat, boatyear, address, city, phone, state, zip, emailaddress, ) values( '#firstname#', '#lastname#', '#boat#', #boatyear#, '#address#', '#city#', '#phone#' '#state#',#zip#, #emailaddress#') insert into members(firstname,lastname, username, password, emailaddress) values( '#firstname#', '#lastname#', '#username#', '#password#', '#emailaddress#') The error is: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (3:17). Date/Time: 07/06/00 09:26:49 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt) Remote Address: 192.168.0.55 HTTP Referer: http://www.houseboatmagazine.com/admin/vhc/newaddprofile.cfm Template: D:\Inetpub\wwwroot\CFDOCS\a Web\houseboat\admin\vhc\newaddprofile2.cfm Thanks again, I'm getting very frustrating, I know this should be fairly easy and straight forward. Gregg -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body... -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: still not working
actually, try removing the trailing comma after emailaddress in the insert part of your sql. by the way, Ryan found your error ;)and says hi. -Original Message- From: Steve DeWitt [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 06, 2000 8:21 AM To: '[EMAIL PROTECTED]' Subject: RE: still not working if this is the exact code you have a comma missing in the values between '#phone#' and '#state#' -Original Message- From: gregg Kachel [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 06, 2000 8:18 AM To: [EMAIL PROTECTED] Subject: still not working Hi, thanks for all of your help. I'm still struggling with the connecting the two tables. I did as Mark suggested and checked for required fields, the only one I have is the primary keys wich are autonumbered (memberid for memberlist, id for members) I linked the tables together with memberID but that doesn't seem to help. Also as Nick suggested I took out the ''s from my number fields, and put the inserts in correct order. So far this is what i have: insert into memberlist(firstname,lastname, boat, boatyear, address, city, phone, state, zip, emailaddress, ) values( '#firstname#', '#lastname#', '#boat#', #boatyear#, '#address#', '#city#', '#phone#' '#state#',#zip#, #emailaddress#') insert into members(firstname,lastname, username, password, emailaddress) values( '#firstname#', '#lastname#', '#username#', '#password#', '#emailaddress#') The error is: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (3:17). Date/Time: 07/06/00 09:26:49 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt) Remote Address: 192.168.0.55 HTTP Referer: http://www.houseboatmagazine.com/admin/vhc/newaddprofile.cfm Template: D:\Inetpub\wwwroot\CFDOCS\a Web\houseboat\admin\vhc\newaddprofile2.cfm Thanks again, I'm getting very frustrating, I know this should be fairly easy and straight forward. Gregg -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body... -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Allaire Certification Program
Steve "CCFD" DeWitt -Original Message- From: Steve DeWitt [mailto:[EMAIL PROTECTED]] Sent: Friday, July 07, 2000 8:52 AM To: '[EMAIL PROTECTED]' Subject: RE: Allaire Certification Program I have done it and the questions are straightforward with a mix of html, sql, and cfml questions. If you go to http://www.allaire.com/certification you can get a rough idea of what the exam will cover and it is pretty acurate. Steve DeWitt -Original Message- From: Reynolds, Adam [mailto:[EMAIL PROTECTED]] Sent: Friday, July 07, 2000 2:33 AM To: '[EMAIL PROTECTED]' Subject: Allaire Certification Program Has anybody done this yet? If so, what were the questions like? I'm considering doing this in the next couple of months (either in the UK, or most likely in the US). I think it would add real value to my CV seeing as I work as a consultant. Adam ** This email and any attachments are confidential and solely for the use of the intended recipient. They may contain material protected by legal professional or other privilege. If you are not the intended recipient or the person responsible for delivering to the intended recipient, you are not authorised to and must not disclose, copy, distribute or retain this email or its attachments. Although this email and its attachments are believed to be free of any virus or other defect, it is the responsibility of the recipient to ensure that they are virus free and no responsibility is accepted by the company for any loss or damage arising from receipt or use thereof. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL
exactly what you said: select blah from blah where blah not in('blah1','blah2') -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 5:14 PM To: [EMAIL PROTECTED] Subject: SQL Is there anyway to do the opposite of this...? I need something like NOT IN. SELECT blah from blah WHERE Blah IN('blah1','blah2','blah3') -Adrian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Can you pass a query??
Let's say I had a query that has 10 rows, but I only want to display 5 rows at a time. A link will then call the same tag do display the next 5 rows. How can I do this without running the query each time? Can I pass a query as a url variable? Can I put the query into an array and pass the array? thanks in advance, Troy -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Can you pass a query??
Very creative solution...thanks -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 11, 2000 9:31 AM To: [EMAIL PROTECTED] Subject: RE: Can you pass a query?? > Let's say I had a query that has 10 rows, but I only want to > display 5 rows > at a time. A link will then call the same tag do display the next 5 rows. > How can I do this without running the query each time? > > Can I pass a query as a url variable? > Can I put the query into an array and pass the array? Here's an idea - if you can't cache the query, run it once completely, Now pass the list of Identities to every page. On the specific page, break-out the small part of the list you need, and run a query on those entries... select myFields from myTable where ID in (#smallIDList#) Might spark some ideas... Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** 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. ** -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
cfx_j example
Anybody have an example of java class that does a select to a db, and returns the entire recordset as a query to a cfx_j call? Troy Johnson Project Lead - AN Onvia.com http://www.onvia.com Office: 206.373.9241 Cell: 206.660.7410 Onvia.com now has AUCTIONS for business! Buy or sell excess inventory now! click: http://www.onvia.com/usa/auctions/index.cfm -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Is there a way to get one template to stop the process of another template?
it may be easier to set the maxrows returned to a certain value. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, May 12, 2000 1:29 PM To: cftalk Subject: Is there a way to get one template to stop the process of another template? Example: I have a template which is running a query that is attempting to pull millions of records. Is there a way I can setup another template which will interrupt the query template? Or if a template sets up an infinite loop, is there a way to terminate it from another template? Lon Lentz Applications Developer - GetLists.Com DataWarehousing and List Sales - Market your lists on the Net! [EMAIL PROTECTED] 941-541-9000 Ext. 210 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
referrencing a forms elements as an array
when you submit a form where the action="validateform.cfm" can you reference the items in the form as an array?? I want to loop through all the form elements and grab all the checkboxes (they have different names) and put them into a list. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Is there a way to get one template to stop the process of another template?
No. The called template would have to stop processing on it's own. There's no way for another template to "monitor" the action of another and intervine. You would have to set some variable in the called template which would cause it to stop running. This of course is not what you want to do, but I don't see any alternative. If you tell me what you're trying to accomplish maybe I could give you some ideas. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, May 12, 2000 1:41 PM To: [EMAIL PROTECTED] Subject: RE: Is there a way to get one template to stop the process of another template? We've done that, actually, with an application. After the server choked a couple times. My question is really about the ability of one template to interrupt or affect the concurrent action of another template. Is it possible? -----Original Message- From: Troy Johnson [mailto:[EMAIL PROTECTED]] Sent: Friday, May 12, 2000 4:30 PM To: '[EMAIL PROTECTED]' Subject: RE: Is there a way to get one template to stop the process of another template? it may be easier to set the maxrows returned to a certain value. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, May 12, 2000 1:29 PM To: cftalk Subject: Is there a way to get one template to stop the process of another template? Example: I have a template which is running a query that is attempting to pull millions of records. Is there a way I can setup another template which will interrupt the query template? Or if a template sets up an infinite loop, is there a way to terminate it from another template? Lon Lentz Applications Developer - GetLists.Com DataWarehousing and List Sales - Market your lists on the Net! [EMAIL PROTECTED] 941-541-9000 Ext. 210 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: referrencing a forms elements as an array
is the name of the structure the name of the form? How do you reference the struct.? -Original Message- From: Steve Aylor [mailto:[EMAIL PROTECTED]] Sent: Friday, May 12, 2000 3:31 PM To: [EMAIL PROTECTED] Subject: Re: referrencing a forms elements as an array In cf4.5 form is now a cf structure... if that helps you any. Steve - Original Message - From: "Troy Johnson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 12, 2000 2:20 PM Subject: referrencing a forms elements as an array > when you submit a form where the action="validateform.cfm" can you reference > the items in the form as an array?? I want to loop through all the form > elements and grab all the checkboxes (they have different names) and put > them into a list. > > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Oracle 8.0 help
use the "output" parameter in the tag. -Original Message- From: David Pierce [mailto:[EMAIL PROTECTED]] Sent: Monday, May 15, 2000 3:14 PM To: [EMAIL PROTECTED] Subject: Oracle 8.0 help Has anyone found out how to return a result set from an Oracle stored Proc? Any help you could provide would be great. Thanks.. David Pierce Sharpsource (925) 240-8515 EX:114 [EMAIL PROTECTED] 1240 Central Blvd., Suite A Brentwood, CA 94513 www.sharpsource.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Invalid expression format?
you have 3 "(" but 4 ")" you need one more "(" -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 16, 2000 12:33 PM To: CF-Talk Subject: Invalid expression format? I am getting a invalid expression format on the following code: #Evaluate(Variables.OptionName)[ListFindNoCase(ValueList(Evaluate(Variables. OptionValue)), Variables.SelectedValue)]# The error is: Invalid parser construct found on line 129 at position 61. ColdFusion was looking at the following text: ( Invalid expression format. The usual cause is an error in the expression structure. -- Line 61 would be the ( before the second Evaluate function. This is within a custom tag. The OptionName and OptionValue come from CFSET statements that are setting the query name and the columns. What would be a work around for this? Please cc me in a reply. Thanks, Aaron -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Recall: Invalid expression format?
Troy Johnson would like to recall the message, "Invalid expression format?".. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Invalid expression format?
-Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 16, 2000 12:33 PM To: CF-Talk Subject: Invalid expression format? I am getting a invalid expression format on the following code: #Evaluate(Variables.OptionName)[ListFindNoCase(ValueList(Evaluate(Variables. OptionValue)), Variables.SelectedValue)]# The error is: Invalid parser construct found on line 129 at position 61. ColdFusion was looking at the following text: ( Invalid expression format. The usual cause is an error in the expression structure. -- Line 61 would be the ( before the second Evaluate function. This is within a custom tag. The OptionName and OptionValue come from CFSET statements that are setting the query name and the columns. What would be a work around for this? Please cc me in a reply. Thanks, Aaron -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.