Re: CFmail nesting outputs???
You can't have more than one query per cfmail tag. What you have to do is build your message body outside of the message then output it. Something like select Shipto_id,email_addr from ShipToTable Select OrderPart, OrderQty from OrdersTable where OrderId="#Get_emails_Shipto.ShipTo_id#" #message_body# I'm not sure that's right but you get the idea. --K Katrina Chapman Consultant Ameriquest Mortgage [EMAIL PROTECTED] 07/24/00 08:40 AM Please respond to cf-talk To: [EMAIL PROTECTED] cc: Subject:CFmail nesting outputs??? Hello all, I am not able to nest queries in a CFMail, how do you have more than one query in a CFmail, i cant group it either, some like select Shipto_id,email_addr from ShipToTable Select OrderPart, OrderQty from OrdersTable where OrderId="#Get_emails_Shipto.ShipTo_id#" #Shipto_id#,#email_addr# http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- 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.
Allaire Search
I guess enough people complained about the verity errors they were getting. "We're sorry...due to some minor technical difficulties we have taken our search functionality off line for a short period of time. We will have this problem resolved shortly. We appreciate your patience in this matter and apologize for any inconvenience this may cause." --K Katrina Chapman Consultant Ameriquest Mortgage -- 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: How Eliminate blank spaces between words ??
I wouldn't use a regular expression for something so simple at removing spaces. In my experience regular expressions have a tendency to eat up the server. For something this simple I'd use Katrina Chapman Consultant Ameriquest Mortgage "Erki Esken" <[EMAIL PROTECTED]> 07/21/00 07:28 AM Please respond to cf-talk To: <[EMAIL PROTECTED]> cc: Subject:Re: How Eliminate blank spaces between words ?? > I need to eliminate the blank spaces between numbers in phone > numbers so that 07 987 635 can be converted to 07987635 > > the code needs to read the value in the phone variable from > the database table and then remove the blank spaces as > indicated above Use this RegExp: Erki -- 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.
test please ignore.
Didn't you read the subject line? :) --K Katrina Chapman Consultant Ameriquest Mortgage -- 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: saving queries
07/12/00 11:32 AM Please respond to cf-talk To: <[EMAIL PROTECTED]> cc: Subject:saving queries Hi i know there is a way to do this, i just dont know the syntax. i would like to save a query result into a variable can anyone help me with the proper way to do this?? Thanx -Eli- -- 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: why is this happening?
It shouldn't matter what kind of field it is in the database. You need to escape your comma's. Try this. insert into emails(SUBJECT, FROMX, TO, DATEX, BODY, ATTACHMENTS, CC, MESSAGENUMBER, ATTACHMENTFILES, REPLYTO, HEADER, TIMEx) values ( '#query.SUBJECT#', '#FROMX#', '#query.TO#', #DATEy#, '#message_body#', '#ATTACHMENTSX#', '#query.CC#', '#query.MESSAGENUMBER#', '#ATTACHMENTFILESX#', '#query.REPLYTO#', '#query.HEADER#', '#TIMEx#'); Then when you output it you do the opposite. --K Katrina Chapman Consultant Ameriquest Mortgage Douglas Jordon <[EMAIL PROTECTED]> 07/12/00 09:49 AM Please respond to cf-talk To: [EMAIL PROTECTED] cc: Subject:Re: why is this happening? That's interesting, because I had narrowed the fields down to one: the body field which of course contains commas(the data is email). How do I get around this? It's an Access database memo field. DJ "Dempsey, Timothy F." wrote: > > Doug, > > Could one of you values have a comma in it? That might make the database > think it has more values than you intend. > > -- Tim Dempsey > > -Original Message- > From: Douglas Jordon [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 12, 2000 11:06 AM > To: Cold Fusion List > Subject: why is this happening? > > Why would this query: > > > insert into emails(SUBJECT, > FROMX, > TO, > DATEX, > BODY, > ATTACHMENTS, > CC, > MESSAGENUMBER, > ATTACHMENTFILES, > REPLYTO, > HEADER, > TIMEx) > > values ( '#query.SUBJECT#', > '#FROMX#', > '#query.TO#', > #DATEy#, > '#query.BODY#', > '#ATTACHMENTSX#', > '#query.CC#', > '#query.MESSAGENUMBER#', > '#ATTACHMENTFILESX#', > '#query.REPLYTO#', > '#query.HEADER#', > '#TIMEx#'); > > > > return this error?: > > ODBC Error Code = 21S01 (Insert value list does not > match column list) > > [Microsoft][ODBC Microsoft Access 97 Driver] Number > of query values and destination fields aren't the > same. > > What's also odd is that the data is being saved to the table. > > TIA, > > Doug Jordon > > -- > 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. -- 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: How to Count? or Record Count?
I could be totally wrong here but I'm assuming that tbl_SignUp.CreateDate is the time that they signed up. Am I right? If I am you could just do this SELECT tbl_Employee.EmployeeID, tbl_Employee.LastName, tbl_Employee.FirstName, tbl_Employee.Email, tbl_Class.ClassID, tbl_Class.ClassName, tbl_Class.ClassDate, tbl_SignUp.SignUpID, tbl_SignUp.SU_DateOfferdID, tbl_SignUp.SU_EmployeeID, tbl_SignUp.Completed, tbl_SignUp.CreateDate FROM tbl_Employee, tbl_Class, tbl_SignUp WHERE EmployeeID = SU_EmployeeID AND ClassID = SU_DateOfferdID AND ClassName = 'Human Resource Mgmt' ORDER BY tbl_Class.ClassDate, tbl_SignUp.CreateDate, #DefOrder# This sort order would put the classes together, then put them in order by who signed up when, then whatever #DefOrder# is. Is that what you wanted? --K Katrina Chapman Consultant Ameriquest Mortgage Paul Ihrig <[EMAIL PROTECTED]> 07/12/00 09:13 AM Please respond to cf-talk To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> cc: Subject:How to Count? or Record Count? Ok this is going to sound a bit odd since i am not sure how to word it. i have my little query: [in my admin page for viewing who has signed up for the class] [[from dataview01.cfm]] SELECT tbl_Employee.EmployeeID, tbl_Employee.LastName, tbl_Employee.FirstName, tbl_Employee.Email, tbl_Class.ClassID, tbl_Class.ClassName, tbl_Class.ClassDate, tbl_SignUp.SignUpID, tbl_SignUp.SU_DateOfferdID, tbl_SignUp.SU_EmployeeID, tbl_SignUp.Completed, tbl_SignUp.CreateDate FROM tbl_Employee, tbl_Class, tbl_SignUp WHERE EmployeeID = SU_EmployeeID AND ClassID = SU_DateOfferdID AND ClassName = 'Human Resource Mgmt' ORDER BY #DefOrder# Which is grabbing a list of employees which could have signed up for 1 class, given on 2 differnt dates. My problem is, that the class size needs to be limited to 25 people. This is stated on my main form. it also shows how many people are currently singed up for class 01 & class 02. [[from signup01.cfm]] SELECT SignUpID, SU_DateOfferdID FROM tbl_SignUp WHERE SU_DateOfferdID = 1 SELECT SU_DateOfferdID FROM tbl_SignUp WHERE SU_DateOfferdID = 2 [[the display]] A limit of 25 spaces are available per class per day. You will be notified if you are selected for the class & time. . #rsDate01_total# people have signed up so far for # LSDateFormat(rsDisplayDate01.ClassDate, ', DD, ') #. #rsDate02_total# people for # LSDateFormat(rsDisplayDate02.ClassDate, ', DD, ') # So, on the form i show how many have signed up. But on the admin page, i cant figure out how to show who has signed up in sequential order. Because on one admin page i have 2 seperate date/times they could sign up. Its not really abig deal. i would just like to know how to get the number of the last insert Total + 1 as the number that realates to the student who signed up.?? I know i should have used a sepereate table for each Class/time. mabey i will redo it from the ground up. But since it is 10 different classes with 2 times each, spread out over the next year. I wanted to be able to track Student/employees progress through this "Practice Manegment" class. lol no one will read this! Thanks if you do! -paul -- 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: You know what would be really cool?
Actually it's The future's so bright, I gotta wear shades! Just an FYI. --K Katrina Chapman Consultant Ameriquest Mortgage Greg Creedon <[EMAIL PROTECTED]> 07/12/00 08:54 AM Please respond to cf-talk To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> cc: Subject:RE: You know what would be really cool? I see! What a great idea. All of the tech staff and admins would have their Allaire Secret Decoder Rings(tm), available in Personal or Enterprise versions. Error says ODBC error? A quick flick of the dial and it's actually a syntax error! Zounds! a misplaced > sign. The future is so bright, I need shades! Greg Creedon On Wed, 12 Jul 2000, Bryan Batchelder wrote: > This message is in MIME format. Since your mail reader does not understand > this format, some or all of this message may not be legible. > > --_=_NextPart_001_01BFEC13.BA40F1D0 > Content-Type: text/plain > > Or they have deliberately misinformed you in the error message :-) Not that > the error is deliberate...but the information it is giving you could be > deliberately wrong. > > I have done this in past systems I have worked on.and set up most of my > UNIX boxes to give wrong profiling information (including information in > errors). > > Just a thought. Its fun watching people try linux exploits on a solaris > box...or vice versa - or making a linux box look like an NT box. > > > Bryan D. Batchelder Work: 813-935-7100 > Palm/Internet Developer Home: 727-547-1322 > > ConnectWise, Inc. (www.ConnectWise.com) > 2803 West Busch Blvd, Suite 204 > Tampa, FL 33618 > > > -Original Message- > From: Steve Bernard [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 12, 2000 11:03 AM > To: [EMAIL PROTECTED] > Subject: RE: You know what would be really cool? > > > It is truly a sad state of affairs isn't it? This sort of thing has been > happening on a regular basis since Allaire first started hosting a website. > All three of their main components, Corporate, Forums, and Beta sites, have > gone down or produced errors that really make them look bad. The two general > types that I have seen the most, and that speak volumes about their > infrastructure/administration in my opinion, are related to performance/load > and database management. Ironically enough, these are two of tenants of the > Allaire Performance Tuning class, optimizing your code and your database. > Another problem that this exposes is Allaire's attention to detail and > security. You can learn a lot about a system by getting such error messages. > It may seem innocent enough but from this error message you know: > > 1) Using IIS > 2) .. therefore, using NT > 3) Web root is on D:, seperate from the system root > 4) Exact path to the customtags directory > 5) Template name > 6) Exact line of offending code > 7) 'CustomTagsV65' may indicate that they have multiple versions in one > tree. This may provide further opportunity >if the system is breached. > 8) Allaire doesn't monitor it's servers effectively > 9) Allaire doesn't seem to take it's web presence seriously enough even > though the product it sells is made for >developing high-end, robust, data-driven, web sites (enought buzz words > there?). > > All this provides is information, not vulnerabilities, but, it is a definite > start in profiling the system, and all without having to send a single > suspicious packet their way. Anyone who has spent time profiling systems > will understand this. So if Allaire is this shoddy in protecting/maintaining > their corporate site what's going on with the areas of the site that manage > customer information? > > Steve > > p.s. I don't have anything against Allaire, I'm just calling it like I see > it. > > > > -Original Message- > > From: Sean Renet [mailto:[EMAIL PROTECTED]] > > > > I think it would be really cool if you went to Allaire's website, searched > > for something and didn't get this: > > > > Error Diagnostic Information > > Error occurred in tag CFSEARCH > > > > Collection failed to open: AllaireWeb6SiteSearch > > > > > > The error occurred while processing an element with a general > > identifier of (CFSEARCH), occupying document position (28:1) to (31:57) in > > the template file > > D:\WWWROOT\ALLAIREWEB65\CUSTOMTAGSV65\ALLAIREWEB\SITESEARCH\SITESE > > ARCH.CFM. > > > > > > Date/Time: 07/11/00 22:55:58 > > Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) > > Remote Address: 63.203.119.82 > > HTTP Referer: http://www.allaire.com/search/index.cfm > > > > > > > > How do these guys expect to have people buy into this language when thier > > own site is constantly breaking? > > > --
RE: Form.Fieldnames Missing
While the form isn't only checkboxes or radio buttons this helps. Thanks, --Kat Katrina Chapman Consultant Ameriquest Mortgage Dan Haley <[EMAIL PROTECTED]> 07/12/00 08:51 AM Please respond to cf-talk To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> cc: Subject:RE: Form.Fieldnames Missing I can recreate the error if the only form elements that are named are checkboxes and radio buttons, and none of them have been checked or selected. At that point form.fieldnames is not defined in the action page. Any chance your form only has checkboxes and radio buttons? Dan -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 11, 2000 8:37 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Form.Fieldnames Missing > Is there a reason why the form.fieldnames field would not be > passed in a form? I vaguely seem to recall that in some versions of CF prior to 4.5.x, if the ENCTYPE attribute of the form is set to "multipart/form-data", which is what you'd use for file uploads, FORM.FIELDNAMES wouldn't appear. Unfortunately, I can't test that theory, since I'm running 4.5.1. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- 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: Form.Fieldnames Missing
That's what we're running as well. --K Katrina Chapman Consultant Ameriquest Mortgage "Dave Watts" <[EMAIL PROTECTED]> 07/11/00 08:37 PM Please respond to cf-talk To: <[EMAIL PROTECTED]> cc: <[EMAIL PROTECTED]> Subject:RE: Form.Fieldnames Missing > Is there a reason why the form.fieldnames field would not be > passed in a form? I vaguely seem to recall that in some versions of CF prior to 4.5.x, if the ENCTYPE attribute of the form is set to "multipart/form-data", which is what you'd use for file uploads, FORM.FIELDNAMES wouldn't appear. Unfortunately, I can't test that theory, since I'm running 4.5.1. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- 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: cf query::
SELECT * from Items WHERE Category LIKE '%#categoryVar#%' AND (sub1 LIKE '%#url.sub1#%' OR sub2 LIKE '%#url.sub1#%') Should Work. --K Katrina Chapman Consultant Ameriquest Mortgage "Chip Sigourney" To: "Cf-Talk@Houseoffusion. Com" <[EMAIL PROTECTED]> Subject: cf query:: 07/11/00 01:51 PM Please respond to cf-talk My problem is that it doesn't narrow down the products at all because it is only passing the category and the sub1. I need it to pass the category, the sub1 and the sub2 and then the Query on Cat2.cfm needs to select only those products. Do you know how I can do that? SELECT * from Items WHERE Category LIKE '%#categoryVar#%' AND sub1 LIKE '%#url.sub1#%' or Category LIKE '%#categoryVar#%' AND sub2 LIKE '%#url.sub1#%' thanks -- 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: Form.Fieldnames Missing
Yes we are using method="post". We did have problems with the way the tags were nested in tables and when another developer "fixed" the problem we were having this one cropped up. This particular template is very long and I'm not sure other list members would appreciate my posting it here but if you'd still like to see it I can email you off list. --K Katrina Chapman Consultant Ameriquest Mortgage "Sean Daniels" tream.com> cc: Subject: RE: Form.Fieldnames Missing 07/10/00 06:41 PM Please respond to cf-talk Are you using the method="post" attribute in the form tag? Another suggestion would be to scrutinize how the form and /form tags are nested. Anything weird there? Otherwise, try posting the code here, maybe that would reveal something. - Sean Sean Daniels Manager, Engineering Marketplace Technologies [EMAIL PROTECTED] http://www.dealstream.com http://www.mergernetwork.com tel: 207.439.6030 cel: 978.764.0799 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 10, 2000 6:02 PM > To: [EMAIL PROTECTED] > Subject: Form.Fieldnames Missing > > > > Is there a reason why the form.fieldnames field would not be passed in a > form? > > --K > > > Katrina Chapman > Consultant > Ameriquest Mortgage > > -- > > 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: Form.Fieldnames Missing
No because it's not a URL variable. It's a Form variable. And even if that were the case it would be there just truncated. --K Katrina Chapman Consultant Ameriquest Mortgage Judah McAuley cc: Subject: Re: Form.Fieldnames Missing 07/10/00 04:07 PM Please respond to cf-talk At 03:53 PM 7/10/00 -0700, you wrote: >Dunno at this point, my next advice might be to check your HTML on the >forms that are sending it, I've seen some unpredictable behaviors due to >bad HTML on the forms. However I doubt this is the only issue, any other >ideas from the crowd please? > >Gregory Harris >Los Angeles ITA Dept. >[EMAIL PROTECTED] I believe that there is a maximum character length allowed for URL's. Could that be the case for form fields? And could these examples be bumping up against that limit? Got me stumped, otherwise. Judah -- 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: Form.Fieldnames Missing
I dont' think that's it because the it's missing on several different
forms. Here's the debugging info.
1st form
BROKER_POINTS=0
BROKERPYA=0
CALCULATE_FOR=BrokerPYA
CALCVIAJS=
CATEGORY=
CLTV=0
COMMENTS=
CONFIRMPASS=
CREDIT_RISK=
EMAIL=
FAX=
FIRST=
HOW_HEAR=
LAST=
LOAN_AMOUNT=0
LTV=0
NEWPASS=
OC=
OTHER_CATEGORY=
OTHER_FINANCING=No
OTHER_FINANCING_AMOUNT=
PHONE=
PREPAYMENT_TERM=
PREPAYMENT_TERM_ID=1
SAVE_SCENARIO_NUM=1
STATE=1
2nd form
BANKRUPTCY=NO
BANKRUPTCYDATE=mm/dd/yy
BANKRUPTCYTYPE=
BROKER_POINTS=0
BROKERPYA=0
CALCULATE_FOR=BrokerPYA
CALCULATED=1
CALCVIAJS=
CATEGORY=
CLTV=0
COMMENTS=
CONFIRMPASS=
CREDIT_RISK=
CREDITSCORE=670
DEBTRATIO=35
EMAIL=
FAX=
FIELDNAMES=CREDITSCORE,DEBTRATIO,THIRTYDAYS,SIXTYDAYS,NINETYDAYS,ONETWENTYDAYS,NOD,RESCINDDATE,BANKRUPTCY,BANKRUPTCYDATE,BANKRUPTCYTYPE,CALCULATED,SUBMIT
FIRST=
HOW_HEAR=
LAST=
LOAN_AMOUNT=0
LTV=0
NEWPASS=
NINETYDAYS=0
NOD=NO
OC=
ONETWENTYDAYS=0
OTHER_CATEGORY=
OTHER_FINANCING=No
OTHER_FINANCING_AMOUNT=
PHONE=
PREPAYMENT_TERM=
PREPAYMENT_TERM_ID=1
RESCINDDATE=mm/dd/yy
SAVE_SCENARIO_NUM=1
SIXTYDAYS=0
STATE=1
SUBMIT=Calculate
THIRTYDAYS=0
3rd form
BANKRUPTCY_TYPE_ID=0
BORROWER_LASTNAME=
BROKER_ID=112
BROKER_POINTS= .000
BROKER_PYA=
BROKERPYA=0
CALCULATE_FOR=Broker PYA
CALCVIAJS=
CATEGORY=
CLTV=0
CLTV_OTHER_FINANCING_AMT=
COMMENTS=
CONFIRMPASS=
CREDIT_RISK=AAA
EMAIL=
FAX=
FIRST=
HOW_HEAR=
INCOME_DOCUMENTATION=
INCOME_DOCUMENTATION_ID=
LAST=
LOAN=
LOAN_AMOUNT=0
LOAN_AMT=0
LOAN_PURPOSE_ID=
LOAN_STATUS_ID=6
LTV=0
NEWPASS=
OC=
OCCUPANCY=
OCCUPANCY_ID=
OTHER_CATEGORY=
OTHER_FINANCING=No
OTHER_FINANCING_AMOUNT=
OWNERS_ID=11
PHONE=
PREPAYMENT_PENALTY=0
PREPAYMENT_TERM=
PREPAYMENT_TERM_ID=
PREQUAL_NUM=000407
PRODUCT=
PRODUCT_ID=
PROPERTY_LOCATION=
PROPERTY_LOCATION_ID=
PROPERTY_TYPE=
PROPERTY_TYPE_ID=
PROPERTY_VALUE=
PURCHASE_PRICE=0
REQ_START_RATE=
RISK_CODE=A
RISKBANKRUPTCYDATE=
RISKBANKRUPTCYTYPE=
RISKBANKRUPTCYTYPEID=0
RISKCREDITSCORE=670
RISKDEBTRATIO=35
RISKNINETYDAYS=0
RISKNODRESCINDDATE=
RISKONETWENTYDAYS=0
RISKSIXTYDAYS=0
RISKTHIRTYDAYS=0
SALES_PRICE=
SAVE=Save
SAVE_SCENARIO_NUM=1
SCENE_LTV=0
SCENE_UW_TIME={ts '2000-07-10 15:40:45'}
START_RATE=0
STATE=1
STATE_ID=1
UW_BANKRUPTCY_RELEASE_DATE=NULL
UW_CREDIT_SCORE=670
UW_DEBT_RATIO=35
UW_MORTGAGE_HIST_120=0
UW_MORTGAGE_HIST_30=0
UW_MORTGAGE_HIST_60=0
UW_MORTGAGE_HIST_90=0
UW_NOD_RESCIND_DATE=NULL
YOUR_NAME=
If you notice only the second form sends the field.
--K
Katrina Chapman
Consultant
Ameriquest Mortgage
"Gregory
Harris"To: <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]cc:
.la.ca.us> Subject: Re: Form.Fieldnames Missing
07/10/00 03:10
PM
Please respond
to cf-talk
There is a default field in EVERY form passed via coldfusion called
fieldnames, this contains a comma spliced list of all the fieldnames in the
form. Your code could be causing a conflict with this default field.
Would advise checking and renaming.
Gregory Harris
Los Angeles ITA Dept.
[EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 07/10 3:01 PM >>>
Is there a reason why the form.fieldnames field would not be passed in a
form?
--K
Katrina Chapman
Consultant
Ameriquest Mortgage
--
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-t
Form.Fieldnames Missing
Is there a reason why the form.fieldnames field would not be passed in a form? --K Katrina Chapman Consultant Ameriquest Mortgage -- 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: Stored Procedure Help
Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you! Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you! Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you! Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you! Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you! Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you! I don't think I said that enough. --K Katrina Chapman Consultant Ameriquest Mortgage [EMAIL PROTECTED] tate.ky.usTo: [EMAIL PROTECTED] cc: 07/10/00 12:03Subject: RE: Stored Procedure Help PM Please respond to cf-talk Just like a cfquery, you need to reference the query: !#prequal_num#! - !#borrower_lastname#! - !#highest_status#! - ! #comment_exists#! or !#test.prequal_num#! - !#test.borrower_lastname#! - !#test.highest_status#! - ! #test.comment_exists#! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 2:07 PM To: [EMAIL PROTECTED] Subject: Stored Procedure Help This is my first time working with a stored procedure and I'm not sure that I'm doing it right. I can get the procedure to run but I can't get the values to display. What am I missing !#prequal_num#! - !#borrower_lastname#! - !#highest_status#! - ! #comment_exists#! SET QUOTED_IDENTIFIER OFFSET ANSI_NULLS ON GO -- -- Given a broker, find data for its most recent 5 prequals. -- -- DateAuthor Change -- 07/07/00 D Noble Created. -- create procedure dbo.p_Pricing_Pipeline ( @broker_id int ) as set nocount on create table #prequal ( prequal_num int not null ,borrower_lastname varchar(96) null ) insert #prequal select top 5 prequal_num ,borrower_lastname from prequal where broker_id = @broker_id order by prequal_num desc create table #half_results ( prequal_num int not null ,borrower_lastname varchar(96) null ,loan_status_rank tinyint null ,number_of_comments int null ) insert #half_results select p.prequal_num ,p.borrower_lastname ,min(ls.loan_status_rank) --,sum(isnull(c.prequal_num,0)) ,sum( case when c.prequal_num is null then 0 else 1 end ) from #prequal p join scenario s on p.prequal_num = s.prequal_num join loanstatus ls on s.loan_status_id = ls.loan_status_id left join comment c on p.prequal_num = c.prequal_num group by p.prequal_num ,p.borrower_lastname select prequal_num as prequal_num ,borrower_lastname as borrower_lastname ,loan_status_rank as highest_status ,case number_of_comments when 0 then 0 else 1 end as comment_exists from #half_results drop table #prequal drop table #half_results return 0 GO SET QUOTED_IDENTIFIER OFFSET ANSI_NULLS ON GO TIA, --K Katrina Chapman Consultant Ameriquest Mortgage -- 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. --
Stored Procedure Help
This is my first time working with a stored procedure and I'm not sure that I'm doing it right. I can get the procedure to run but I can't get the values to display. What am I missing !#prequal_num#! - !#borrower_lastname#! - !#highest_status#! - ! #comment_exists#! SET QUOTED_IDENTIFIER OFFSET ANSI_NULLS ON GO -- -- Given a broker, find data for its most recent 5 prequals. -- -- DateAuthor Change -- 07/07/00 D Noble Created. -- create procedure dbo.p_Pricing_Pipeline ( @broker_id int ) as set nocount on create table #prequal ( prequal_num int not null ,borrower_lastname varchar(96) null ) insert #prequal select top 5 prequal_num ,borrower_lastname from prequal where broker_id = @broker_id order by prequal_num desc create table #half_results ( prequal_num int not null ,borrower_lastname varchar(96) null ,loan_status_rank tinyint null ,number_of_comments int null ) insert #half_results select p.prequal_num ,p.borrower_lastname ,min(ls.loan_status_rank) --,sum(isnull(c.prequal_num,0)) ,sum( case when c.prequal_num is null then 0 else 1 end ) from #prequal p join scenario s on p.prequal_num = s.prequal_num join loanstatus ls on s.loan_status_id = ls.loan_status_id left join comment c on p.prequal_num = c.prequal_num group by p.prequal_num ,p.borrower_lastname select prequal_num as prequal_num ,borrower_lastname as borrower_lastname ,loan_status_rank as highest_status ,case number_of_comments when 0 then 0 else 1 end as comment_exists from #half_results drop table #prequal drop table #half_results return 0 GO SET QUOTED_IDENTIFIER OFFSET ANSI_NULLS ON GO TIA, --K Katrina Chapman Consultant Ameriquest Mortgage -- 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: How to set a future date?
Look at the DateAdd function http://127.0.0.1/cfdocs/CFML_Language_Reference/3_ColdFusion_Functions/lr3_068.htm --K Katrina Chapman Consultant Ameriquest Mortgage aslam bajaria cc: Subject: How to set a future date? 07/05/00 02:48 PM Please respond to cf-talk Is there a way to fill in a future date in a column of a table? I am familiar with the function now(). Is there a way of getting 1year, 1 month , 1 day, 1 hr, 1 min, 1 sec from now and filling it in in a column of a table? Appreciate. A.B. __ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/ -- 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: Snooping CFDOCS directory?
You can do what we do here. Put the cfdocs and cfide directories in a directory other than wwwroot(or what ever your root directory is) and then map them virtually. That way you can still access them through the browser but you don't have the same security problems. You can also add ip restrictions so that only people that you know have access. Email me off list and I can tell you how to do this. That is of course if you're running MS's IIS. --K Katrina Chapman Consultant Ameriquest Mortgage "Ric Smith" erver.com> cc: Subject: Re: Snooping CFDOCS directory? 07/05/00 01:56 PM Please respond to cf-talk Thanks. Yeah, I've got the fix that only allows localhost access I just got real nervous and wanted to make sure I wasn't missing something. I think I'll go ahead and remove the CFDOCS completely. Should I also move the CFIDE directory to something obscure? Ric Smith > They were probably using a canned script which looks for the CF > vulnerabilities. Either remove /CFDOCS/*, install the security fix, or just > remove the files in /expeval/. FYI, the security fix simply restricts access > to the localhost address for the files. > > Steve > > > -Original Message- > From: Ric Smith [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 05, 2000 4:12 PM > To: [EMAIL PROTECTED] > Subject: Snooping CFDOCS directory? > > > I was looking through my logfile reports and found these > entries which troubled me. > > http://www.kungfoo.com/cfdocs/expeval/displayopenedfile.cfm > http://www.kungfoo.com/cfdocs/expeval/sendmail.cfm > http://www.kungfoo.com/cfdocs/expeval/exprcalc.cfm > http://www.kungfoo.com/cfdocs/expeval/openfile.cfm > http://www.kungfoo.com/scripts/iisadmin/bdir.htr > > It appears someone was trying to do something they shouldn't > have. > > I removed the /scripts/iisadmin directory long ago but the > CFDOCS directory is still there. Is it safe to remove or rename > this directory? What about the CFIDE directory, would it be > safe to put NT Authentication on that directory? > > I was hoping someone could let me know if there's > anything I need to worry about. > > Thanks. > > Ric Smith -- 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: Changing default CF error for nonexistent templates
If you're running IIS you can do it through the MMC. Are you running IIS? If so email me off list and I can walk you through it. --K Katrina Chapman Consultant Ameriquest Mortgage "Duane Boudreau"To: "CFTalk" <[EMAIL PROTECTED]> Subject: Changing default CF error for nonexistent templates 06/28/00 12:49 PM Please respond to cf-talk Hi All, Is there a way to customize the default error that CF 4.01 generates when a http request is generated for a template that does not exist? (The solution is pretty easy for 4.5: there is a way with the admin to map missing templates to a cfm template using its physical path. Unfortunately I can not upgrade to 4.5 at this time) TIA, Duane Boudreau, Project/Beta Manager, eMPower Director, Web Technologies Ektron, Inc. http://www.ektron.com 5 Northern Blvd, Suite 6 Amherst, NH 03031 Tel: 603-594-0249 Fax: 603-594-0258 -- 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: Textarea
Textarea doesn't have a value attribute. You have to do this. #body# --Katrina Katrina Chapman Consultant Ameriquest Mortgage Gregg Kachel <[EMAIL PROTECTED]To: [EMAIL PROTECTED] t> cc: Subject: Textarea 06/27/00 10:26 AM Please respond to cf-talk Hi, I'm sort of a newbie with Cold fusion, so I'm probably doing some simple mistake. I can't get my text to show up on a cfquery using tag. Here is my code: Wierd thing is if I change it to an imput type ="text" it works fine. So i know it has to be something in my textarea code. Wierd part is, that same exact code is used elsewhere and works. If anyone can help please do, thanks. The database is in access and is set for "memo" in that field. It wouldn't be so bad but, some of the articles are rather long for a normal text field. Gregg Kachel -- 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 Multiple Values into One Database Field
That should throw a SQL error. What you need to do is create the list
outside of your query statement.
INSERT INTO search(keywords)
VALUES('#keywords#')
--K
Katrina Chapman
Consultant
Ameriquest Mortgage
Anthony
Israel-Davis To: "'[EMAIL PROTECTED]'"
<[EMAIL PROTECTED]>
Subject: RE: Inserting Multiple Values
into One Database Field
06/23/00
03:06 PM
Please
respond to
cf-talk
Try this:
INSERT INTO search(keywords)
VALUES('#name#,#address#,#phone#')
remove the "AND"s and wrap the whole thing in single quotes. Hope that
helps
ant
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 1:56 PM
To: [EMAIL PROTECTED]
Subject: Inserting Multiple Values into One Database Field
Ok, what i am trying to do is add a column in my database that would
contain
"Keywords" for a search.
What i am trying to do is add values from the data entered in the form from
the previous page to one field in the database
I only get a value of "-1" ? is there something i am doing wrong???
INSERT INTO search(keywords)
VALUES('#name#' AND '#address#' AND '#phone#')
Help?
-kev
--
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.
(kinda OT) Memory Write Error/Browser Crash
I have been getting reports of a very wierd error that I cannot recreate on my machine. When a user gets to a certain form on my site and then clicks the back button they get a windows error that reads. The intruction at "0x715c167a" referenced memory at "0X0100". The memory could not be written. Click on OK to terminate the application Click on CANCEL to debug the application Any ideas as to what could be causing this. The site is on a NT 4 SP6a box, running cf 4.51 SQL 7.0. It only happens in IE and not in Netscape. TIA, --K 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.
Re: Need help with a SQL query
If all you want is a comma seperated list of the categories for each item. Why not just add a "categories" field to the item table? Store the comma seperated list there. --K Katrina Chapman Consultant Ameriquest Mortgage "Seth Petry-Johnson" To: <[EMAIL PROTECTED]> Subject: Re: Need help with a SQL query 06/21/00 05:48 AM Please respond to cf-talk > Right, I'm not gonna address the whole thing (no time at the moment), but a > quick word about sub-queries > > They should be used in 2 ways - one to return a single result; > select * from myTable where myValue=(select myValue from myOtherTable > where...) > > Or to return multiple values > select * from myTable where myValue in (select myValue from myOtherTable > where...) > > The second is a lot more useful for what you're looking for Right, but I don't see how that helps me. Neither of those two uses of subqueries returns a LIST of values that can be used in a single field of the parent query. For example, if my mapping table looks like so: ItemIDCategoryID -- 11 12 14 22 24 I would like the details query for ItemID 1 to have the following fields: .Name - simply pulled from item table .Desc - simply pulled from item table .CategoryIDs - "1,2,4" I've looked through a couple of my SQL books and haven't found an answer, so maybe this isn't possible (using SQL 6.5, BTW). Its not THAT big of a deal to run two queries. Thanks for the help, Seth Petry-Johnson Argo Enterprise and Associates -- 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.
Client variable time out.
I know that I shouldn't be using client.something variables but I inherited this code and I dont' have the time to go through it and replace them. Is there somewhere that you can specify the timeout for client varaibles? I know that you can control the application and session variable timeouts with the cfapplication tag and in the administrator but I'm not sure about client. variables. TIA, --K 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.
Re: Fw: Funny
Absolutely hilarious. --K Katrina Chapman Consultant Ameriquest Mortgage "Nick Han" ems.com> cc: Subject: Fw: Funny 06/19/00 03:30 PM Please respond to cf-talk This is a multi-part message in MIME format. --=_NextPart_000_001D_01BFDA03.49CAD590 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit > The male and female stages of life. --=_NextPart_000_001D_01BFDA03.49CAD590 Content-Type: application/octet-stream; name="LIFE_STAGES.TXT.SHS" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="LIFE_STAGES.TXT.SHS" 0M8R4KGxGuEAPgADAP7/CQAGAAABAQAA EgEAAAD+AAD/ ///9 BP7///87QgYHCAkKCwwNDg8A AAAQEQAAABITFBUWFwAAABgZGgAAABscHQAA AB4fICEiIwAAACQlJgAAACcoKQAAACor LC0uLwAAADAxMgAAADM0NQAAADY3ODk6 /v///zw9PgAAAD8AAABAQQAAAEMAAAD+/v///0UAAABGRwAAAEgA AABJSgAAAEsAAABM/v// /1IA bwBvAHQAIABFAG4AdAByAHkA AAAWAAUA//8IAGBIIk91w78B AwAAAIAQAwBJAFQARQBNADAAMAAw ABIAAQH//wYMAAMAAMBGAAAR wEh1w78BoGvySHXDvwEBAE8AbABl CgACAf8D/wAA AAAUAAEAQwBvAG0AcABPAGIAagAA AAASAAIA AQAAAFAA/v// /wIAAAD+/v///wUGBwgJCgsMDQ4P EBESEwAAABQVFgAAABcYGQAAABobHB0e HwAAACAhIgAAACMkJQAAACYnKCkqKwAAACwA AAAtLgAAAC8wMQAAADIzNDU2NwAAADg5OgAA ADs8PQAAAP7///8//v7+ //8BAAAC AQD+/wMKAAD/DAADAADARggAAABQYXF1ZXRlAAgAAABQYW
Re: Is there a typical cause for this error message?
The data that you're trying to input into the field is too long. Either increase the size of the field or reduce the length of the data. --K Katrina Chapman Consultant Ameriquest Mortgage Steve Weiner age.com> cc: Subject: Is there a typical cause for this error message? 06/01/00 07:43 AM Please respond to cf-talk Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (41:7) to (41:98). -- 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: CFSILENT not working?
What do you mean that the server yelled at you? Do you mean an error message was displayed? If so can we see it? --K Katrina Chapman Consultant Ameriquest Mortgage "Pablo Nevares" To: <[EMAIL PROTECTED]> Subject: CFSILENT not working? 05/31/00 02:36 PM Please respond to cf-talk I tried using to suppress the output of an ArrayAppend() function, and CF server yelled at me. =) Apparently it doesn't recognize the tag, which sort of goes along with the fact that CF Studio doesn't try to autocomplete when I type 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: sending a server-file on a cf page
What do you mean you want to send a file? Do you mean you want to write to a file on the d drive? Or are your user's uploading a file? or do you mean that you want to serve the file from the D drive while the wwwroot is on the c drive? If it's the last you can use cfcontent. (maybe) This of course will only work if the cfcontent tag hasn't been disabled in the administrator. --K Katrina Chapman Consultant Ameriquest Mortgage "Daive" iacom.net> cc: Subject: sending a server-file on a cf page 05/31/00 09:44 AM Please respond to cf-talk Hey all i want to send a file on my drive D: when a user load a cfm file. is there a way to do that without virtual stuff on my web server? my webroot is on my drive C: .. and i'm using cf server 4.5 daive -- 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: Some beginner questions
1. Don't Know. 2. As far as I know you should be able to use almost anything in the data except #'s. 3. Just use the name of the field you want. IE: If #query_string# is ?cfid=1234&cftoken=76323661 Then to access just the pieces you would cfid = #cfid# cftoken = #cftoken# and you would get cfid = 1234 cftoken = 76323661 HTH, --K Katrina Chapman Consultant Ameriquest Mortgage "Cristi" e.west.ro>cc: Subject: Some beginner questions 05/31/00 07:50 AM Please respond to cf-talk Hello there. If anyone can find some time... 1) Can I call a JavaScript function from CF? Smth. like where f is a JavaScript function. I tried , but it didn't work. 2) How do I manage strings containing special characters as dbl. quote (i.e. ") Should I prefix them with something. I'd like to have an output like say "hello" 3) How can I get the value of each field in a query string? I know the #cgi.query_string# which returns the entire query string, but I want to access specific fields Thanks in advance Cristi -- 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: Bug report update 5/25/2000
Is this possible? --K Katrina Chapman Consultant Ameriquest Mortgage - Forwarded by Katrina Chapman/CORP/AMQ on 05/26/00 02:19 PM - Tamara Kaplan To: Katrina Chapman/CORP/AMQ@AMQ 05/26/00 01:17 cc: PM Subject: Re: Bug report update 5/25/2000(Document link: Katrina Chapman) Although I have never done this myself, this seems to work: You specify the timeout like normal with something like this: And then you specifically set cookie values. By specifically naming these variables, they will die when the browser is closed. Please give it a try and see if it works. Otherwise, I agree with you that they are in opposition with each other, and no, we wouldn't want to rely on JavaScript to do this. Thanks. Tamara Katrina Chapman To: Tamara Kaplan/CORP/AMQ@AMQ cc: 05/26/00 11:53 Subject: Re: Bug report update 5/25/2000(Document link: Tamara Kaplan) AM #488 "Return to Broker Login results in lost data" has to do with the session timeout. I remember Kimberly saying that we would address this issue when we have the users test the site. My 2 cents: it's too short. I would suggest 30 minutes and then see if we need it bumped up during the pilot. New/Re-open: User info is not logged out upon closing the browser. Tested v.4.4. These two are in direct opposition to each other. You can't have a timeout of 30 minutes and then be logged out as soon as the browser closes. At least not the way that we are currently maintianing state. We're using cookies. The only way you could do it would be with a javascript:onClose event, but that's unreliable. --K 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.
Re: [french] tres court : emploi
Ce ne pas une intrusion. Si vous êtes disposé à relocate (Comment dis donc relocate en Français?) qq'n a Paris Nord. J'irai. --K Katrina Chapman Consultant Ameriquest Mortgage "Yannick Simon" mmerce.fr>cc: Subject: [french] tres court : emploi 05/26/00 10:04 AM Please respond to cf-talk RE: Cold Fusion and NT PasswordsNous avons de gros projets en cours pour faire une v2 du site Rue Du Commerce. Je ne souhaite pas polluer cette liste géniale, mais si vous etes interessé, je cherche un tres bon developpeur, sur Paris Nord, un an d'experience cold fusion pour des projets dans une boite super ... vous etes interessé, envoyez moi votre cv ... vous me trouvez qq'un pour le poste ? je vous promets une prime de cooptation. pardon de cette intrusion. Yannick Simon -- 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?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: How can I count the number of words in a form submission?
ListLen(formfieldname, " ") --K Katrina Chapman Consultant Ameriquest Mortgage mark@warrick. net To: [EMAIL PROTECTED] cc: 05/24/00 Subject: How can I count the number of words in a form submission? 01:06 PM Please respond to cf-talk Here's a new one for everyone... Let's say for example I was collecting a paragraph of text via a web form and I wanted to check the total number of words entered. How can that be done with ColdFusion? ---mark -- 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: I've got the alternating table row color blues
Actually he doesn't. Look closer. I'll help Would result in either Or Your's would do the same but without the leading #. --K Katrina Chapman Consultant Ameriquest Mortgage "Larry C. Lyons" To: [EMAIL PROTECTED] Subject: Re: I've got the alternating table row color blues 05/24/00 08:24 AM Please respond to cf-talk Vance, have a look at your output statements, You've got the open cfoutput tag in the wrong place it should be: HTH, larry -- Larry C. Lyons EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- Vance Duke wrote: > Agreed. Here is what the code should look like. > > > > I have been doing this successfully for a while now. > > Another way of doing it, is set a Counter and then loop. Based on the count > you can set any color. I have done it with up to 4 colored rows, but 4000 > colors would be no different (except a very long template). > > Vance Duke > Applications Developer -- 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: All the Info on O'Reilly's ColdFusion Book
If you notice it has a different ISBN. --K Katrina Chapman Consultant Ameriquest Mortgage "Levi Wallach" To: <[EMAIL PROTECTED]> Subject: RE: All the Info on O'Reilly's ColdFusion Book 05/22/00 02:06 PM Please respond to cf-talk Hmmm, I just did a search on this title on Amazon and came up with a Wrox book! Professional Coldfusion 4.5 by Wrox Author Team Our Price: $59.99 Paperback (October 2000) Wrox Press Inc; ISBN: 1861004540 | Levi Wallach - [EMAIL PROTECTED] P:(703) 237-0443 F: 703-237-3490| | Senior Webmaster, Tran Interactive Design Group - http://www.tidg.com | | Creator, DVDMON.com - http://www.dvdmon.com - [EMAIL PROTECTED] | | DVD News, Views & Reviews, Music & Book Reviews, PDA Channel Content, | | Contests, DVD Buying Guide and more! | - > -Original Message- > From: Kevin Merker [mailto:[EMAIL PROTECTED]] > Sent: Monday, May 22, 2000 11:04 AM > To: [EMAIL PROTECTED] > Subject: All the Info on O'Reilly's ColdFusion Book > > > > Title: Programming ColdFusion > Author: Rob Brooks-Bilson > ISBN: 1-56592-698-6 > Price: $39.95 > Estimated Release: October 2000 > > KM > > -- > > 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: Shortcut for Getting Form Field
CGI.fieldnames I know because I'm using this right now for a form that is dynamically generated. --K Katrina Chapman Consultant Ameriquest Mortgage Steve Weiner age.com> cc: Subject: Shortcut for Getting Form Field 05/22/00 10:42 AM Please respond to cf-talk I'm working on a project that has tons of form fields on a page. I was wondering if there was any cf tags or anything that I could take the form, submit it, and get a list of all the form field names that are available to me without having to go through and doing all the copying pasting... Is there anything like that? [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.
OT - SQL printing tool
Is there an easy way to print out all of the tables and their columns and their properties in MS SQL Server 7? IE Table1 column1 column1props Table1 column2 column2props Table2 column1 column1props Table2 column2 column2props Table2 column3 column3props 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.
RE: Crazy, Crazy Prob w/ simple Fusebox app
That's not entirely true. Are you using the FormURL2Attributes tag? You might want to double check that it's still being uesd and that the most current copy is installed on the server. --Katrina Katrina Chapman Consultant Ameriquest Mortgage "Russell, Bonnie" To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Subject: RE: Crazy, Crazy Prob w/ simple Fusebox app 05/18/00 11:48 AM Please respond to cf-talk if you're using attributes.fuseaction, then the url also needs to be attributes.fuseaction. I've had similar problem when I switch between projects and one uses attributes. and the other doesnt. Hope this solves your problem Bonnie ags -Original Message- From: [ a l l e n g ] [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 18, 2000 12:32 PM To: [EMAIL PROTECTED] Subject: Crazy, Crazy Prob w/ simple Fusebox app I'm at a loss as to what else to check for with the problem. The problem seemed to randomly appear out of no where yesterday. I have a very simple Fusebox app that allows a user to maintain a database for emailing customers. I literally copied the files from client A to client B and changed the headers and a couple changes to reflect a couple extra database fields. THAT IS ALL. I never changed the Index file (code below) nor any of the links. At one point I tested the app and everything was working normally. Then when I looked at it again yesterday, the links were not working. The catch is that I can bring up the appropriate pages just fine by typing in the "direct" URL (e.g. http://dev.usinternet.com/inteletravel/admin/act_EmailAll.cfm ) but it won't work using the "fusebox" way http://dev.usinternet.com/inteletravel/admin/Index.cfm?FuseAction=EmailAll ) . It appears to no longer recognize the values for Attributes.FuseAction and end up going to the CFCASEDEFAULT. I would appreciate any ideas on what could be happening here. I'm at a complete loss as to what else to check out. And with how simple this application is, I can resort to de-fuseboxing it to get it to work. I'm just curious and even a tad worried about this type of problem popping up on a larger project. Thank you! == - == == - ==== - == Allen Graetz USI - Web Application Programmer 1-800-USINTERNET x241 612-253-3241 == - == == - ==== - == ** Index.cfm Code ** == - == == - ==== - == -- 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.
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.
RE: Lazy Application
Or an animated Gif. --K Katrina Chapman Consultant Ameriquest Mortgage dwatts@figlea f.com (Dave To: <[EMAIL PROTECTED]> Watts) cc: <[EMAIL PROTECTED]> Subject: RE: Lazy Application 05/18/00 08:02 AM Please respond to cf-talk > Is there a time function in CF. WhatI want to > accomplish is putting the data on the screen one by > one with a gap of few seconds. > > For example: > > Welcome to > > My web site! > > Hope > > you are not bored! No, you have to write all your output back to the browser at one time from CF. If you wanted to accomplish the same effect, you could use JavaScript. 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: Is this a valid SQL query?
I don't think that's the answer. It is possible that you don't have any matching entries in your database. --Katrina Katrina Chapman Consultant Ameriquest Mortgage Trip Ward com> cc: Subject: RE: Is this a valid SQL query? 05/15/00 05:42 AM Please respond to cf-talk my "two" cents . . . depending on your specific application, you may want to use the tworelatedselects tag . . . . I believe you can get it from the Developer Exchange in the Allaire site. Trip Ward Webmaster EBStor.Com (703)393-7930 ext. 273 > -Original Message- > From: WL [SMTP:[EMAIL PROTECTED]] > Sent: Sunday, May 14, 2000 9:49 AM > To: [EMAIL PROTECTED] > Subject: Re: Is this a valid SQL query? > > > > Looks OK... by not working, I assume you mean that you get no results > returned. > > yeah. It just keeps on loading, but nothing happens. Could this be > because > I'm running CF Express? I haven't yet experienced a problem like this - > usually I'm at fault(!) and it tells me so, or it says CFXpress doesn't > support this function. But with this, it just doesn't do anything. > > Any ideas? > > Thanks > > Will > > > > > You might add: > > > > sub_categories.cat_id > > > > to your SELECT clause and remove the WHERE clause... > > > > You will see what the actual data is (could be a lot of data). > > > > HTH > > > > Dick > > > > At 2:19 PM +0100 5/14/2000, WL wrote: > > >Hi, > > > > > >Is this OK for a SQL query? The 2 tables in question are categories > and > > >sub_categories. Everything seems ok, but it's not working.. > > > > > > > > > Select categories.ID, categories.cat_name, sub_categories.sub_id, > > >sub_categories.sub_name, sub_categories.sub_descript > > > > > > FROM categories,sub_categories > > > > > > WHERE sub_categories.cat_id = categories.ID > > > > > > > > > > > > > > >Thanks, > > > > > >Will > > > > > > -- > > > 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: Slightly OT: Lighten things up a little
Actually it's a Big red 95 Cougar XR7. After having seen a 911 UNDER a Sedan DeVille I will never drive a small car. --Katrina Katrina Chapman Consultant Ameriquest Mortgage "Steve Reich" ksoft.com> cc: Subject: Re: Slightly OT: Lighten things up a little 05/11/00 09:09 PM Please respond to cf-talk Since we're off the subject, I think it would be cool to have a site with some sort of profile for each CF-Talk member. A short bio, maybe link to a resume, and a picture. Then we could put faces to the names. I mean, is Dave Watts *really* 10 feet tall like I imagine? Does Katrina Chapman actually drive a little red convertable Miata? Does Fred Sanders *really* wear a cowboy hat and spurs? Ahhh, if only I had more time!! :-) Steve -- 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: Is this a bug?
Try
INSERT INTO TempTable(Identifier,Resource)
VALUES('#thisKey#','#PreserveSingleQuotes(stWestcar["#thisKey#"].Resource)
#');
--Katrina
Katrina Chapman
Consultant
Ameriquest Mortgage
"Sean Brown"
.com>cc:
Subject: Is this a bug?
05/11/00
04:01 PM
Please
respond to
cf-talk
I have a Struct "stWestcar". And stWestcar["#thisKey#"].Resource = "This is
Sean's test".
I'm doing a SQL Insert and I know that CF normally takes care of single
quotes inside of CFQUERY so I don't worry about it.
INSERT INTO TempTable(Identifier,Resource)
VALUES('#thisKey#','#stWestcar["#thisKey#"].Resource#');
Well, I get the SQL Error, and it turns out the above SQL is being passed
off to SQL-Server as: "INSERT INTO TempTable(Identifier,Resource)
VALUES('test','This is Sean's test');" Which of course is an invalid SQL
Statement. I scratch my head, and recall how hard it usually is for me to
get single quotes into SQL statements when I need to, hence the need for
PreserveSingleQuotes()
So above the SQL Statement, I take the Struct Value out and put it into a
simple variable and use that simple variable in the SQL, and of course it
works.
INSERT INTO TempTable(Identifier,Resource)
VALUES('#thisKey#','#SafeText#');
Now why is that? anyone have a pointer to where I was supposed to read
about
this behavior? I even tried using a StructFind(stWestcar["#thisKey#"],
"Resource") in the SQL, that didn't work either Why can it interpolate
the value of a simple variable and do the magic-single-quote-escape-trick
but can't interpolate a complex one. strange?...
/s
___
Sean Brown<[EMAIL PROTECTED]>
http://www.westcar.com/
"Either way you get your dog back"
-Anonymous
___
-Original Message-
From: Scott Weikert [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 11, 2000 1:29 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Client and session variables same thing different
Do some experiments. Set your session timeout to something ridiculously
low,
say 2 minutes - and hit pages at 1:30 a few times, see if your session
sticks around, and then wait 2+ min a few times, and see if it conks out :)
--Scott
> -Original Message-
> From: Ricq Pattay [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 11, 2000 8:57 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: Client and session variables same thing different
>
>
> Huh. That's now how it seems on my end, but I must be
> spending too much time
> testing this thing as a developer instead of as a
> pseudo-user. :-) Thanks.
--
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: Slightly OT: Lighten things up a little
I'm the only one in CA. It generally works that way though. Only one per state. --Katrina Katrina Chapman Consultant Ameriquest Mortgage Jennifer cc: Subject: Re: Slightly OT: Lighten things up a little 05/11/00 10:42 AM Please respond to cf-talk I bet I'd be the only person in Louisiana with that plate... At 09:19 AM 5/11/00 -0700, you wrote: >What about CFCHICK? > >--Katrina > > >Katrina Chapman >Consultant >Ameriquest Mortgage > > > > Todd Ashworth cc: Subject: Re: Slightly OT: Lighten things up a little > 05/10/00 > 03:46 PM Please respond to cf-talk > > >When you have a license plate that says CFXLR8 .. hmmm .. I would give that >a geek-factor of about 9.2 ;) > > -- > >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: How to secure PDF file? - The Flame goes on.
You can restric permissions to that directory so that noone but the cfserver has permission to access it. That way when they try to access it directly through the URL and IIS (or PWS whatever you have running) makes the call they will get a permission denied error. --Katrina Katrina Chapman Consultant Ameriquest Mortgage "Dave Hannum" edu> cc: Subject: Re: How to secure PDF file? - The Flame goes on. 05/11/00 06:55 AM Please respond to cf-talk I'm asking a related question for the System Admins of the group. To do something like this (have PDF's in a secure directory) can you do on NT like you can on Unix/Linux and that is have a directory secured that you cannot make calls to it directly from the web, but any application you have running in a parent directory that is accessable from the web can call it? Let me be more specific. I work with an ISP that has this setup (Linux/Apache). Any html or cgi you want available to be called directly via URL, you set to permission 755. But, if you want to secure a directory or script, you change the permissions to 700, and only another script in your directory (or account above that directory) can call the file. Can you do this on NT? If so, can you not put your PDF's in a subdirectory and call them from a CF script? This would prevent somebody from sniffing the URL and gaining access to them. Just a thought . . . Dave = "Always Drink Upstream From The Herd!" David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 -- 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: Slightly OT: Lighten things up a little
What about CFCHICK? --Katrina Katrina Chapman Consultant Ameriquest Mortgage Todd Ashworth cc: Subject: Re: Slightly OT: Lighten things up a little 05/10/00 03:46 PM Please respond to cf-talk When you have a license plate that says CFXLR8 .. hmmm .. I would give that a geek-factor of about 9.2 ;) -- 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: Slightly OT: Lighten things up a little
It's in response to WWJD What Would Jesus Do? WWBFD is What Would Ben Forta Do? --Katrina Katrina Chapman Consultant Ameriquest Mortgage "Eric Dawson" cc: Subject: Re: Slightly OT: Lighten things up a little 05/09/00 09:42 AM Please respond to cf-talk in ignorance what does wwbfd stand for. I can have the stickers done in a hour, and shipped in two if I had the artwork and the orders. From: Kevin Marshall <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Slightly OT: Lighten things up a little Date: Tue, 09 May 2000 08:43:06 -0500 I know, I know, cf-community... Anyway, who's selling the WWBFD bumper stickers? I'll buy one! Kevin At 06:58 AM 5/9/00 -0500, you wrote: >- Have a bumper sticker reading 'WWBFD'. -- 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. Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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: CFML be gone!
You can do a search on Subject: Re: CFML be gone! 05/09/00 07:45 AM Please respond to cf-talk You can right your own custom form validation with javascript. Nothing good comes easy! Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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: REVERSE QUESTION --- Is there anything that Cold Fusion can do that ASP can't do?
Well I don't know how this compares to ASP but. Cold Fusion can have a fairly complex site, http://starwars.hasbro.com, up in a month. --Katrina Katrina Chapman Consultant Ameriquest Mortgage "Alice and Harvey Backer To: <[EMAIL PROTECTED]> and Binder" cc: can't do? 05/08/00 06:04 PM Please respond to cf-talk Hi Cold Fusion Users, Recently, someone asked if there is anything that ASP can do that COLD FUSION can't do. Many people responded with some extremely small things. So, I would like to ask the opposite question: Is there anything that COLD FUSION can do that ASP can't do? Alice -- 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: odbc error
Can we see the query that is causing this problem? --Katrina Katrina Chapman Consultant Ameriquest Mortgage "Shane Witbeck" nctum.com> cc: Subject: odbc error 05/08/00 03:39 PM Please respond to cf-talk Can anyone give suggestions why I am getting the following error when selecting specific fields from an Access db, yet when I use a "select *" everything is fine? [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'id' as part of an aggregate function. thanks. Sincerely, Shane Witbeck Webmaster [EMAIL PROTECTED] www.digitalsanctum.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: "Phantom" Form submissions
Are you submitting the form yourself? If not how do you know that it's even being submitted at all? Also can we see a URL or the code? --Katrina Katrina Chapman Consultant Ameriquest Mortgage "Gregory Harris" sweep.com> cc: Subject: "Phantom" Form submissions 05/08/00 03:08 PM Please respond to cf-talk Hello everyone, for my website, I built a generic form feedback script. Takes the form variables, submits to a database, then emails me the form variables. Nothing terribly fancy. However every so often (approximately 1 in 4 submissions) a "phantom" submission occurs, where I get a positive response from the server indicating no errors (I even checked the source code from the output page), but nothing goes in the database, and no emails are generated. Any ideas as to what might be going on, anyone experienced this? Thanks! Gregory Harris (tekiegreg) [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: Val() doesn't work like I need it to
Having now read this post perhaps my answer to your last post was
premature.
You're using the wrong function.
>From the Docs
Returns a number that the beginning of a string can be converted to.
Returns 0 if conversion is not possible.
IE
#val(123boy)#
Displays as 1
If you want to simply remove non allowed characters you have to do a series
of replaces.
IE:
Replace("$23.31", "$", "", "ALL")
Will remove the $ sign.
Replace("1,120.1", ",", "", "ALL")
Will remove the comma.
--Katrina
Katrina Chapman
Consultant
Ameriquest Mortgage
Reuben King
cc:
Subject: Val() doesn't work like I need
it to
05/08/00
10:40 AM
Please
respond to
cf-talk
Val("$12.31") returns 0. Val("1,120.1") returns 1.. This is starting to
piss me off. Am I missing something here? Am I going to have to write
a custom tag to simply convert a human-readable number into a number-
number for insertion into an Oracle column? (Oracle's to_number() is
just as useless, if not more so! urg.)
TIA,
-R
--
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: Stupid question: How to handle $ values?
Try Val(Replace("$23.12", "$", "", "ALL"))
--Katrina
Katrina Chapman
Consultant
Ameriquest Mortgage
Reuben King
cc:
Subject: Stupid question: How to handle $
values?
05/08/00
10:36 AM
Please
respond to
cf-talk
If I try to use val("$23.12"), it returns 0. Other than doing a check
for the first character being a dollar sign, is there an easier way to
do this?
Thanks,
-RK
--
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: Imp Atten: New Virus Info
Don't forget this one. http://www.symantec.com/avcenter/venc/data/wobbler-hoax.html --Katrina Katrina Chapman Consultant Ameriquest Mortgage "Fred T. Sanders" taway.com>cc: Subject: Re: Imp Atten: New Virus Info 05/08/00 09:09 AM Please respond to cf-talk *sigh*.. anytime I see AOL, IBM, and Compaq mentioned in a virus alert I think "oh great another virus hoax" and I'm usually right. This one is no different: http://www.symantec.com/avcenter/venc/data/win.a.holiday.htm l I know with all the nifty new WORMS that have recently plagued the list and millions of other computers, you might be inclined to spread every freakin' email like this you get, and thanks for the thought, but. PLEASE actually research the warning before spaming it over gods green earth and into our mailboxes. Thanks :) Fred - Original Message - From: "Kalyan Chakravarthy Modali" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 08, 2000 10:37 AM Subject: Imp Atten: New Virus Info > Don't now up to what extent it is true. > But Prevention is better than Cure > > > > Subject: Virus! > Author: John Erickson at AIRSEA-POST-OFFICE > Date:04/14/2000 11:42 AM > > > 1. There is a new virus - WOBBLER. It will arrive on e-mail > titled CALIFORNIA. IBM and AOL have announced that it is very > powerful, more so than Melissa, there is no remedy. It will eat all your > information on the hard drive and also destroys Netscape Navigator and > Microsoft Internet Explorer. Do not open anything with this title and > please pass this message on to all your contacts and anyone who uses your > e-mail facility. Not many people seem to know about this yet so propagate > it as fast as possible. > > 2. If you receive an e-mail titled "Win A. Holiday" DO NOT > open it. It will erase everything on your hard drive. Forward this letter > out to as many people as you can. This is a new, very > malicious virus and not many people know about it. This information was > announced yesterday morning from Microsoft. > > Thank You, > Neil Ferrick > Compaq Computer Corporation > > > Andrew Lim > www.goldquest.com.my/alimo2k > __ > Make A Buck Or Two @ TheMail.com - Free Internet Email > Sign-up today at http://www.themail.com/ref.htm?ref=356934 > > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=li 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=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: Forcing a query refresh
How do you know that it's not running the query again? What browser are you using. If you hold control while you click refresh that will force it to make the call back to your server for the latest information. --Katrina Katrina Chapman Consultant Ameriquest Mortgage dford@midrangecom puting.com (Doug To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Ford)cc: Subject: Forcing a query refresh 05/03/00 09:33 AM Please respond to cf-talk Hi Folks, What's the best way of forcing a query to always run instead of it being cached? I am pulling a record from a DB and displaying it, but when I do a refresh/reload it doesn't run the query again. What's the best way of doing that? Thanks, Doug -- 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: string to list???
Can you give an example of what your trying to do? Like: "I'm trying to turn 1,2,3 into 1&2&3" --Katrina Katrina Chapman Consultant Ameriquest Mortgage Nagesh Kumar Deva To: "Cold Fusion (E-mail)" <[EMAIL PROTECTED]> Subject: string to list??? 05/03/00 09:05 AM Please respond to cf-talk hello everybody, is there a way to convert a string into a list?? the delimeter in string & list to be space. is this possible?? plzz help me, i am stuck with it. thanx in advance nag -- 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: OT: joining tables
You need to join the tables. There has to be a field in both tables that has the same data like client id. Is there such a field? --Katrina Katrina Chapman Consultant Ameriquest Mortgage Shawn Regan com> cc: Subject: OT: joining tables 05/02/00 09:24 AM Please respond to cf-talk This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFB452.F8791E40 Content-Type: text/plain; charset="iso-8859-1" hey people, i'm doing a join in this query: SELECT CLIENTS.CLIENT_NAME, PRODUCTS.PRODUCT_NAME, CATEGORY.CAT_ID, CATEGORY.CATEGORIES FROM CLIENTS, PRODUCTS, CATEGORY WHERE CLIENTS.CLIENT_NAME='#session.client#' I have only one record in the database right now for testing. so there is only one client. But this query keeps pull out the one client as two different clients. I can't figure it out. Shawn Regan -- 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: javscript mouseovers don't cache in .cfm pages
They work fine for me. Katrina Chapman Consultant Ameriquest Mortgage "guru.com" thome.net> cc: Subject: javscript mouseovers don't cache in .cfm pages 05/02/99 09:35 AM Please respond to cf-talk This is a multi-part message in MIME format. --=_NextPart_000_005C_01BE94FC.E091E600 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable For some reason, whenever I incorporate javascript mouseovers in a .cfm = page, they won't cache, so every time I roll over them the browser has = to download them before they display. The exact pages in question work = fine if I save them with a .htm extension. Here are a couple of example sites where this is happening: http://www.prestigemb.com.au http://cfm.rickhart.com.au/ -- 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.
