List Sorting/Finding

2001-04-25 Thread Aaron Rouse
I have a database table with three columns: ID, UserName, UserLoc. I need to be able to search on the first four letters of a users last name, the names are stored in this format: lastname, firstname. When I find a matching criteria I need to highlight those records in a list I am displaying,

Re: Hosting Service Provider Edition Clarification

2001-04-28 Thread Aaron Rouse
What I am curious about is after this scare is over, just how many developers have decided to move on to another language. Seems like a lot of people out there are deciding it is time to pick up another language for fear of CF being too much money or not around in the future. So even if MM

Re: Hosting Service Provider Edition Clarification

2001-04-28 Thread Aaron Rouse
True, but also sounds like less CF work for people like me. The people that I do small sites for, already do not want to pay a premium for CF and if/when the pricing goes up they will not pay for it period. Just means I get to code their sites in something else, personally I would prefer not

Re: Hosting Service Provider Edition Clarification

2001-04-28 Thread Aaron Rouse
- From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, April 28, 2001 5:16 PM Subject: Re: Hosting Service Provider Edition Clarification True, but also sounds like less CF work for people like me. The people that I do small sites for, already do not want to pay

RE: JOIN queries from two datasources

2001-05-01 Thread Aaron Rouse
You shouldn't need that, you can do queries across SQL servers: SELECT * FROM servername.databasename.owner.table.column The servers of course have to be linked. On Tue, 1 May 2001, Duane Boudreau wrote: You need CF5's Query a query feature for this -Original Message- From: Diana

RE: New Cold Fusion book, O'riely Press

2001-05-10 Thread Aaron Rouse
Isn't the O'Reilly book over CF 4.5 and going to be released after CF 5.0 is released? On Thu, 10 May 2001, DeVoil, Nick wrote: Jeff, I agree that O'Reilly books are usually excellent. I don't know anything about this one. But you might like to know that Wrox are also bringing out a

Re: the big export

