RE: Access on CFMX Linux?

2002-07-10 Thread Matt Liotta
You may be shocked to realize that I disagree. While conforming to the exact definition of an RDBMS doesn't require one to be ACID compliant, it is assumed that ACID compliance is a standard feature of a database. If you want to debate on definitions then surely I would lose. However, if you take

RE: Access on CFMX Linux?

2002-07-10 Thread Brian Scandale
Yeah, perhaps true but truthfully mySQL smokes as a readonly filesystem... Different tools for different problems. Hey while you're at it maybe one of you geniuses can help me get my head around my problem with CFMX vs CFM5 causing a Refresh to Repost the Form Data notice on the exact same

RE: Access on CFMX Linux?

2002-07-10 Thread Brian Scandale
Perhaps just dump the subscriber list to a csv file, and use that as the input to your app... Assuming it's a once a month affair it could work. At 11:14 PM 7/9/02, you wrote: Thanks Matt, Peter for your advise. The situation I'm in is my customer is given MS Access databases which contains

RE: Access on CFMX Linux?

2002-07-10 Thread Matt Liotta
Yeah, perhaps true but truthfully mySQL smokes as a readonly filesystem... Different tools for different problems. Indeed! Comparing MySQL to a traditional RDBMS for file system type operations is a favorite of MySQL benchmarks. Of course just about any file system worth its weight smokes

RE: CFMX caching...

2002-07-10 Thread Matt Liotta
The first question you have to ask yourself is, what changed? Are you sure the only difference is CFMX? What web server are you using? Are you now using CFMX's built-in web server instead of an external one like with CF 5? Generally speaking, page expiration is based on web server generated

RE: cfparam using CGI variables

2002-07-10 Thread Matt Liotta
Sure, no problem. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] -Original Message- From: Whiterod, David (PLNSA) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 11:19 PM To: CF-Talk

RE: filemaker

2002-07-10 Thread A . Little
I tried using the built in ODBC driver for FileMaker so CF could read the data, but the driver that comes with FM is really slow (this could also have been because of the design of this particular FileMaker db), the other odd thing that it took me a while to work out was that the FileMaker db

RE: CFMX caching...

2002-07-10 Thread Brian Scandale
At 12:55 AM 7/10/02, you wrote: The first question you have to ask yourself is, what changed? Just pulled CF5 off a dev machine and put CFMX up... then the trouble started. the same code still works well on a CF5 production machine. Are you sure the only difference is CFMX? What web server are

RE: Macromedia DevCon 2002

2002-07-10 Thread Erika L. Walker
I'd be willing to bet that if you notified MM when you registered with a list of the classes you were attending (which they would have anyway) that they might be able to work with you, ensuring maybe that you got a seat as close to the presenter as possible ... Making it easier to hear what they

RE: Macromedia DevCon 2002

2002-07-10 Thread Steve Green
I went to one in the UK a few months back .. It was excellent (tho maybe a little fast in some parts for some i found out after whilst chatting with them but the handouts made up for that), They had large stand speakers all up the side's of the room so hearing what was going on was very good, as

Access database macros

2002-07-10 Thread Tristram Charnley
Hi All I've a client who wants to upload large delimited text files and I will need a routine to import these into an Access table. I've already got an Access macro to do this and was wondering if there's a way to trigger this macro from CF. Can anyone help or suggest an alternative approach?

Re: Skimmin the list.......? [oT]

