FW: 2nd try: SQL query help

Anyone have any ideas? -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 11:00 AM To: CF-Talk Subject: OT: SQL query help Using SQL Server, how would I define a query to return ranges of ID's (primary key) where a tinyint field was not true?

RE: 2nd try: SQL query help

Sounds like a job for a stored procI don't think a simple query will do it for you. Get a good T-SQL book! Good luck. -- Josh Trefethen .:[ Exciteworks, Inc ]::[ http://exciteworks.com ]:. .::[ cf hosting on linux ]::[ consulting ]::[ expertise ]::. -Original Message-

RE: Application.cfm not being included / CFMX

If it is a Unix server your file should be Application.cfm, the capitalization is important. Even if it isn't a *nix server, you should still name the file Application.cfm :) Jeremy -- Jeremy Allen Application Architect elliptIQ Inc. [EMAIL PROTECTED]

RE: 2nd try: SQL query help

Quoting Josh Trefethen [EMAIL PROTECTED]: Sounds like a job for a stored procI don't think a simple query will do it for you. Simple was not a requirement. I just hope performance is not a requirement either ;-) SELECT MIN(t1id) AS minimum, t2id AS maximum,

SOT: Discovering CFC's - confusion in 'Making Use of the Supertype'

I guess this is aimed at Hal Helms and the Techspedition people... I've been to your site and found no errata on an apparent error I've found in Discovering CFC's. I'm liking the book so far, being intermediate to advanced in ColdFusion, but lost (until now! ;-) with OO programming. Anyway, I've

Re: SOT: Discovering CFC's - confusion in 'Making Use of the Supertype'

OK, I'm close to the end of the chapter and I think I've got my head around the super workaround being detailed. Looking back, I think the text and code around p.67 are just jumbled in a couple of ways: - The use of the word super is a bit misleading. I'm guessing it's meant as a reminder that

RE: 2nd try: SQL query help

Jochem - you are a rock star - thanks for this! Performance is not an issue - I can run this once or twice a month late, late at night :) -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 02, 2003 12:04 PM To: CF-Talk Subject: RE: 2nd try: SQL

SQL Server reinstall and CF

