Re: If statement

CF 5 ... and that did the trick ... thanks! Paul Giesenhagen QuillDesign - Original Message - From: brook [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, July 27, 2002 12:07 AM Subject: Re: If statement Hmm, is that with CFMX or earlier? Try cfif val

Re: If statement

That works too ... and makes sense ... Thank you Paul Giesenhagen QuillDesign On Friday, July 26, 2002, at 09:34 , Paul Giesenhagen wrote: This code below doesn't work .. it still lets or 0's through... cfif (variables.choiceValue neq 0) OR (Len(variables.choiceValue) /cfif

Re: AS400 DB2 Drivers

DB2Connect, will this work on a Unix platform or NT or both? Is this the way to go? I assume it is the client connection between the machine and the DB2 Database? Thanks! Paul Giesenhagen QuillDesign There is client software, Client access, that comes with an odbc driver Robert Everland

local vs. request

local vs. request scope variables? What if any are some of the drawbacks of going this way? Resources, speed ect.. Thanks in advance Paul Giesenhagen QuillDesign __ This list and all House of Fusion resources hosted

Re: local vs. request

into the tags. Paul Giesenhagen QuillDesign - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 11:52 PM Subject: RE: local vs. request I have an application that sets many different local variables (about 40 or so) on each page

Re: local vs. request

to those who are looking at the code. (comment away!) Thanks Paul Giesenhagen QuillDesign - Original Message - From: Matt Liotta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 11:57 PM Subject: RE: local vs. request Just to note, there is a performance

Checking for dynamic cookie

page evaluating the cookie --- cfset variables.cookiename = A#ReplaceNoCase(url.id, -, , ALL)# cfparam name=cookie.#variables.cookiename# default=0 cfif Evaluate(cookie.#variables.cookiename#) Is 0 ...code... /cfif Thanks again, Paul Giesenhagen QuillDesign

Re: local vs. request

the preference file(s) and then include them in the Application.cfm file? I know that this sound very basic, but I am not too proud to ask :) Paul Giesenhagen QuillDesign Correct, I would think the request scope would be better for global variables than passing them to custom tags. Remember

Re: local vs. request

. Paul Giesenhagen QuillDesign Maybe I am misreading your question, but I think you are confusing the Application.cfm file and the application scope. To put something in the application scope it doesn't have to be declared in the Application.cfm file. You can simply do the following... cfset

AS400 DB2 Drivers

I may be showing my lack of knowledge, but is there any drivers available for Cold Fusion to connect to an IBM AS400 DB2 DB? Or is this even possible? Thanks Paul Giesenhagen QuillDesign __ Get the mailserver that powers

Re: AS400 DB2 Drivers

Are you saying that you need to setup the CF Server(s) as clients on the AS400? And by default there is an ODBC driver on the AS400 that is available? (sorry this is not my area, just trying to clarify somethings). Paul Giesenhagen QuillDesign - Original Message - From: Robert Everland

Re: Output Help

=qr_states group=CaptekLab.state #qr_states.state#br cfoutput#qr_states.lab_name#/cfoutput /cfoutput Good Luck Paul Giesenhagen QuillDesign - Original Message - From: Joshua Tipton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 9:10 PM Subject: Output

Re: Output Help

OOPs, change the cfoutput line from: cfoutput query=qr_states group=CaptekLab.state to: cfoutput query=qr_states group=state Paul Giesenhagen QuillDesign - Original Message - From: Joshua Tipton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 9:31 PM Subject

OT: Search Key Error - MS Access

What does thsi error below mean exactly? Diagnostics: ODBC Error Code = S1000 (General error)P [Microsoft][ODBC Microsoft Access Driver] The search key was not found in any record.PPpThe error occurred while processing an element with a general identifier of (CFQUERY), Paul

Re: File upload module

How is cffile not reliable for you? Paul Giesehagen QuillDesign Hello, Has anyone seen a CFX that provides more functionality that cf_file ? I need something more reliable, and I'd rather not deal with something like ASP_Upload. We are running 4.5 on Windows. Thanks much!

Re: Best solution for this

You could make the form that your sales people use to create the message have a checkbox that says Include Customer Id Then in your cfmail body area, do something like: cfif form.customer_check_form_field Is 1 #query.customerid# /cfif That could resolve it maybe!? Paul Giesenhagen QuillDesign

HtmlEditFormat()

? If somone types 5 in an input box or a text area is my example of possible problems that may exists... What are others thoughts on this? Thanks Paul Giesenhagen QuillDesign __ Structure your ColdFusion code with Fusebox. Get

Re: HtmlEditFormat()

Right now, when I type in 5 and save it to the database, it displays as 5 and when I update that field in a form, it comes out of the database as 5 too ... I guess I am confused when you mentioned that the updating would be the quot; or other ugly characters... Paul Giesenhagen QuillDesign

Re: HtmlEditFormat()

fields that could possibly have these types of characters? Paul Giesenhagen QuillDesign - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 4:51 PM Subject: Re: HtmlEditFormat() Right now, when I type in 5 and save

Re: HtmlEditFormat()

wanted the 5 to show (and any other possible characters) ... but also be available for a tab delimited file export, plain-text email or any other variation... Suggestions? Paul Giesenhagen QuillDesign - Original Message - From: Matthew Walker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED

Re: HtmlEditFormat()

CF5 for me ... haven't tested it on MX ... I don't know if it would matter with what version of CF it is though .. it seems to be more of an HTML/DB problem and how to overcome the possible issues with these. Paul Giesenhagen QuillDesign - Original Message - From: Jim Vosika [EMAIL

Re: CFmail can only deliver to our domain name...

Isn't there a way around this ... I remember a thread awhile back that someone had come up with a way that if the mail server didn't allow relay's, you could do something that would work ... anyone remember how that can be done? Paul Giesenhagen QuillDesign - Original Message - From

Re: Querying 1 million records

CF isn't the issue, it would be more a database/machine issue, you will need a robust database to handle your queries... look at your memory a bit you may want to have it bumped up! Paul Giesenhagen QuillDesign - Original Message - From: Jeff Green [EMAIL PROTECTED] To: CF-Talk [EMAIL

Re: CFCookie?

That wouldn't work, the cfhttp and chttpparam takes place before the information is spit out to the browser, thus no cookie could be set. Paul Giesenhagen QuillDesign - Original Message - From: Joe Bastian [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 11, 2002 2

OT: SQL checking query

appreciated! Paul Giesenhagen QuillDesign __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http

Re: SQL checking query

Thanks!! Almost worked, I had to reverse the nest, but that is what I needed .. it will be a huge bear ...stored procedure fer sure! Paul Giesenhagen QuillDesign - Original Message - From: Bartee Lamar [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 10, 2002 12

Re: Site monitoring services

http://www.tracert.com Paul Giesenhagen QuillDesign - Original Message - From: Bill Wheatley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 10, 2002 4:05 PM Subject: OT: Site monitoring services Hay i had a question there was a website that used to monitor

Re: Looping on a Custom tag - double entries

Hmm... well wouldn't that remove what is currently being built in the list? (It is only one custom tag, calling itself). Paul Giesenhagen QuillDesign I'll admit that I didn't read your email completely, but could it be that you need to clear thisTag.GeneratedContent in one of your custom

Re: Looping on a Custom tag - double entries

Yes, this is true ... i do need it to be graceful... I have tried a number of things and just can't seem to get it to go away Paul Giesenhagen QuillDesign - Original Message - From: Jamie Jackson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 09, 2002 10:28 AM

Re: Application vs Request........

should I look at what I am doing and maybe go a different route? Thanks Paul Giesenhagen - Original Message - From: Dave Carabetta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 08, 2002 2:13 PM Subject: Re: Application vs Request oi CF-Talk,!! ok don't

Re: Application vs Request........

Interesting ... does anyone know if this still holds true with CFMX or not? Paul Giesenhagen QuillDesign Such as datasources, tablenames, table widths, colors ect.. There are probably 30-40 in all. Right now I set those as cfset prefs.tablename = customer_table cfset prefs.dsn

Looping on a Custom tag - double entries

again, but this time tell it to take a look at the next level down. if there's anything under this department, it will get added to the tree in sequence. --- cf_catdump owner=#sub_object# path=#variables.thisitempath# /cfloop Thanks In Advance! Paul Giesenhagen QuillDesign

Re: CFMX editors...

I think Allaire (dunno about Macromedia) licenses were non-transferable. Paul Giesenhagen QuillDesign - Original Message - From: Ken Wilson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, July 06, 2002 12:03 PM Subject: RE: CFMX editors... If it's not for sale

OT: Naming Convention choice

Curious as to which one people prefer. cfquery datasource=QueryName ... OR cfquery datasource=query_name ... Also, out of curiosity these too: CFQUERY DATASOURCE... (all caps) Or cfquery datasource ... Thanks Paul Giesenhagen QuillDesign

Re: New to all this

) Or cfquery datasource ... Thanks Paul Giesenhagen QuillDesign __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk

Re: New and how can I post my questions

of this message, it has all the directions and what to do there. Paul Giesenhagen QuillDesign __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http

Adding Values (SQL)

the Column to NewQty. Does anyone have the correct sytax? Thanks! Paul Giesenhagen QuillDesign __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http

Re: sort list of datetime values

I am shooting off the top of my head, but could you use the queryNew function and the run a query of queries on it to sort it out that way? Not real efficient but it may be one solution ... Paul Giesenhagen QuillDesign - Original Message - From: Ryan Pieszak [EMAIL PROTECTED] To: CF

Re: Adding Values (SQL)

the values in col2? -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: 05 July 2002 16:37 To: CF-Talk Subject: Adding Values (SQL) I don't have any cheet sheets with me, but I need to do a simple query and have an addition statement in the SELECT statment

Re: Adding Values (SQL)

Great, I wasn't in a place where I could easily test it out so I just need to make sure my syntax was correct! Thanks!! Paul Giesenhagen QuillDesign - Original Message - From: Jim Vosika [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 05, 2002 10:57 AM Subject: RE

Re: Naming Convention choice

Head hurts, vision blurry... Happy 5th of July ;D I understand ... question, does Europe and other countries have a 4th of July too? Paul Giesenhagen QuillDesign (Or do they go from the 3rd to the 5th USA Humor

Update with cflocation

code to redirect to a different url? Or any other serverside type solutions would be even better. Thanks Paul Giesenhagen QuillDesign __ Structure your ColdFusion code with Fusebox. Get the official book at http

OT: Dedicated Hosting

We are looking for some additional Dedicated hosting and curious who else on this list uses dedicated hosting and their experience. Looking for some good prices (go figure). Thank you in advance (you can email off-list if you wish). Paul Giesenhagen QuillDesign

Re: this list

Yeah Michael, whats the deal!! :) - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 01, 2002 3:53 PM Subject: Re: this list Your new to the list so you saw this mornings problem as a big thing. Normally, we have a steady

Re: Cfswitch cfcase vs. elseifs performancewise

Yes, there would be improvement ... noticable? probably not ... but 10 ms here 40 ms there over and over can add up to a better performing application. I would go with it Just my .02 Paul Giesenhagen QuillDesign - Original Message - From: Vishal Narayan [EMAIL PROTECTED] To: CF-Talk

Web Services

the place and well I just feel out of touch (which I probably am). Could someone provide the info on it? Thanks Paul Giesenhagen QuillDesign __ This list and all House of Fusion resources hosted by CFHosting.com. The place

Re: Card Processors

Free Script and Free Account setup with CDG Authorize http://www.quilldesign.com/cdg/index.cfm If your looking, it works great and implements in minutes. (If downloaded, you have access to the test account to test the script out) Paul Giesenhagen QuillDesign - Original Message - From

Dynamic Custom Tag Name

this doesn't work) cf_#variables.which_tag#/cf_#variables.which_tag# These tags do different things and depending on which tag we use, depends on what comes out of the database. But we are only calling on of them and I have NO idea what the name of this tag will be. Any Suggestions? Thanks Paul

Re: Dynamic Custom Tag Name

Below is the actual code that I was using... my question now would be, if the Include contains cfmodules as well, will there be a conflict with the closing /cfmodule tags? (Also, I didn't even think of this route :) cf_site_layout thisobject=#getproduct# title=#getproduct.title#

Re: Dynamic Custom Tag Name

Local always! - Original Message - From: Todd [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, June 22, 2002 11:49 AM Subject: Re: Dynamic Custom Tag Name cfmodule name=/path_to_this_tag/#variables.whichtag# is this a local custom tag or a global custom tag? At

Re: Dynamic Custom Tag Name

Todd, Actually it seems to be working correctly ... my secondary question was through the following example: Below I have the module that calls the whichtag variable... then between that cfmodule, I may have another similar cfmodule call that calls an alertbox or other custom tag ... These

Re: escape pound sign

###whatgoeshere# will = #whatgoeshere (whatever whatgoeshere is set to). Use three ### first two escape and leave a # while the third helps process the variable. Paul Giesenhagen QuillDesign - Original Message - From: trey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday

Re: Rumor of lay-offs

That is one way of putting it! LOL Paul Giesenhagen QuillDesign Yes, just like the story about Microsoft buying Macromedia and Macromedia dying, propagated by the f-word toting propeller heads who have nothing better to do than to talk trash, spread rumors and make unfounded, factless

Re: Check for file existence

cfset variables.pathandfilename = set your path and filename here cfif fileexists(variables.pathandfilename) cfelse /cfif Hope this helps Paul Giesenhagen QuillDesign I need to check if a file exists on the server and if so, run some code. Whats the best way to check if the file

Re: unscoped variables

If they are created in the Application.cfm page, they are application variables (application.whatever) Paul Giesenhagen QuillDesign - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 10:04 AM Subject: unscoped variables I'm trying

OT: Oracle Exporting Table structures

I have built a number of tables in Oracle and want to export the CREATE Table sql files. I know you can do this in MS SQL and in MySQL (some of the front ends). But where in oracle can you create these types of documents? (or can you?) Thanks Paul Giesenhagen QuillDesign

Re: Oracle Exporting Table structures

Toad? I assume you are talking about an application, where can it be found? Thanks Paul Giesenhagen QuillDesign - Original Message - From: Chris Lofback [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 10:54 AM Subject: RE: Oracle Exporting Table structures

OT: Outer Join grabbing too many records

by the 'variables.catid' and if there are comments, display the comments for that image ..(Not every image has comments, some have 1 some have 10). My output will be something like this: FILENAME1 (comments: 0) FILENAME2 (comments:2) FILENAME3 (comments 0) FILENAME4 (comments1) ect... Thank you Paul Giesenhagen

Re: Outer Join grabbing too many records

If there are 10 comments, it just shows a 1 instead of a 10 for variables.comment_count. Thank You Paul Giesenhagen QuillDesign - Original Message - From: stas [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 03, 2002 10:25 AM Subject: Re: Outer Join grabbing too many

Re: Outer Join grabbing too many records

Dunno .. it is working now ... disreguard! and THANKS for all the help! Paul Giesenhagen QuillDesign - Original Message - From: Paul Giesenhagen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 03, 2002 10:49 AM Subject: Re: Outer Join grabbing too many records

CFMAIL - Relay

user and not having our mail server drop the message because it doesn't allow relay... Any help would be greatly appreciated! Thanks Paul Giesenhagen QuillDesign __ Get the mailserver that powers this list at http

Re: Quick question on custom tags

cfmodule template=../customtags/formurl2attributes.cfm attribute=... /cfmodule Hope that helps! Paul Giesenhagen QuillDesign - Original Message - From: Brian Eckerman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 10:05 AM Subject: Quick question

Re: Quick question on custom tags

Rob, You are incorrect, you can use the start stop ... cfmodule template = ../modules/custom_tag.cfmBlah Blah /cfmodule works just fine with the execution modes. Paul Giesenhagen QuillDesign One problem with cfmodule is that you cannot take advantage of the ThisTag type functionality you

Re: Unstructured info

Not sure if I can help, but if you give us some more information about your unstructured data, some of us may have a few helpful hints. Just give us some details. Paul Giesenhagen QuillDesign Doe anyone know if CF has been used to manage unstructured information. The problem/challenge

Re: [style] usernames

I would say it depends on if you are 'displaying' usernames in a forum or on articles or something like that. If so, go with usernames, but use email / password for identity and uniquness. Paul Giesenhagen QuillDesign Lets say I have an application where people will sign in to get access

Re: Search Engines

Try http://www.searchengineworld.com a good amount of information. Good Luck Paul Giesenhagen QuillDesign - Original Message - From: Douglas Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 24, 2002 11:05 AM Subject: OT: Search Engines Does anyone know

Re: Shopping Carts - Australian implementation?

Bradley, SiteDirector is open source, and would be fairly simple to modify to make the calculations that you are needed. We are currently in development on v3.0 which rectifies this issue. If you have any questions, please feel free to email me off list -- [EMAIL PROTECTED] Paul Giesenhagen

Re: Shopping Carts - Australian implementation?

That was my understanding about Australian tax ... you set a tax rate, and then set each product either taxable or non-taxable... Paul Giesenhagen QuillDesign - Original Message - From: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 22, 2002 7:37 AM Subject: Re

Re: Search engine safe

at the top of each page, make sure you are using full paths to your images and links: http://www.domain.com/something/index.cfm Also, make sure your links are in the right format too http://www.domain.com/something/index.cfm/id/45/page/article ect.. Let me know if you have any questions! Paul

OT: Getting single records with multiple records from a join

from the crew table) === crewid, year My outcome would be something like: John Doe Years: 1999,2002,2003 Mary Doe Years: 1995,2000,2001 ect.. TIA Paul Giesenhagen QuillDesign __ Structure your ColdFusion code

Re: Getting single records with multiple records from a join

Thank you ... I realized this after I sent out the message ... I was looking at the whole thing backwards making things more difficult than they were ... thank you! Paul Giesenhagen QuillDesign - Original Message - From: Cantrell, Adam [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED

Re: Query help

If you are doing an autonumber type deal, just do the following insert stuff cfquery datasource=dsn name=getid select MAX(id) from tablename /cfquery That should do it for ya! Paul Giesenhagen QuillDesign - Original Message - From: Kris Pilles [EMAIL PROTECTED] To: CF-Talk

Re: Shopping cart

Look into SiteDirector from us: QuillDesign http://www.quilldesign.com/director Currently running special pricing. Many features and simple to implement! Paul Giesenhagen QuillDesign __ Signup for the Fusion Authority news

Re: Brainfart - Need Help

You can't change the value of a query result (I think) Try this instead: cfif Not Len(company)cfset variables.company = query.companycfelsecfset variables.company = blah blah #variables.company# Paul Giesenhagen QuillDesign - Original Message - From: Chris Montgomery [EMAIL PROTECTED

OT: MS SQL - Exporting table structures

I have seen this in MySQL editors, but does MS SQL have an export feature that will export the table structures and such or an export that builds the CREATE TABLE syntax for a list of tables. Any help would be great! Paul Giesenhagen QuillDesign

OT: SQL Query Depending on value

this in CF with cfif's but would rather have it done in the query. The ending result needs to show the itemid, item, and price Any suggestions? TIA Paul Giesenhagen QuillDesign __ Structure your ColdFusion code with Fusebox. Get

Re: OT: SQL Query Depending on value

Yes, that is where the problem arises... Basically if inventory is 0 show the item... no problems, but if the inventory level is = 0 I need to see if backordering is allowed and if it is, show the item, if it isn't do not show the item. Make sense? Paul Giesenhagen QuillDesign First thing

Re: SQL Query Depending on value

Why yes it is Thank you very much! Paul Giesenhagen QuillDesign Isn't it simply... AND ( (inventory 0) OR (backorder = 1) ) Regards, Matthew Walker /* Easier, smarter forms: http://www.matthewwalker.net.nz/inform2 */ -Original Message- From

Re: List, Quotes, Commas UGH

Message - From: Paul Giesenhagen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 12:21 AM Subject: List, Quotes, Commas UGH I have a list with comma's and quotes, here is a sample: 22,33.44,21.93,1,090.33,2,999.00 I need to strip out the as well

A Tip (maybe new, maybe not)

... and you are back in FTP business. Many of you might already know this .. but we just figured it out and I thought it was pretty slick! Paul Giesenhagen QuillDesign __ Structure your ColdFusion code with Fusebox. Get

Re: A Tip (maybe new, maybe not)

Even slicker thanks! Paul Giesenhagen QuillDesign There is an undocumented CF Function that will do the same thing. CFUSION_DBCONNECTIONS_FLUSH() I used to use the bogus query to do this as well until I found out about this function. Cheers! -- Scott Van Vliet Sempra Energy

Re: A Tip (maybe new, maybe not)

Are you serious? select whatever from notable How will that affect the data? Paul Giesenhagen QuillDesign This is considered bad practice, although it does work. Running an intentionally bad query is not good practice, you never know how it will affect your data

Re: A Tip (maybe new, maybe not)

Paul Giesenhagen QuillDesign Well, SELECTing a row from a non-existent tables's not likely to create much havoc. Conversely, CFUSION_DBCONNECTIONS_FLUSH() might not be polite on a shared host! Regards, Matthew Walker /* Easier, smarter forms: http

Re: [admin] List status - A CHALLENGE

I already gave yesterday, but I agree if we knew the costs, we could see where everyone is at and then add accordingly... I would be willing to pump in more money, if I knew where we stood! Paul Giesenhagen QuillDesign Personally, I think that people would be more willing to donate

Re: [admin] List status - A CHALLENGE

hmmm?? When is the MM Confrence this year? Paul Giesenhagen QuillDesign There was also a lot of bouncy bouncy at the community suite, if I recall... g - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 2

List, Quotes, Commas UGH

replace with nothing, then my list gets out of wack because of the 1,999 comma .. I am sure there is a simple method to roll through these, but I am sure someone has a quick answer... Thanks in advance! Paul Giesenhagen QuillDesign

Re: test

Got it ... :) Paul Giesenhagen QuillDesign test Michael Dinowitz Publisher: Fusion Authority weekly news alert (www.fusionauthority.com/alert) Listmaster: CF-Talk, CF-Jobs, Spectra-Talk, Jrun-Talk, etc. (www.houseoffusion.com

OT: MS Access Help

well? They don't have FLOAT :( Thanks Paul Giesenhagen QuillDesign __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk

Re: MS Access Help

What does double do as opposed to decimal? Thanks so much! Paul Giesenhagen QuillDesign - Original Message - From: Janine Jakim [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 14, 2002 3:13 PM Subject: RE: MS Access Help Change the field size to either

Re: [admin] List status

Everyone who gets help from this list pitch in .. a server license is thousands of $$$ and the help and support is priceless... If everyone pitched in $10.00 from the list, he would get about $35,000 that would keep it running reay smooth! Paul Giesenhagen QuillDesign I've started

Re: Spiders and SES urls

Yes it will, the spider acts like a browser...(at least most of them) Paul Giesenhagen QuillDesign http://www.quilldesign.com - Original Message - From: Trace [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, May 12, 2002 7:24 PM Subject: Spiders and SES urls Hi guys, I

Re: CFHTTP truncating data?

) Whew ... any of you joiners out there? Thanks Paul Giesenhagen __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com

Big Join -- OOPs

group) id, groupid, itemid (which is a product id) Whew ... any of you joiners out there? Thanks Paul Giesenhagen __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community

Re: Big Join -- OOPs

g.productid = '#url.id#' group by g.group_name, i.itemid, p.sku, p.title Thank you if you were looking at it .. !! Paul Giesenhagen QuillDesign - Original Message - From: Paul Giesenhagen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 10, 2002 10:30 PM Subject: Big Join

OT:SQL Question

= l.headerid and f.sub_object = h.id group by h.header, f.state, f.sort, l.link, l.link_title, h.id /cfquery Any help would be appreciated. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector Commerce Builder

Re: SQL Question

Let me paste a more detailed query, I am now realizing that I needed to put more online... I am testing on MS SQL Server, but want it to be generic enough to work with Oracle and others if possible. cfquery datasource=#prefs.dsn# name=header select h.id, h.header, f.state, f.sort,

Re: SQL Question

Adam, Is the *= universal syntax (MS SQL, Access, Oracle, MySQL ect..?) Thanks that is working beautifully! Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector Commerce Builder SELECT h.id, h.header, l.link, l.link_title FROM headers h, links l WHERE h.id *= l.headerid

Re: SQL Question

readability) it is better to use the ANSI SQL syntax (LEFT OUTER JOIN). In addition, both Microsoft and Sybase reccommend using ANSI style joins. http://www.microsoft.com/sql/using/tips/development/July23.asp /rob -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED

Re: SQL Question

that relates to the id value in the header table and the sub_object value in the fusion table. Make sense? Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector Commerce Builder Is fusion your cross-reference table between headers and link? Adam. -Original Message

Re: SQL Question

Bingo !!! I truely appreciate the help. I am back in the status of rookie. We have changed our method of database design and thus getting into all kinds of joins so I guess it is off to the books to do some basics! Thanks again! Paul Giesenhagen QuillDesign http

<    1   2   3   4   5   6   7   >