2002-07-10 Thread Michael Dinowitz
The old archives then. The new archives do not show a persons email address unless the person is using an email package that does not show their 'normal' name. (http://www.houseoffusion.com/cf_lists/index.cfm?method=messagesthreadid=13814forumid=4) Below is the start of an article I'm writing

RE: Skimmin the list.......? [oT]

2002-07-10 Thread Justin Greene
I have been using the same Spamex Disposable Email Address (http://www.spamex.com) on this list for 18 months and this is the only place that the address has been used and my real email address is in the list going back to the very beginning, but I have not received the email in question to

strange cfmail problem: double post

2002-07-10 Thread Will Swain
H Apologies for the long email. I have experienced a very strange CFmail problem, and I'm not entirely sure if it's not someone messing with me. Basically, I have some code that sends an email to a box office, with the details of a ticket request, the individuals name and address and a

RE: Skimmin the list.......? [oT]

2002-07-10 Thread Brad Roberts
What's the difference in spamex.com and setting up a wildcard? For instance, if your website asks for my email address, I'll put [EMAIL PROTECTED] If I get junk from that address, I know who's responsible. Plus, it's easier to remember which disposable address I entered for your site. -Brad

Re: Access on CFMX Linux?

2002-07-10 Thread Bill Wheatley
lol someone just has a little chip on the shoulder. Its ok though nobodies perfect Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: Matt Liotta [EMAIL PROTECTED] To: CF-Talk

Re: Access on CFMX Linux?

2002-07-10 Thread Lawrence B. Afrin, M.D.
David -- Ignoring, for the moment, the raging battle between the purists and practicalists as to what distinguishes a real database :-) , there are at least three ways I can think of to solve your problem: (1) Buy a Linux ODBC driver for Access. I don't know if such a beast exists; maybe

[whitehat] SQL Injection MS-SQL

2002-07-10 Thread Wjreichard
Is replacing single quotes with double single quote sufficient to stop sql statements being injected into form fields? Does one need to check for variations of unicoded single quotes? __ Structure your ColdFusion code with

Re: onTap chat room...

2002-07-10 Thread S . Isaac Dealey
SID http://www.turnkey.to/talkontap SID It's the first commercial release. Still can't get the chat box to display in Moz 1.0. Is this something you're working on? Oh hey Chris, I'm sorry I forgot to mention this in my last post... Yes I'm working on it ... I haven't had a spare moment to

Speaking of double quotes

2002-07-10 Thread Tyler Silcox
Since upgrading to CFMX, cfqueryparam is transmuting all my single quotes into double quotes when inserting a string into the db. Is this a bug, or something else? (i.e.: is it my fault?) Right now, it looks like I have to go through and remove all of the cfqueryparam's I've been using over

RE: CFMX editors...

2002-07-10 Thread Alex Hubner
Brian, HomeSite+ is an excellent choice in the case you're not able to buy CFStudio5. It's almost the same product and is available under Dreamweaver MX (it's not the same software). It's possible buy HomeSite+ separately? []'s Alex -Original Message- From: Brian Scandale

RE: [whitehat] SQL Injection MS-SQL

2002-07-10 Thread Mark A. Kruger - CFG
What about injection attacks involving non character type fields? How about checking for semi-colons? greater than or less than? SQL key words? Personally, I use Cfqueryparam to give me strict datatyping and a measure of security (plus it really boosts performance). -mk -Original

RE: Skimmin the list.......? [oT]

2002-07-10 Thread Erika L. Walker
This is what we do as well. Very effective and easy to remember --- if you have the ability to have a catch-all on your domain name, that only you receiveSince I am the admin of ALL email addresses for us, I catch all the wildcards. Erika

RE: Regular Expressions/Speed

2002-07-10 Thread Ben Doom
Disclaimer: I learned on Perl, so every once in a while, my syntax gets garbled between Perl and CF. Either forgive me or ignore me. There are one or two things you can do to optimize regexps in general. First, maximize the length of any mandatory fixed string. That is, if you know a

RE: Skimmin the list.......? [oT]

2002-07-10 Thread Justin Greene
What you describe is typically called a tagged email address and it is the same premise that Disposable Email Addresses work on. If you are a mail admin, you can easily create tagged addresses as you describe, however Disposable Email Address Services offer many conveniences that make them

RE: CFMX editors...

2002-07-10 Thread Jeffry Houser
At 10:29 AM 7/10/2002 -0300, you wrote: Brian, HomeSite+ is an excellent choice in the case you're not able to buy CFStudio5. It's almost the same product and is available under Dreamweaver MX (it's not the same software). It's possible buy HomeSite+ separately? It is not available

RE: Managing list subscriptions (was Skimmin the list.......? [oT ])

2002-07-10 Thread Justin Greene
Personally, I avoid using catch all addresses. The first time you get hit with a dictionary attack to your mail server and have 50,000+ messages in your catch all address mailbox you will wish you assigned the addresses one by one. Using a catchall also makes it diffucult to turn off the

Re: Regular Expressions/Speed

2002-07-10 Thread Michael Dinowitz
Ben is forgetting that CF 5 and earlier RegEx are greedy and his example will get a lot more than just from Ben to the period. It'll get from Ben to the last period on the page or string. This would work better in CF5 and earlier Ben is [^.]*\. Note that there's really just one type of

Re: onTap chat room...FLASH and Moz

2002-07-10 Thread Zac Spitzer
S. Isaac Dealey wrote: SID http://www.turnkey.to/talkontap SID It's the first commercial release. Still can't get the chat box to display in Moz 1.0. Is this something you're working on? Oh hey Chris, I'm sorry I forgot to mention this in my last post... Yes I'm working on it ... I

Re: Regular Expressions/Speed

2002-07-10 Thread Michael Dinowitz
BTW, thanks for reminding me I have to write up a section on optimal RegEx. Michael Dinowitz Master of the House of Fusion http://www.houseoffusion.com - Original Message - From: Ben Doom [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 10, 2002 9:36 AM Subject:

Re: Access on CFMX Linux?

2002-07-10 Thread Jochem van Dieten
Lawrence B. Afrin, M.D. wrote: David -- Ignoring, for the moment, the raging battle between the purists and practicalists as to what distinguishes a real database :-) , there are at least three ways I can think of to solve your problem: (1) Buy a Linux ODBC driver for Access. .. (2)

Re: onTap chat room...FLASH and Moz

2002-07-10 Thread Zac Spitzer
Error: document.swf_TalkOnTap.SetVariable is not a function Source File: http://www.turnkey.to/talkontap/index.cfm?talkaction=ENTERuniqueid=5A00E13C-5B88-48D2-8866B6A91CA3657Dnick=4534534room=Lobby Line: 43 I have noticed that mozilla is very tricky with flash sometimes correction, it

CF4.5 Error/Glitch Saving Structure to App Scope

2002-07-10 Thread BEN MORRIS
I have gotten an odd error twice in the past several weeks. In both cases, my code was fine by any standard and had been working for about a year. Then all of a sudden, one line of code was causing an error. In the most recent case, it was storing a query in the application scope.

Issue: Trying to loop through a query and trim all the fields in the table before I output them without having to hardcode each field.

2002-07-10 Thread James Blaha
Hello All: Issue: Trying to loop through a query and trim all the fields in the table before I output them without having to hardcode each field. . Sincerely, James Blaha CFQUERY NAME=JobApplicants DATASOURCE=HRWebAgent SELECT * FROM dbo.tApply /CFQUERY CFOUTPUT CFLOOP

RE: Regular Expressions/Speed

2002-07-10 Thread Ben Doom
: Ben is forgetting that CF 5 and earlier RegEx are greedy and his : example will get a lot more than just from Ben to the period. : It'll get from Ben to the last period on the page or string. : This would work better in CF5 and earlier : Ben is [^.]*\. : Note that there's really just one type

Re: Regular Expressions/Speed

2002-07-10 Thread Michael Dinowitz
Have you played with the MX RegEx any? : Ben is forgetting that CF 5 and earlier RegEx are greedy and his : example will get a lot more than just from Ben to the period. : It'll get from Ben to the last period on the page or string. : This would work better in CF5 and earlier : Ben is

RE: Issue: Trying to loop through a query and trim all the fields in the table before I output them without having to hardcode each field.

2002-07-10 Thread Raymond Camden
Why not trim in the query? select rtrim(ltrim(col)), etc === Raymond Camden, ColdFusion Jedi Master for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda

Re: Regular Expressions/Speed

2002-07-10 Thread S . Isaac Dealey
Ben is forgetting that CF 5 and earlier RegEx are greedy and his example will get a lot more than just from Ben to the period. It'll get from Ben to the last period on the page or string. This would work better in CF5 and earlier Ben is [^.]*\. Note that there's really just one type of

Re: onTap chat room...FLASH and Moz

2002-07-10 Thread S . Isaac Dealey
S. Isaac Dealey wrote: SID http://www.turnkey.to/talkontap SID It's the first commercial release. Still can't get the chat box to display in Moz 1.0. Is this something you're working on? Oh hey Chris, I'm sorry I forgot to mention this in my last post... Yes I'm working on it ... I

Re: Regular Expressions/Speed

2002-07-10 Thread Michael Dinowitz
I'm not sure what you mean by your question. Rewrite their existing expressions from what? Perl? Maybe. The new syntax is very Perl-like. -- The ? is a new 'command' in MX RegEx that tells the previous special character to only operate as many times as needed but not more. For example,

RE: Regular Expressions/Speed

2002-07-10 Thread Ben Doom
Ben is [a-zA-Z ]*?\. : would work in MX. Note the ? after the asterisk. it says get all of a-z : but only as many as needed to fulfill the requirements. Be : stingy. But its : still doing more comparisons. If the character an a? a b? a c? etc. : : Is the ? in that string part of an attempt on

RE: Regular Expressions/Speed

2002-07-10 Thread Ben Doom
: Have you played with the MX RegEx any? Nope. We're running CF 5 here. After working in Perl for years, I'll freely admit (gripe? yell? complain bitterly?) that the CF 5 regexps don't quite stack up. Is the CFMX RexEx parser any better? Not that that'd convince my boss to upgrade. If it

Re: Regular Expressions/Speed

2002-07-10 Thread Michael Dinowitz
CF RegEx has been greedy from day 1. The new ? addition gives the option for stingy matches. : Is the ? in that string part of an attempt on MM's part to not make people : have to rewrite their existing expressions, or is that just the way it : works? Hmm. That's the way it works in

RE: Regular Expressions/Speed

2002-07-10 Thread Raymond Camden
Nope. We're running CF 5 here. After working in Perl for years, I'll freely admit (gripe? yell? complain bitterly?) that the CF 5 regexps don't quite stack up. Is the CFMX RexEx parser any better? Much. It's very close to be being 100% compat with Perl.

Re: Issue: Trying to loop through a query and trim all the fields in the table before I output them without having to hardcode each field.

2002-07-10 Thread Jamie Jackson
Congratulations, you win the prize for longest subject line. :D I'd trim in the query itself, but if you want to: cfquery name=jobapplicants cfscript for (i=1; i LTE listlen(jobapplicants.columnlist); i=i+1) { colName = listgetat(jobapplicants.columnlist, i);

RE: Best e-mail regex?

2002-07-10 Thread Chris Lofback
This code permits addresses like [EMAIL PROTECTED] and [EMAIL PROTECTED]. Are they valid? Which leads me to the question: where can I find the specs for what characters are allowed in what places in a properly formatted email address? I looked through the RFCs but couldn't find this--or maybe

Re: onTap chat room...FLASH and Moz

2002-07-10 Thread Zac Spitzer
S. Isaac Dealey wrote: S. Isaac Dealey wrote: SID http://www.turnkey.to/talkontap SID It's the first commercial release. Still can't get the chat box to display in Moz 1.0. Is this something you're working on? Oh hey Chris, I'm sorry I forgot to mention this in my last post... Yes I'm

Re: onTap chat room...FLASH and Moz

2002-07-10 Thread Thane Sherrington
At 10:28 AM 10/07/02 -0400, S. Isaac Dealey wrote: Just as an fyi, I don't believe that page is performing the Flash 6 check and producing the prompt to install it. It produced the prompt for me. IE 5.5. T __ Your ad could

Re: onTap chat room...FLASH and Moz

2002-07-10 Thread S . Isaac Dealey
Error: document.swf_TalkOnTap.SetVariable is not a function Source File: http://www.turnkey.to/talkontap/index.cfm?talkaction=ENTERuniqueid=5A00E 13C-5B88-48D2-8866B6A91CA3657Dnick=4534534room=Lobby Line: 43 I have noticed that mozilla is very tricky with flash sometimes correction, it

RE: Regular Expressions/Speed

2002-07-10 Thread Dave Watts
Nope. We're running CF 5 here. After working in Perl for years, I'll freely admit (gripe? yell? complain bitterly?) that the CF 5 regexps don't quite stack up. Is the CFMX RexEx parser any better? Not that that'd convince my boss to upgrade. If it ain't broke, don't fix it, I

xPost: Weird CF Error

2002-07-10 Thread Timothy Heald
Has anyone seen this error before: bad_alloc: Out of Memory PCodeRuntimeContextImp::write I am running a very long query dumping into the custom tag cf_dump, and it blows after about 10 seconds of running. TIA Tim Heald ACP/CCFD :) Application Development www.schoollink.net Fusebox

Re: Best e-mail regex?

2002-07-10 Thread Howie Hamlin
The spec for this is in RFC 2821, page 36: http://www.imc.org/rfc2821 You may also want to check out page 30 of the older RFC (821) which may be a bit easier to understand. http://www.imc.org/rfc821 At any rate, characters in an email address (unless escaped by a \) can be any one of the

403 handler and CF code

2002-07-10 Thread Dimo Michailov
I have been trying to create a 403 error handler (that is when someone tries to hit a secure site without the HTTPS) and place some Cold Fusion code inside. I setup the 403 handler in IIS to point to a CFM template that displays the current template and recommends dynamically the correct

RE: 403 handler and CF code

2002-07-10 Thread Wallick, Mike
I don't know about 403's, but for my custom 404's I specify a URL for the error page, rather than a file (i.e. /index.cfm?fuseaction=home.404 as opposed to dsp_404.cfm). Know what I mean? Mike Wallick * Web Application Developer * [EMAIL PROTECTED] * 651.628.5377 *

RE: 403 handler and CF code

2002-07-10 Thread Dave Watts
I have been trying to create a 403 error handler (that is when someone tries to hit a secure site without the HTTPS) and place some Cold Fusion code inside. I setup the 403 handler in IIS to point to a CFM template that displays the current template and recommends dynamically the correct

Re: onTap chat room...FLASH and Moz

2002-07-10 Thread S . Isaac Dealey
At 10:28 AM 10/07/02 -0400, S. Isaac Dealey wrote: Just as an fyi, I don't believe that page is performing the Flash 6 check and producing the prompt to install it. It produced the prompt for me. IE 5.5. Oh great. :) That's good to know. Isaac Dealey www.turnkey.to 954-776-0046

RE: Javescript help

2002-07-10 Thread Bruce, Rodney S HQISEC/SIGNAL
Thanks that last little /g did it ;) -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 5:04 PM To: CF-Talk Subject: RE: Javescript help Check this out http://www.webreference.com/js/column5/ :-) -Original Message- From: Bruce,