Several months ago, I installed the SQL Server trial version in anticipation of doing more development work from home for my former employer. I went through the process of re-creating their database on my local server (with 100+ tables). (by the way, you're not given any warning when your 120

Obvious cfscript ?

New to monkeying with cfscript...and must be missing the obvious today: This is not resolving...meaning form.d_price[i] resolves as form.d_price rather than form.d_price1 in the first loop. cfscript for (i=1; i LTE form.clientloop; i = i +1)

Re: SQL Server reinstall and CF

Just an update . . . I found that if I rename these tables as backups and then export them into their original name (essentially creating new tables), it works ok. However, there are 110+ tables in this database, and I'd rather not have to do that for every table. Scott

Re: SOT: Discovering CFC's - confusion in 'Making Use of the Supertype'

- The use of the word super is a bit misleading. I'm guessing it's meant as a reminder that the described code is a workaround manual implementation of the OO super concept, but it comes across as a bit literal, esp. in references to cfset super.new() and cfinvoke component=#super# ... .

RE: SQL Server reinstall and CF

(by the way, you're not given any warning when your 120 day trial period is about to end, and once it ends, you're apparently SOL accessing those databases until you buy a version of SQL Server) You can always copy the databases to another SQL Server machine, and attach them. I bought

Re: Obvious cfscript ?

1. The form variable is a structure, not an array. 2. You can look over the variable fieldnames which is a list of all form fields sent. What formfields are being sent? More than one d_price? New to monkeying with cfscript...and must be missing the obvious today: This is not

Re: Obvious cfscript ?

You appear to be referring to an array in the form scope. Perhaps this is what you want: line_total[i] = form[d_price#i#] * form[qty#i#]; Regards, Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ - Original Message - From: Eric Hoffman [EMAIL PROTECTED] To: CF-Talk

RE: Obvious cfscript ?

Try cfscript for (i=1; i LTE form.clientloop; i = i +1) line_total[i] = form.[d_price i] * form.qty[i]; /cfscript HTH -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 2, 2003 18:42 To: CF-Talk Subject: Obvious cfscript ?

RE: PCodeRuntimeContextImp::executeSQL

Anyone want to take a shot at why this query throws a PCCode error every once in a while? CF5... cftry cfquery name=qry_prod datasource=#variables.dsn# cachedafter=01/01/01 select *, lower(keywords) as l_keywords from v_products where WebStoreID = #request.webStoreID# /cfquery Maybe

RE: Obvious cfscript ?

I am sending 12 d_price all sequentially numbered...trying to learn how handle such...and there are 25 other fields coming with it... :-) Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions -Original Message- From: Michael

RE: Obvious cfscript ?

This seems to have me on the right trackthanks a million! Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 02, 2003 1:07 PM To:

Re: Obvious cfscript ?

Try one of these. // Using the fieldnames list for(field=1;field LTE listlen(fieldnames), field=field+1) { if (listgetat(fieldnames, field) contains d_price) { do d_price work using listgetat value } } // using the form structure for (field in form) { if (field contains

RE: SOT: Discovering CFC's - confusion in 'Making Use of the Supertype'

Thank goodness, I did that too and thought I was just a bit inept. Kind Regards - Mike Brunt Webapper Services LLC Web Site http://www.webapper.com Blog http://www.webapper.net Webapper Web Application Specialists -Original Message- From: Matthew Walker [mailto:[EMAIL

RE: MPSB03-02 - Using Windows NT Authentication and Windows file permissions

Is there any way to use the check that file exists setting in IIS while using SES URL's. Example: http:www.mysite.com/index.cfm/fuseaction/display/ No, I don't think so, since the file doesn't actually exist! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496

CFPOP

Hi, I have written a script which checks for AutoResponders on the Mail Server and if found, deletes it from there. But there is some problem with the problem while deleting the messages. Like if you delete first messages and the last message it gives error. Following is a copy of the script:

CFPOP

By the way, I am using CF 5.0 Pro. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ:

RE: MPSB03-02 - Using Windows NT Authentication and Windows file permissions

Yikes - that would mean we would have to recode basically every app we have ever made that has and web accessible admin directory. Do you think it would be safe to use a cold fusion scripted login routine instead of ACL's and WIndows Authentication. I recall seeing recently that web based

Using CF to pull content from with div tags for printing

Hello list - I have been messing with this- but I do not know how to complete a few aspects. I would like to control printing from a webpage that heavily uses CSS styles and positioning for layers. What I would like to do is supply a print button - on click - it would launch a 2nd window -

Re: MPSB03-02 - Using Windows NT Authentication and Windows file permissions

[EMAIL PROTECTED] wrote: Yikes - that would mean we would have to recode basically every app we have ever made that has and web accessible admin directory. Do you think it would be safe to use a cold fusion scripted login routine instead of ACL's and WIndows Authentication. If you can

Re: Using CF to pull content from with div tags for printing

Jason Miller wrote: I would like to control printing from a webpage that heavily uses CSS styles and positioning for layers. What I would like to do is supply a print button - on click - it would launch a 2nd window - and tag all the content from within a div tag OR a custom tag I put

Re: MPSB03-02 - Using Windows NT Authentication and Windows file permissions

If the ACL's rules still apply, are they enough to use to restrict access? At 10:42 PM 2/2/2003 +0100, you wrote: [EMAIL PROTECTED] wrote: Yikes - that would mean we would have to recode basically every app we have ever made that has and web accessible admin directory. Do you think it

RE: Using CF to pull content from with div tags for printing

Does it have to be in a pop-up window for some reason or can you just use existing CSS functionality to control what gets printed? Ken -Original Message- From: Jason Miller [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 02, 2003 7:43 PM To: CF-Talk Subject: Using CF to pull content

RE: Using CF to pull content from with div tags for printing

That sounds like quite a lot of work. Why not provide page that works for both monitor and printer? http://www.alistapart.com/stories/goingtoprint/ Not sure if they address anything that Eric's article doesn't, but here's a couple of other articles I had bookmarked from Evolt: Kissing Print

Re: MPSB03-02 - Using Windows NT Authentication and Windows file permissions

[EMAIL PROTECTED] wrote: If the ACL's rules still apply, are they enough to use to restrict access? Could you elaborate? What do you want to do? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4

RE: PCodeRuntimeContextImp::executeSQL

Does the database understand the date? With Oracle we have to use to_char or to_date (I forget at the moment). Chris Norloff -- Original Message -- From: Dave Watts [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Sun, 2 Feb 2003 14:31:28 -0500

Re: MPSB03-02 - Using Windows NT Authentication and Windows file permissions

Well, for an administrative tools directory, off the root of a site. If the ACL's deny access to the IUSR account, any unauthenticated user is prompted to enter their username/password to access the cfm files within that directory (or if the files them self have these ACL's). Is that enough

RE: Using CF to pull content from with div tags for printing

We are doing this using the cfimport feature of CFMX. We also do things like print the actual URL of a link in brackets next to a link in the print version automatically (something that surprisingly is also theoretically possible with CSS). This is done using something like cfimport

Re: MPSB03-02 - Using Windows NT Authentication and Windows file permissions

[EMAIL PROTECTED] wrote: Well, for an administrative tools directory, off the root of a site. If the ACL's deny access to the IUSR account, any unauthenticated user is prompted to enter their username/password to access the cfm files within that directory (or if the files them self have

Re: MPSB03-02 - Using Windows NT Authentication and Windows file permissions

I don't see that happening. I am still prompted for a u/p. Maybe because the server does not have Updater 2 installed. I'll doublecheck - thanks. brook At 01:12 AM 2/3/2003 +0100, you wrote: [EMAIL PROTECTED] wrote: Well, for an administrative tools directory, off the root of a site. If the

Slow Update

Hello Forum, I am trying to update an access database using a CF template which is taking ages for the job. No error is generated. When I try to accomplish the same job within Access by running a Macro (SQL Query) it takes less than half a minute for thesame job. Other CF pages with queries run

RE: Slow Update

Can you post the code you are using. Kind Regards - Mike Brunt Webapper Services LLC Web Site http://www.webapper.com Blog http://www.webapper.net Webapper Web Application Specialists -Original Message- From: DESIGN SHOP [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 1:45 PM

Strip characters?

Is there a clean and easy way to simply strip all characters from a field...so only integers remain? A custom tag or popular reg ex before I reinvent the wheel? Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions

Re: Slow Update

can we see your code? - Original Message - From: DESIGN SHOP [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, February 03, 2003 4:44 PM Subject: Slow Update Hello Forum, I am trying to update an access database using a CF template which is taking ages for the job. No

Re: Slow Update(SOLVED)

Thanks Just tried the code on a seperate machine after compacting the database. Worked like breeze. KR Srimanta - Original Message - From: Mike Brunt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 02, 2003 5:11 PM Subject: RE: Slow Update Can you post the

RE: Strip characters?

rereplace(form.field, [^0-9]+, , all) -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED]] Sent: Monday, 3 February 2003 2:22 p.m. To: CF-Talk Subject: Strip characters? Is there a clean and easy way to simply strip all characters from a field...so only integers

RE: Strip characters?

Doom of the clan of RegEx ninjas says: string = rereplace(string, '[^[:digit:]]', '', 'all'); grashopper. To train at the Dojo of the Regex: http://www.houseoffusion.com/cf_lists/index.cfm?method=threadsforumid=21 -- Ben Doom Programmer General Lackey Moonbow Software, Inc :

RE: Strip characters?

CFSET iNum = REReplace(sField, [^[:digit:]], , ALL) HTH -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED]] Sent: Monday, February 3, 2003 1:22 To: CF-Talk Subject: Strip characters? Is there a clean and easy way to simply strip all characters from a field...so only