2001-05-17 Thread Aaron Rouse
If this is going into SQL Server, why not use DTS within SQL Server to do this? If it is going to be more than a one time thing, then you could make a CF page to upload the files to the server and then execute the DTS package via CF. - Original Message - From: Jason Lotz [EMAIL

Re: IIS or Apache? (WAS RE: can anyone help?)

2001-05-31 Thread Aaron Rouse
I think Apache's site says it all: However, due to the code's legacy, and use of metaphors and systems which are Unix-specific (such as, having multiple processes all accept()ing connections to the same port), the road to porting to Windows NT has not been a pretty one. Several attempts have

CFTree substitute?

2001-06-06 Thread Aaron Rouse
Are there any other options out there that give the same functionality as CFTree? I am not finding much of anything in the developers exchange, other than custom tags that apply more towards file browsing. ~~ Structure your ColdFusion code with

RE: CFTree substitute?

2001-06-06 Thread Aaron Rouse
Yes, both platforms. On Wed, 6 Jun 2001, Michael Rosario wrote: What platforms do you have to support? IE and Netscape? -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 10:21 AM To: CF-Talk Subject: CFTree substitute

Re: JavaScript var to Cold Fusion var

2001-06-07 Thread Aaron Rouse
I am curious how you have seen this, since that means a Client side language, JavaScript, made a variable within a Server side language, ColdFusion. That can not be done unless you use JavaScript to load a .CFM page and that page handles your CFMAIL. Oh and you might want to fix your email sig,

CFTree form submittal

2001-06-10 Thread Aaron Rouse
How can a form be submitted via JavaScript when there is a CFTree in that form and you are selecting nothing from that CFTree? I simple document.frm.submit(); does not work with Netscape, when you get to the posting screen you get a Error resolving parameter TREE.

Re: CFSTOREDPROC and performance question

2001-06-10 Thread Aaron Rouse
Or DTS and you could schedule a Job to execute it whenever. Could even use DTS and then execute the package via a cfquery that is executed via a cfschedule, but I would just keep it on the SQL Server side. Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion - Original Message - From:

Re: CFSTOREDPROC and performance question

2001-06-11 Thread Aaron Rouse
. Regards, Marc Garrett - Original Message - From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, June 10, 2001 9:58 PM Subject: Re: CFSTOREDPROC and performance question Or DTS and you could schedule a Job to execute it whenever

Re: SQL 7.0 Question

2000-11-30 Thread Aaron Rouse
You are correct, just leave off the * - Original Message - From: "ibtoad" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, November 30, 2000 10:11 AM Subject: SQL 7.0 Question Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything works great except

Re: CF Does not like MSSQL7 @@ROWCOUNT

2000-12-01 Thread Aaron Rouse
We ran into this once before and according to Allaire when CFQUERY evaluates a multi statement argument it waits for the SQL server to respond and specifically looks for the text 'X Rows Returned' Once CFQUERY sees this statement it stops evaluating any additional information returned. A work

Date Formating

2001-01-07 Thread Aaron Rouse
What would be the best way to go about making a select drop down populated with all of the months of the year and to display them abbreviated? I am currently using the following code which works perfect for displaying the months non-abbreviated. select name="OccMonth" option

Re: Date Formating

2001-01-07 Thread Aaron Rouse
I thought about that at first, but from what I have found the standard date abbreviations are the following which means taking just the first three letters would not work. January Jan. February Feb. March Mar. April Apr. May May June June July July August Aug. September Sept. October Oct.

Re: Date Formating

2001-01-07 Thread Aaron Rouse
t Variables.OccMonth = "12" cfoutput select name="OccMonth" option value=""/option cfloop FROM="1" To="12" Index="MonthNumber" OPTION Value="#MonthNumber#" #IIf(Variables.OccMonth IS "#MonthNumber#",DE("SE

RE: Any recommendations on an E-commerce software?

2001-03-12 Thread Aaron Rouse
They must not like other people very much. We tried to use Ablecommerce a little over a year ago and the tech support was terrible. They did nothing but try and point fingers at anything but their product for the problems we were experiencing. The problems turned out to be the installation was

Session Variables

2000-04-10 Thread Aaron Rouse
Is there a way to pass a session variable from one domain name to another when on the same physical server? I have a session variable that is made via the QueryNew function and need to use the info contained in that variable on a processing page that my user gets to via a form. The processing

No Subject

2000-04-15 Thread Aaron Rouse
test -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Inserting Problem

2000-04-16 Thread Aaron Rouse
What is a good work around for when a variable containes quotation marks or a pound sign in its actual value? For example: Variables.Name = "Aaron" If that is the case then, the following code is ignored: cfif Variables.Name GT "0" However if I strip out the quotation marks then it works

Access function in SQL Server

2000-04-30 Thread Aaron Rouse
I am moving a site from an Access DB to SQL Server 7.0 and have run into a function that was being used that is not supported in SQL Server 7.0 The function is: InStr([start, ]string1, string2[, compare]) Is there a new name for this function in SQL Server? --Aaron

Re: CFContent and Excel

2001-09-11 Thread Aaron Rouse
You could generate your format in HTML and then grab that source and push that into a Excel file. Excel will keep the table cell widths and fonts from the HTML. - Original Message - From: Kay Smoljak [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 11, 2001 1:17

Re: SELECT

2001-09-30 Thread Aaron Rouse
The IIf way would be: option value=#name# #IIf(Form.Name EQ Name, DE(selected), DE())##name#/option Or something along those lines, it is slower though due to the DE() functions. Why not just put the CFIF within the option tag? option value=#name# cfif Form.Name EQ

Re: CF Two Selected TAG

2001-10-04 Thread Aaron Rouse
With the Default1 and Default2 attributes. I used to use the following for it and never ran into a problem. cfif Variables.CauseType1 GT 0 CF_TwoSelectsRelated Name1=CauseType1 Name2=SubCause1 Query=qryGetCauseType Value1=CauseTypeID Value2=SubCauseID Display1=CauseType Display2=SubCause

Re: Building a answer key

2001-10-21 Thread Aaron Rouse
Actually I found a solution to this shortly after sending the email(a couple of days ago). I just added onto my existing structure. So I have a .Value which equals the value of the input tag, such us Yes. Then I have in my structure a .Yes = 0; and a .No = 0; If I were code those zeros as the

Re: Ben Forta's online testing application

2001-10-25 Thread Aaron Rouse
OMG, dare you mention his helper elves? I thought people only credited BF for those books on here. Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion - Original Message - From: Gary P. McNeel, Jr. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 25, 2001 3:44

RE: cf excel formatting problem

2001-10-30 Thread Aaron Rouse
This also works in Netscape, we do it with NS 4.7x all the time. I think you can transfer more styles(CSS) via IE over NS. If you do it, one thing we have run into is when you include your style sheets via a link tag, for whatever reason NS 4.7x on Win2k will first post a error msg to the style

Structures and SetVariable() function

2001-11-01 Thread Aaron Rouse
I am trying to set some values to a structure that I have already created on my page, but set them based upon some data I pull from my database. When I try the following inside a loop: cfset tmp = SetVariable(Ses.Profile[frm#qryGetInfo.FormNumber#].#qryGetInfo.FormFieldName#.Value,

RE: Structures and SetVariable() function

2001-11-01 Thread Aaron Rouse
PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 9:20 AM To: CF-Talk Subject: Structures and SetVariable() function I am trying

RE: Structures and SetVariable() function

2001-11-01 Thread Aaron Rouse
. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Aaron Rouse [mailto

Re: Structures and SetVariable() function

2001-11-01 Thread Aaron Rouse
scenario you can always use cfset evaluate( both sides of the expression) (trick i picked up from early spectra code) but Raymonds solution is much better in this case. - Original Message - From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday

Re: related selects

2001-11-02 Thread Aaron Rouse
Just build the structure in CF and then use CFWDDX to put that structure into a JavaScript for qForms to use. Another way is to just use cfoutput tags inside the javascript, so that they put in all the code to build a JS structure once the browser gets the page source. I for some reason prefer

Re: Javascript Vs. CF Form Validation

2001-11-09 Thread Aaron Rouse
I kind of see that as reinventing the wheel, when there are plenty of JavaScript's out there that can do validation for you. Not saying I have avoided learning JavaScript or that I use CFForm to do it. However with things like qForms from www.pengoworks.com out there, personally I wish I had

Re: Javascript Vs. CF Form Validation

2001-11-09 Thread Aaron Rouse
and paste the code I need, rather than including a big library that has a lot of code I don't need. - Original Message - From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 09, 2001 7:20 AM Subject: Re: Javascript Vs. CF Form Validation I

Invalid expression format?

2000-05-16 Thread Aaron Rouse
I am getting a invalid expression format on the following code: #Evaluate(Variables.OptionName)[ListFindNoCase(ValueList(Evaluate(Variables.OptionValue)), Variables.SelectedValue)]# The error is: Invalid parser construct found on line 129 at position 61. ColdFusion was looking at the

JSStringFormat Function

2001-06-18 Thread Aaron Rouse
Curious as to why this throws a error and what can be done to avoid it, just escape out quotes? cfset myVar = 'Law Office(s) / Chamber(s) Of' cfoutput a href= onmouseover=window.status='#JSStringFormat(myVar)#'; return true; onmouseout=window.status=''; return true; style=font-family: Arial,

Re: Kill the President

2001-07-18 Thread Aaron Rouse
Since when have, commies == hippies? So China is just full of a bunch of pot smoking hippies? Oh wait, this is CF, that should be: commies EQ hippies Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion On Wed, 18 Jul 2001, Richard L Smith wrote: WOT But try this drop dead you

RE: Kill the President

2001-07-18 Thread Aaron Rouse
Do we get any sort of prize for commenting on the space in between Cold and Fusion? Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion On Wed, 18 Jul 2001, Jerry Staple wrote: I knew someone was going to say that Gary but i wondered who would be the first.! Congratulations! You

Re: Multiple Select boxes

2001-07-18 Thread Aaron Rouse
If you want it done on the fly then you need to use JavaScript. I use qForms for this, but I usually have more like 6 related boxes. If you will be doing just two or three, you could use Nate's tags, TwoSelectsRelated or ThreeSelectsRelated. With Nate's tags you just need to get your

Re: I have to ask

2001-07-19 Thread Aaron Rouse
So is CF the reason for duplicates that seem to randomly happen and for the slowness issues that seem to randomly happen? Or is that the list ? Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion On Wed, 18 Jul 2001, Michael Dinowitz wrote: Why so? I use CF to take a mail message, clean

Re: I have to ask

2001-07-19 Thread Aaron Rouse
PostOffice has to be the only mailing list that I have heard have that likes to burp and send out duplicates. So what causes these funky line wrappings in the mails lately, is that also PostOffice? Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion On Thu, 19 Jul 2001, Michael Dinowitz

RE: .Net and ColdFusion

2001-07-24 Thread Aaron Rouse
I too have the book, had it for at least a week now, just now started to read through it. Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion On Tue, 24 Jul 2001, John Lucas wrote: As a side, the book is out. I have a copy sitting here that I ordered from bookpool.com and received two

Re: PHP Nuke...CF alternative?

2001-07-24 Thread Aaron Rouse
Interesting, I came across http://www.serials2000.org/ and it seems to also be done with phpnuke. Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion On Tue, 24 Jul 2001, Tony Schreiber wrote: I just used phpnuke on one of my own websites: http://www.montero-sport.com/ I think it's

Re: PHP Nuke...CF alternative?

2001-07-24 Thread Aaron Rouse
Corporation [EMAIL PROTECTED] www.workcover.com p: +61 8 82332548 f: +61 8 82332000 m: 0418 806 166 -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 25 July 2001 4:02:AM To: CF-Talk Subject: Re: PHP Nuke...CF alternative? Interesting, I came

Re: Macromedia Cold Fusion Community Manager

2001-07-25 Thread Aaron Rouse
Besides that, 50-60mb free on a C drive is kind of a bad thing anyways. Sure you can redirect swap files to another drive, but it is not leaving much even with that. I have always been a firm believer in programs being installed to another drive(partition) when using NT, since NT usually has a

Re: Zachary Bedell

2001-08-09 Thread Aaron Rouse
It becomes spam at anything over 50, which I got, 54 to be exact. Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion On Thu, 9 Aug 2001, John Paitel wrote: Well, since the admin already wrote a notice about it, I think they know. Also, I've received your post five times. When do YOU

Re: CFLocation and Passing Complex Data

2001-08-17 Thread Aaron Rouse
I have had a problem with this in the past. You can only pass so much on the URL and my packets were getting cut off and causing strange errors due to that. Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion - Original Message - From: Yvette Ingram [EMAIL PROTECTED] To: CF-Talk

Re: ASP vs. Cold Fusion

2001-08-17 Thread Aaron Rouse
What good would checking to see if a POP server is running do when you want to try and check if a mail server is running? Plus, I know of a lot more restricted POP servers than mail servers, such as TCP wrappers being run on the POP so that only that network can connect to the POP server. Snipe

RE: I save these CF scripts in Note-It-All Software...

2001-08-21 Thread Aaron Rouse
One problem with Snippets is if you develop in different physical environments, your Snippets can not easily follow you. I usually just store useful code in email and then access my email always through either IMAP or directly on the mail server. In some cases I am lucky enough to use RDS and

Re: Four Selects Related.

2001-08-22 Thread Aaron Rouse
I am up to ten related boxes now via qForms populate() function and everything works great. Also love the error checking I am able to establish via qForms. Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion - Original Message - From: Paul Ihrig [EMAIL PROTECTED] To: CF-Talk [EMAIL

Re: Four Selects Related.

2001-08-23 Thread Aaron Rouse
Related. Aaron could you give me an example of this. i couldn't find any info on drop down lists that are related. also how to error check a dropdown list. thanks -paul -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 9:57 PM

RE: CF FTP Application

2001-08-27 Thread Aaron Rouse
How do you check the file extension with JavaScript? I thought one of the security features built into JS would not allow you to access local file systems. Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion On Mon, 27 Aug 2001, Timothy Heald wrote: Hey, Using JavaScript, CFFILE,

RE: CF FTP Application

2001-08-28 Thread Aaron Rouse
/CCFD :) Application Development http://www.schoollink.net/ -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 2:55 PM To: CF-Talk Subject: RE: CF FTP Application How do you check the file extension with JavaScript? I thought one

RE: Changing the name of a file...

2001-08-28 Thread Aaron Rouse
Have you tried to change the name of the file via a cfheader tag right after the cfcontent? cfheader name=Content-Disposition value=attachment; filename=#FileName# There is another way to do it if you are calling the page via a form, but I can not recall off hand. I think it is something like

RE: ColdFusion 5.0 Applets

2001-08-29 Thread Aaron Rouse
Isn't there also a issue with CFTree in that one of the old JavaScripts that it used to make is no longer made in CF5? I have yet to upgrade to CF5 on the one site I use CFTree on, so have no first hand experience with this. I think it is the _CF_getTree() function, but I might be wrong on that

RE: Documentation

2002-02-22 Thread Aaron Rouse
We have to have up to date documentation on our web projects. They actually can not go into production until those docs are made. With that said, things sure do manage to slip through the cracks. The master documentation though is a good piece for the project managers to see and look over,

Re: XML question

2002-03-01 Thread Aaron Rouse
Does anyone know of a online source with some examples of accessing WDDX packets from within a VB application? I know Forta's book has one example of this and the SDK for WDDX has a little bit, but that is about all I have been able to find. Like how it is www.openwddx.org now but the SDK points

Re: cfif in cfset

2002-03-02 Thread Aaron Rouse
I know the DE() function which is commonly used with IIF is resource intensive. I once stripped out a sizeable amount of IIF() functions from a page and put in CFIF tags in place and picked up a noticeable amount in the load times. In a lot of cases the IIF() is used, people could have used

Re: cfif in cfset

2002-03-03 Thread Aaron Rouse
Over #NumberFormat(iterations)# iterations: IIf() with DE() = #NumberFormat(time1)# IIff() = #NumberFormat(time2)# /pre /cfoutput Jim - Original Message - From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, March 02, 2002 3:10 PM Subject

RE: Allaire Partner upgrades...

2001-12-20 Thread Aaron Rouse
At least you got a link, we have recieved nothing. We had to basically fight to get the Windows version of CF5 Server, did they even ship out other versions of CF5 to partners? Personally I think MM could care less about the Allaire Partners, honestly see no point in going to whatever that new

RE: Allaire Partner upgrades...

2001-12-20 Thread Aaron Rouse
, actually it might be a full copy come to think of it. Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion On Thu, 20 Dec 2001, C. Hatton Humphrey wrote: We received our upgrade copy of CF 5 Server with no prodding on our side. Hatton -Original Message- From: Aaron Rouse [mailto

RE: Exporting data to Excel

2001-12-20 Thread Aaron Rouse
I take it this XML file into Excel is something only Office XP can do over 97 and 2k? Or is there some trick to get it to work that I am missing? This is what I tried: cfquery name=test datasource=coilsafe SELECT A.ID, A.FRM, A.QUESTION FROM FRMQUESTIONS A GROUP BY

RE: Allaire Partner upgrades...

2001-12-20 Thread Aaron Rouse
. Hatton -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 9:36 AM To: CF-Talk Subject: RE: Allaire Partner upgrades... Was it just for Windows or did you get the Linux version as well? We recieved an email saying they were bing

RE: Allaire Partner upgrades...

2001-12-21 Thread Aaron Rouse
True, suppose we could contact those people directly again and ask if partners are getting Studio 5 and if partners are getting CF 5 server in any other version besides Windows. That of course is what we did before in regards to other issues and yes they did take care of them. I just get the

RE: Allaire Partner upgrades...

2001-12-21 Thread Aaron Rouse
Under the new program? So the program that we signed up on is no longer supported? Thought it was until it expired and then it was either step up to the new program or talk a long walk off a short pier. I guess with a merger, they can do what they want to and not honor any previous agreements.

RE: Allaire Partner upgrades...

2001-12-21 Thread Aaron Rouse
- From: Aaron Rouse [mailto:[EMAIL PROTECTED]] Sent: Friday, December 21, 2001 11:52 AM To: CF-Talk Subject: RE: Allaire Partner upgrades... Under the new program? So the program that we signed up on is no longer supported? Thought it was until it expired and then it was either step u p

RE: Allaire Partner upgrades...

2001-12-21 Thread Aaron Rouse
Actually my reason for being upset is getting told one thing and it never happening on multiple occasions. Sure, we could have contacted them and asked why they told us this was going to happen and it never did and THEN it would happen. Not like it was a huge expense to become a partner, but

RE: death of coldfusion

2001-12-31 Thread Aaron Rouse
Oh man, which parts? Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion On Mon, 31 Dec 2001, Jeff Beer wrote: Cold Fusion isn't dying, but I did hear from a very reputable and informe d source, that the sky is, indeed, falling, in certains parts of Texas. -Original Message-

Re: And the award goes to ....

2002-01-01 Thread Aaron Rouse
Just get a job like Dave, where you only have to do email all day long, t hen you can win! ;) Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion - Original Message - From: Philip Arnold - ASP [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 01, 2002 11:50 AM

RE: Bug in CF 5's FirstDayOfMonth?

2002-02-06 Thread Aaron Rouse
Can we complain if we know of someone that got approved for the beta and did not even apply for it? Same thing happened for the alpha as well for them. Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion On Wed, 6 Feb 2002, Jeffry Houser wrote: Do I want to be a part of beta 1? Yes! Do

RE: CFIF statement

2002-02-06 Thread Aaron Rouse
I do not believe you can do a list(ray, bob) with the CONTAINS like that, I could be wrong though. I would just do something like this: cfif ListContainsNoCase(ListGetAt(GetFontFamily.sti,1,'.'), aachen) OR ListContainsNoCase(ListGetAt(GetFontFamily.sti,1,'.'), adelon)truecfelsefalse/cfif

Re: Formatting a Date in MS SQL Access Query...Try Again

2002-02-06 Thread Aaron Rouse
Yes, it does look like a overcomplicated query. However why would you need to convert them to dates, the only reason I could think of is if you are actually inserting times with those dates. I see no reason as to why this would not return the same results as what you are trying: SELECT * FROM

Re: distinct query

2002-02-06 Thread Aaron Rouse
I would think it returns all distinct columns that you are selecting. I do not know exactly what is going on in your needs and wanted results, but maybe a subquery with an IN statement would be a simple enough way to get those results. Such as: SELECT Email, My_id, MyDisplay, MyPassword FROM

Re: distinct query

2002-02-06 Thread Aaron Rouse
, and then loop another query, but I'd like to do it the proper way if I can... Tyler Silcox email | [EMAIL PROTECTED] - Original Message - From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 06, 2002 12:16 PM Subject: Re: distinct query

RE: page break when printing

2002-02-15 Thread Aaron Rouse
Isn't this style not supported in NS Navigator? Just wondering since the original email made note of it not working especially in Navigator. Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion On Fri, 15 Feb 2002, James Curran wrote: This is fairly straight-forward as well: br clear=all

RE: cf_TwoSelectsRelated initially selected values

2002-09-26 Thread Aaron Rouse
I personally prefer to use qForms for related boxes, but usually because my needs almost always go past what a something like TwoSelectsRelated can provide. However, my copy of TwoSelectsRelated has the code already in it for preselecting values. I think I got it out of the Devex many moons

RE: cf_TwoSelectsRelated initially selected values

2002-09-26 Thread Aaron Rouse
It would be a little more than that for the second box since it is populated via JS. However that method should at least work for the first box. You would do that on the first, then need to call the JS function that populates the second box and then select the appropriate option in the

re: not another mx boo boo

2002-10-09 Thread Aaron Rouse
From best I can tell it is in fact part of his job. It is good to see that MM has employees out in these circles to best represent company with such attitudes and at times insulting behavior. Anyone know who we could contact at MM via smail to compliment such things? Oh, wait, nevermind I

RE: not another mx boo boo

2002-10-09 Thread Aaron Rouse
** -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 8:09 AM To: CF-Talk Subject: re: not another mx boo boo From best I can tell it is in fact part of his job. It is good to see that MM has employees out

Re: cfhttp equivalent in ASP

2002-06-14 Thread Aaron Rouse
MS has a component for this, believe it is called XMLHTTP Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion - Original Message - From: Eric Dawson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, June 13, 2002 3:54 PM Subject: Re: cfhttp equivalent in ASP ASP Tear?

Re: Re[2]: Preventing user from going back

2002-05-30 Thread Aaron Rouse
One could do what ifs all day long, if you need to worry about someone going through all that much trouble, then perhaps you should just not put the information on the web in the first place. Heck, you asked for a easy way and are coming up with complicated ways they can get past that.

Re: Querying multiple Oracle datasources - separate logins - 1 cfquer y

2002-06-05 Thread Aaron Rouse
-- Original Message -- From: Carlisle, Eric [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 5 Jun 2002 10:03:22 -0400 Is it possible to join tables in 2 different Oracle datasources (using 2 different logins)? This is a loaded question because

Re: CF on EfNet?

2002-06-05 Thread Aaron Rouse
-- Original Message -- From: Chris Norloff [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 5 Jun 2002 10:44:00 -0400 How does one get into EfNet? I tried efnet.org efnet.net but didn't see any coldfusion. thanks, Chris Norloff Check out

Re: TwoSelectsRelated

2005-03-21 Thread Aaron Rouse
I found it on the Dev Exchange via searching on CF_TwoselectsRelated and all I did other than that was changed it to only search in the ColdFusion Exchange. I'd offer the copy I have laying around but it is rather old and might very well be the same you have. On Mon, 21 Mar 2005 13:46:40 -0400,

Re: cfqueryparam question

2005-03-22 Thread Aaron Rouse
I believe with Oracle in later than CF5 you could insert/update more than 4000 characters into a clob when using CF_SQL_CLOB. Not sure for CF5 though, for some reason I recall it failing beyond 4000 and requiring work arounds. On Tue, 22 Mar 2005 10:44:53 -0700, Scott Brady [EMAIL PROTECTED]

Re: Using CF to get details of MP3 and/or convert bitrates of MP3s

2005-03-25 Thread Aaron Rouse
I used a custom tag to get mp3 file information awhile back, can not recall its name(have it at home). Quick look at Google brought this back but name is not ringing a bell for me: http://www.rixsoft.com/ColdFusion/CFX/MP3Dir/ I did run into problems with newer types of MP3s but I think it was

Re: Ordering WACK from Amazon

2005-03-25 Thread Aaron Rouse
I know of someone who did and still makes a pretty penny from it. Wrote some books on cisco, some of which are used in colleges. However he does make far more off the training he does, but the books were a great help in getting him in that position in life. On Fri, 25 Mar 2005 10:09:04 -0500,

Re: Ordering WACK from Amazon

2005-03-25 Thread Aaron Rouse
Plus they make a good defense weapon if ever in a bind :) You know, cube farms can get violant at times. On Fri, 25 Mar 2005 10:23:19 -0500, Ray Champagne [EMAIL PROTECTED] wrote: I dunno, I am not 100% on board on that e-book/pdf thing. Personally, I like having Ben's lineup of books all

Re: CF_TwoSelectsRelatedMulti in a CF7 Flash form?

2005-03-25 Thread Aaron Rouse
I believe this is what you are looking for: http://www.happyhacker.com/includes/Example_CF7_TwoSelects.txt I did not get around to messing with the ActionScript to get the required to actually work, I found out in CF7 that if you have an option with a blank value then that is good enough to not

Re: Ordering WACK from Amazon

2005-03-25 Thread Aaron Rouse
Yeah, I still have the v3 and v4 books ... anyone wanna buy them? :) On Fri, 25 Mar 2005 11:42:31 -0500, Ray Champagne [EMAIL PROTECTED] wrote: How dare you resell Ben's books? Blasphemy! :) Ray At 11:33 AM 3/25/2005, you wrote: And Ben's books have great re-sale value too.

Re: Ordering WACK from Amazon

2005-03-25 Thread Aaron Rouse
The searching is the only thing I would like about an eBook. I am just one of those people that when reading something I prefer it not be on a monitor screen but on paper and printing out hundreds of pages on my own printer does not sound like fun. On Fri, 25 Mar 2005 09:41:31 -0700, Connie

Re: Ordering WACK from Amazon

2005-03-25 Thread Aaron Rouse
Perhaps I am wrong on this, but I really think you people spend way too much time in the bathroom if you are worried about being able to run the code samples from the WACK in there on your mini computer On Fri, 25 Mar 2005 12:27:49 -0500, Dave Watts [EMAIL PROTECTED] wrote: And you don't even

Re: Ordering WACK from Amazon

2005-03-25 Thread Aaron Rouse
.. Rick -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Friday, March 25, 2005 11:48 AM To: CF-Talk Subject: Re: Ordering WACK from Amazon The searching is the only thing I would like about an eBook. I am just one of those people that when reading something

Re: Ordering WACK from Amazon

2005-03-25 Thread Aaron Rouse
there who gets headaches from reading printed literature, but find LCD reading relieving...no where we might find them, I don't know... :o) Rick -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Friday, March 25, 2005 1:35 PM To: CF-Talk Subject: Re

Re: how to check CF version

2005-03-29 Thread Aaron Rouse
I just do cfdump var=#server# and if it fails then it is too dang old ;) On Tue, 29 Mar 2005 11:17:38 -0400, daniel kessler [EMAIL PROTECTED] wrote: I searched the archives but I can't figure out how to check the version of CF that's on our server. I have to do some pdf work and wanted to

Re: how to check CF version

2005-03-29 Thread Aaron Rouse
That is for bluedragon though On Tue, 29 Mar 2005 11:25:47 -0400, Doug Strickland [EMAIL PROTECTED] wrote: I haven't tried this out myself, but check this site out...it has some code that you can copy and paste, and then run on the server to tell you the info you want:

Re: MAX 2005 [USA] City?

2005-03-29 Thread Aaron Rouse
, Connie DeCinko [EMAIL PROTECTED] wrote: Makes it very hard to budget and plan without plenty of advance notice. I think typically you get about six months notice for MAX. Is that not enough? (genuine question) -- Aaron Rouse http://www.happyhacker.com

  1   2   3   4   5   6   7   8   9   10   >