Passing a list to a Stored Procedure

2002-07-10 Thread Jason
Sorry for the somewhat OT Post, but this is one of my better resources for CF I have I was wondering if anybody had any code snippets for passing a list to a SQL Server 2000 stored procedure. I have the CF front-end working fine but when I send the list (61755,61754) to the stored procedure I

Re: onTap chat room...FLASH and Moz

2002-07-10 Thread S . Isaac Dealey
hmmm... from what you've described it *sounds* like either you don't have the Flash 6 Player installed or there's something wrong with the player and it's not playing the movie ... otherwise you ought to at least see the history window and the buttons and the like... I'll have to take a

RE: Passing a list to a Stored Procedure

2002-07-10 Thread Wallick, Mike
Send each element of the list as it's own cfprocparam. Like this: cfstoredproc procedure=procedure datasource=#dsn1# returncode=No debug=No cfloop index=this list=#list# cfprocparam type=In cfsqltype=CF_SQL_INTEGER value=#this# /cfloop /cfstoredproc That will send the values to the

Re: 403 handler and CF code

2002-07-10 Thread Dimo Michailov
Thanks Dave and Mike for your suggestions, that worked like a charm!! Cheers, Dimo Dave Watts wrote: I have been trying to create a 403 error handler (that is when someone tries to hit a secure site without the HTTPS) and place some Cold Fusion code inside. I setup the 403 handler in IIS to