Re: Strip characters?

cfset str = asd890sad7234(* cfset blah = rereplace(str, [^0-9]+, , all) cfoutput#blah#/cfoutput - Original Message - From: Eric Hoffman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 02, 2003 8:21 PM Subject: Strip characters? Is there a clean and easy way to

RE: Strip characters?

REReplace(string, [^0-9],,ALL) -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 02, 2003 7:22 PM To: CF-Talk Subject: Strip characters? Is there a clean and easy way to simply strip all characters from a field...so only integers remain? A custom

Updater2 FYI

I just installed the 2nd Updater. Started getting a funny error on this line of code: cfsetting enablecfoutputonly=no RequestTimeout = 500 It used to work (CFMX - updater1), but now it seems that it does not , but this does: cfsetting RequestTimeout = 500 enablecfoutputonly=no Just FYI,

alternate MX debug layouts?

Has anyone built a MX debug template that plays nice with layer based designs you wouldn't mind sharing? -- mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

RE: alternate MX debug layouts?

man, you aint kidding. im amazed that we have to have this never-ending scrolling right debug layout...WHY and no, the popup window doesnt suffice either :) waaa wahhh wa tony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, February

Invalid Object

This past weekend, I upgraded our server. I reinstalled ColdFusion MX, so reattached our MSSQL databases. Now when I try and perform ANY query on ANY database, I get this error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name