Sql 7 SHOWCONTIG

2002-07-10 Thread Bill Wheatley
I want to use CF to run a SHOWCONTIG and send the results via an email and i'm thinking of a way to get it to show em the results. Can i set the results into an OUT VARIABLE and then have CF take that out var and display that? DECLARE id int, indid int SET id = OBJECT_ID('tblBenefit')

RE: Passing a list to a Stored Procedure

2002-07-10 Thread Jason
When I try that I get the following error: [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function MasterAssignments has too many arguments specified. Great idea though, I will continue to work on it. Jason -Original Message- From: Wallick, Mike [mailto:[EMAIL

RE: Best e-mail regex?

2002-07-10 Thread Chris Lofback
Thanks, Howie. (And yes, those RFCs are pretty much indecipherable.) But the special list includes the period character which I see in email addresses all the time. How does that work? Thanks, Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761

RE: Passing a list to a Stored Procedure

2002-07-10 Thread Wallick, Mike
Make sure the length of the list you're passing is the same as or less than the number of parameters the stored proc expects. Mike Wallick * Web Application Developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com/ -Original Message- From: Jason [mailto:[EMAIL

Re: Best e-mail regex?

2002-07-10 Thread Howie Hamlin
It works that way becaue the address is defined as a dot-string as follows: dot-string ::= string | string . dot-string This means that the dot-string can contain dots. However, the string cannot contain dots. So, this is a valid address: [EMAIL PROTECTED] But, this is not: [EMAIL

RegEx Help

2002-07-10 Thread Dave Carabetta
I was wondering if I could get some help with some server-side numeric validation I'm doing. I've read Michael's RegEx tutorial at housoffusion.com but can't seem to get my tests working. I was trying to build RegEx's base on the following rules: 1. All numeric, whole numbers 2. All numeric,

RE: Passing a list to a Stored Procedure

2002-07-10 Thread Jason
I am not to sure what you mean, This is my first time working with SP's. The SP is expecting one variable, a list @ClientList, but the list could contain 1 element or many more. MY SP is at the bottem of this post Thanks Jason -Original Message- From: Wallick, Mike [mailto:[EMAIL

Re: Search Engine-Friendly URLs

2002-07-10 Thread Jamie Jackson
Thanks for the answers, folks. Jamie On Tue, 9 Jul 2002 17:27:42 -0400, in cf-talk you wrote: I wrote an ISAPI filter designed to only do the search engine safe url replacement, so it's pretty fast. You can get the DLL and source here: http://www.cfdev.com/products/ -pete -Original

Re: RegEx Help

2002-07-10 Thread Michael Dinowitz
'^(+-)? *[0-9.]+$' defined: ^ - start of the string (+-)? - might have a plus or minus * -may have 0 or more spaces from the start of the string OR from the plus or minus (if it exists) [0-9]+ - one or more numbers $ - end of the string. A string that starts with a plus or minus and only

Re: Issue: Trying to loop through a query and trim all the fields in the table before I output them without having to hardcode each field.

2002-07-10 Thread James Blaha
Jamie it didn't work. What about something like this? But its not working right. CFQUERY NAME=JobApplicants DATASOURCE=HRWebAgent SELECT * FROM dbo.tApply /CFQUERY cfoutput#JobApplicants.ColumnList#br/cfoutputP CFLOOP INDEX=I LIST=#JobApplicants.ColumnList# CFLOOP INDEX=II FROM=1

Re: Issue: Trying to loop through a query and trim all the fields in the table before I output them without having to hardcode each field.

2002-07-10 Thread Jamie Jackson
Duh, I meant: cfoutput query=jobapplicants ... /cfoutput Jamie On Wed, 10 Jul 2002 10:46:15 -0400, in cf-talk you wrote: Congratulations, you win the prize for longest subject line. :D I'd trim in the query itself, but if you want to: cfquery name=jobapplicants cfscript for (i=1; i LTE

RE: Issue: Trying to loop through a query and trim all the fields in the table before I output them without having to hardcode each field.

2002-07-10 Thread Raymond Camden
Ick ick ick. Remember you don't need to use evaluate for queries: cfset vCol = JobApplicants[column][rownum] === Raymond Camden, ColdFusion Jedi Master for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally

dynamic valuelist

2002-07-10 Thread Michael Dinowitz
The ValueList() function takes as its attribute the name of a query field. This is passed in without quotes (essentially breaking the rule of non-quoted variables inside functions being evaluated). What I want to do is create a UDF and pass in a query and the name of a column. These are to be

RE: dynamic valuelist

2002-07-10 Thread Raymond Camden
Sure, just do: cfset res = evaluate(valuelist(query.#itemid#)) FYI - this is one of the FEW times you need Evaluate. FYI2 - A UDF for this was written by one of my coworkers and will be up on CFLib.org soon. === Raymond

RE: dynamic valuelist

2002-07-10 Thread Raymond Camden
Of course, in CFMX, you can treat query columns as arrays, so you don't need evaluate there at all: cfset colA = arrayToList(x[a]) (where x is the query and a is the dynamic column) === Raymond Camden, ColdFusion Jedi Master

How to disable MIB Component?

2002-07-10 Thread Jamie Jackson
I need to either: *disable the CF MIB component entirely *or tell the component the correct URL for getmetricdataXML.cfm and serverinfo.cfm (currently, it's looking in the wrong place and filling up my logs). If you could tell me how to do _either_ of these things, I would appreciate it.

Re: Issue: Trying to loop through a query and trim all the fields in the table before I output them without having to hardcode each field.

2002-07-10 Thread Jamie Jackson
Modified (Untested, though. If there's a bug, It'll be relatively small): cfsilent cfoutput query=jobapplicants cfscript for (i=1; i LTE listlen(jobapplicants.columnlist); i=i+1) { colName = listgetat(jobapplicants.columnlist, i); rowNum = jobapplicants.currentrow;

RE: Passing a list to a Stored Procedure

2002-07-10 Thread Wallick, Mike
Oh...I see. Skip the loop thing for a minute. Normally, when you are executing a SP in the query analyzer, you specify parameters like (param1,param2) with commas being the separator. In this case, your parameter contains commas so try this: cfstoredproc procedure=procedure datasource=#dsn1#

RE: How to disable MIB Component?

2002-07-10 Thread Debbie Dickerson
Both options: Disable - Rerun the CF installation program and unselect SNMP option Correct URL - Modify the \CFusion\cfam\Database\mib.properties And a related TechNote regarding the MIB, that you might run into after correcting the URL:

Re: dynamic valuelist

2002-07-10 Thread Michael Dinowitz
Thanks. Very sneaky. Now if I can just get past CF not liking the passed query. :) (which I assume is due to the query being passed by reference, not value) Sure, just do: cfset res = evaluate(valuelist(query.#itemid#)) FYI - this is one of the FEW times you need Evaluate. FYI2 - A UDF

RE: Passing a list to a Stored Procedure

2002-07-10 Thread Jason
Mike, I think that I have this thing figured out. This SP seems to work fine. CREATE PROCEDURE MasterAssignments ( @ClientList nVarchar(4000)) AS BEGIN EXEC (' SELECT Assignments.dbnum, Master.prim_name, Master.prim_ssn, SUM(Assignments.currbal) AS TotalBalance FROM Assignments

RE: Passing a list to a Stored Procedure

2002-07-10 Thread Wallick, Mike
DOH! Of course. Put single quotes inside the IN() clause. -Original Message- From: Jason [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 11:22 AM To: CF-Talk Subject: RE: Passing a list to a Stored Procedure Mike, I think that I have this thing figured out. This SP seems to

RE: dynamic valuelist

2002-07-10 Thread Raymond Camden
What doesn't it like? If you pass a query to a udf, you pass it by ref. If you are just getting the valuelist, this is harmless. If you are actually manipulating the query in the UDF, then you can either duplicate it in the udf or duplicate it on call: cfset newQ = myUDF(duplicate(oldQuery))

RE: RegEx Help

2002-07-10 Thread Ben Doom
: '^(+-)? *[0-9.]+$' This accepts multiple decimal points. I try to stick with one per number. :-) I would use something more like: '^[[:space:]]*(+-)?[[:space:]]*[0-9]+(\.[0-9]+)?[[:space:]]*$' I'm not sure about the [[:space:]]'s -- you might want to just allow spaces and tabs rather than

Comma Delimted list from CFLoop

2002-07-10 Thread Mark Leder
Is it possible to separate values returned from a CFLOOP QUERY, as in the following example: CFLOOP QUERY=qPayment CFOUTPUT #Trim(paymentName)# /CFOUTPUT Records returned from the query could be VISA MC AMEX How would it be done? Thanks, Mark

Re: Comma Delimted list from CFLoop

2002-07-10 Thread Critter
oi Mark!! couldn't you just valuelist(qPayment.paymentName) ? -- Critz Certified Advanced Bald White Barefoot ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion Wednesday, July 10, 2002, 12:39:04 PM, you wrote: ML Is it

RE: Comma Delimted list from CFLoop

2002-07-10 Thread Timothy Heald
CFOUPTUT CFLOOP query=qPayment CFSWITCH expression=#paymentName# CFCASE value=VISA visa stuff /CFCASE CFCASE value=MC mastercard stuff

RE: Comma Delimted list from CFLoop

2002-07-10 Thread Timothy Heald
nope not what you mean. Your looking for valueList() Sorry :) Tim Heald ACP/CCFD :) Application Development www.schoollink.net Fusebox Advisory Committee Member www.fusebox.org Manager Fayetteville ColdFusion User Group www.fcfug.org -Original Message- From: Mark Leder

RE: Speaking of double quotes

2002-07-10 Thread Fitch, Tyler
Hey Tyler, Don't remove your cfqueryparams. Add a preserveSingleQuotes() call. cfqueryparam value=#preserveSingleQuotes(trim(FORM.myVar))# maxlength=35 cfsqltype=CF_SQL_VARCHAR HTH, t ** Tyler M. Fitch Certified Advanced

Re: Comma Delimted list from CFLoop

2002-07-10 Thread Michael E. Carluen
cfquery name=qPayment datasource=dbo.your_datasource select paymentName fromtable /cfquery cfset pay_list = valuelist(qPayment.paymentName) cfoutput cfloop index=loop_pay list=#pay_list# #trim(loop_pay)# /cfloop /cfoutput That work? At

freeware cart

2002-07-10 Thread Robert Orlini
Hello, Any freeware CF shopping carts (in tag gallerys) out there that are open source? Nothing complicated just to get started. Thanks. Robert O. HWW __ Signup for the Fusion Authority news alert and keep up with the latest

OT: SQL checking query

2002-07-10 Thread Paul Giesenhagen
Hello folks, I have an easy one I am sure... I am trying to build a query that will show all items that are not found.. Two tables: Product Table id, title Menu Table id, owner, sub_object I want to write a query that will find all product IDs in the product table, that are not found

RE: dynamic valuelist

2002-07-10 Thread Andrew Tyrone
-Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 12:07 PM To: CF-Talk Subject: RE: dynamic valuelist Of course, in CFMX, you can treat query columns as arrays, so you don't need evaluate there at all: cfset colA =

Re: freeware cart

2002-07-10 Thread Douglas Brown
http://hotwired.lycos.com/webmonkey/99/49/index4a.html?tw=programming Article on building one Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 10, 2002 9:57 AM Subject: freeware

Flash Components for Communication Server?

2002-07-10 Thread Stacy Young
Are these in a secret location or are they not released yet...Anxious to get started but kinda dead in the water. Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees

RE: Comma Delimted list from CFLoop

2002-07-10 Thread Mark Leder
Yes, value List - why didn't I think of that? (Don't answer that question ;o) Many Thanks, Mark -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 12:55 PM To: CF-Talk Subject: Re: Comma Delimted list from CFLoop cfquery

RE: freeware cart

2002-07-10 Thread Kris Pilles
I built a cart from what I learned from that article way back when Its still up and running... A lot more robust now though... Go place to start -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 1:05 PM To: CF-Talk Subject: Re: freeware

Whats the best technique for server side validation

2002-07-10 Thread Bogesdorfer, Dan
I've incorporated server side validation and I'm trying to implement a more robust method than what I have. Currently I'm posting to my action page, if I encounter an error then I display to the user their error(s) and tell them to use the back button to fix the specific fields. The problem is

Re: How to disable MIB Component?

2002-07-10 Thread Jamie Jackson
Thanks, Jamie. Both options: Disable - Rerun the CF installation program and unselect SNMP option Correct URL - Modify the \CFusion\cfam\Database\mib.properties And a related TechNote regarding the MIB, that you might run into after correcting the URL:

  1   2   3   >