Re: Invalid Object

oi Cedric!! have you tried rebuilding those databases? A mate of mine had the same problem. He created new db's and imported all his info from the old and all worked fine. Genius I say. Critz Sunday, February 2, 2003, 10:25:23 PM, you wrote: CV This

RE: Invalid Object

This past weekend, I upgraded our server. I reinstalled ColdFusion MX, so reattached our MSSQL databases. Now when I try and perform ANY query on ANY database, I get this error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name

Array and Query Length

Can someone please tell me how an array or query stored in a session varible can be one length at the end of on page, then another length at the top of the next page? I have an array and query (tried same thing two different ways) with an arrayLen() and Query.Recordcount at the top of an

SOT: 2nd ColdFusion MX updater now available.

Softly, softly it comes. Note: Updater releases are cumulative, therefore, Updater 2 includes all fixes from Updater 1. You do not have to install Updater 1 before you install Updater 2. Grab it at http://www.macromedia.com/software/coldfusion/downloads/ == Peter Tilbrook Internet Applications

RE: Array and Query Length

Can someone please tell me how an array or query stored in a session variable can be one length at the end of on page, then another length at the top of the next page? I have an array and query (tried same thing two different ways) with an arrayLen() and Query.Recordcount at the top of

RE: MPSB03-02 - Using Windows NT Authentication and Windows file permissions

It is my understanding that unless you switch on Check that file exists nobody is asked for their u/p. This is not necessarily the case. I've been successfully using web server authentication (both Basic and Windows Authentication) with IIS 5 and CFMX. I suspect that it has to do with the way

Re: SOT: 2nd ColdFusion MX updater now available.

This has been out since mid December 2002. Is there a new one? I didn't see it.. Brook At 04:09 PM 2/3/03 +1100, you wrote: Softly, softly it comes. Note: Updater releases are cumulative, therefore, Updater 2 includes all fixes from Updater 1. You do not have to install Updater 1 before you

RE: MPSB03-02 - Using Windows NT Authentication and Windows file permissions

Yikes - that would mean we would have to recode basically every app we have ever made that has and web accessible admin directory. Do you think it would be safe to use a cold fusion scripted login routine instead of ACL's and WIndows Authentication. Why couldn't you just enable the Check

RE: 2nd ColdFusion MX updater now available.

Uhm.. Did I miss something? twirling around to see if Rod Serling is behind me | -Original Message- | From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] | Sent: Sunday, February 02, 2003 9:10 PM | To: CF-Talk | Subject: SOT: 2nd ColdFusion MX updater now available. | | | Softly, softly

RE: 2nd ColdFusion MX updater now available.

Softly, softly it comes. Note: Updater releases are cumulative, therefore, Updater 2 includes all fixes from Updater 1. You do not have to install Updater 1 before you install Updater 2. I hate to tell you this, but it's been out for a while - since 11 December, according to the release

RE: 2nd ColdFusion MX updater now available.

Hey Pete, that came out almost 2 months ago...but the occasional reminder never hurts. :-) -Stace -Original Message- From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 12:10 AM To: CF-Talk Subject: SOT: 2nd ColdFusion MX updater now available. Softly,

Re: SOT: 2nd ColdFusion MX updater now available.

The Internet takes a long time to get to Australia... :) (sorry Peter... no offense... I'll buy you a beer to make it up in a couple of weeks!) On Sunday, Feb 2, 2003, at 21:51 US/Pacific, brook wrote: This has been out since mid December 2002. Is there a new one? I didn't see it.. Brook

RE: Array and Query Length

Here it is Dave, I have only included the page that contains all of the cf code that does any real work (not just formatting or which link to show logic). If you want more, I will be happy to provide it to you, but I will let you know, as you can see by some of the statements, that I can verify

RE: SOT: 2nd ColdFusion MX updater now available.

It's a long swim. :) John Wilker Web Applications Consultant, Writer Macromedia Certified ColdFusion Developer Founder/President IE CFUG www.red-omega.com Whatever is wrong it is better than a poke in the eye with a sharp stick. Unless of course you just got poked in the eye with a sharp stick.