OT: Outer Join

, if the URL.ID value is 0 (no records with ID 0) then I just want to have the whole list of cp.payid's display with c.id as NULL ... if the ID is valid, I STILL want to have the whole list of cp.payid's displayed, but with the c.id loaded with the url.id. Where am I missing this ... Thanks folks Paul

MySQL - Linux cfqueryparam

WHERE id = cfqueryparam value=#url.id# cfsqltype=CF_SQL_VARCHAR Now if no url.id isn't passed, it errors out not liking the '? in the WHERE statement ... if you put ' around the 'cfqueryparam' it runs just fine Any thoughts? Paul Giesenhagen QuillDesign

OT: SQL Error with Syntax

variables.ups_rate = getrate.ship_value VENDORERRORCODE 170 SQLSTATE HY000 Paul Giesenhagen QuillDesign ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm

Re: Payment Gateway

. Hope this helps! Paul Giesenhagen QuillDesign Anybody have recommendations regarding a payment gateway, that easily integrates with Coldfusion? Preferably (if possible) to have reoccurring billing. I've been looking at Payflow Pro from Verisign, 2checkout, and some others. Tips? Tricks

Re: at commands AND coldfusion ?

AT commands are commands sent to a modem to tell it what to do ..dial, answer etc... Any old BBS'r remembers all the AT commands (memories) Paul Giesenhagen QuillDesign - Original Message - From: Adam Reynolds [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 04, 2003

OT: Free Mail Server

Anyone know of a good free mail server? (sorry for the ot, but as always you'all know everything) Running on Windows2000 Advanced Server IIS 5 Paul Giesenhagen QuillDesign ~| Archives: http://www.houseoffusion.com/cf_lists

Re: App Suggestions

or outline points could have content associated with it ... Since SiteDirector is open source, you can modify the templates to provide the look and feel you are looking for. Just a suggestion ... let us know if you have any questions (off-list). Thank you Paul Giesenhagen QuillDesign - Original

Re: CF5/CFMX/NT/UNIX ??

see Paul Giesenhagen QuillDesign ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk

Re: CF Hosting package on MediaTemple

I have used Media Temple .. they are great ... the CFMX/Linux hosting is alittle shaky, but for the price you get a good system and support. Also, support is alittle slow but reliable. Hope this Helps Paul Giesenhagen QuillDesign - Original Message - From: Stacy Young [EMAIL PROTECTED

Re: [OT] CFID and CFTOKEN on POPUP Windows

I would think you want the same pair .. that is how the system keep track (besides cookies) of who is who. I can't think of a reason to generate new CFID/CFTOKENs Paul Giesenhagen QuillDesign - Original Message - From: Greg McDaniel [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent

CF5/CFMX/NT/UNIX ??

... [EMAIL PROTECTED] Thank you Paul Giesenhagen QuillDesign ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ

Re: Logging out of application

I am not sure if this will work but try CFHEADER cfheader name=location value = someurl.html cfheader statusCode = 302 statusText = Document Moved. Let us know Thanks Paul Giesenhagen QuillDesign - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent

Re: Replacing the #

It is a form variable .. actually it is a Hex color #FF (I need to remove the Pound sign). Paul Giesenhagen QuillDesign - Original Message - From: Pablo Varando [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 12:35 AM Subject: Re: Replacing

Replacing the #

) !--- Errors out --- cfset thisItem = ReplaceNoCase(thisItem, ##, , ALL) !--- Doesn't replace --- Thanks Paul Giesenhagen QuillDesign ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http

Re: Replacing the #

Just tried it, and nope, it didn't work ... Thanks for trying though... Paul Giesenhagen QuillDesign - Original Message - From: Pablo Varando [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, February 17, 2003 11:53 PM Subject: Re: Replacing the # Try this: cfset

Re: Replacing the #

It currently isn't in a CFOUTPUT it errors on the cfset Toughy huh?! Paul Giesenhagen QuillDesign - Original Message - From: Pablo Varando [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 12:07 AM Subject: Re: Replacing the # What about this: !--- put

Re: Basic HTML Question

I am not sure what he is actually using it for, but the output would be RecordEdit.cfm# (one #) Paul Giesenhagen QuillDesign - Original Message - From: Peter Bagnato [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, February 15, 2003 1:47 PM Subject: Basic HTML Question

Re: Basic HTML Question

Oops .. you are right ... ### would leave one ... nothing like wrong answers :) Paul Giesenhagen QuillDesign - Original Message - From: Dave Lyons [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, February 15, 2003 1:53 PM Subject: Re: Basic HTML Question i would assume

Re: cffile with unique names

Are you saying that if you update picture.jpg and then output #cffile.serverFilename# it returns picture.jpg? And you have your CFFILE set to unique? Could you post your CFFILE code? Thanks Paul Giesenhagen QuillDesign - Original Message - From: Darren Adams [EMAIL PROTECTED] To: CF

Re: Shopping Cart Solutions

Though SiteDirector isn't what you are looking for, we do have an application that is just a shopping cart (without the catalog building tools). You pass QD Cart information and it processes the order. http://www.quilldesign.com/qdcart/index.cfm for more information Just FYI! Paul Giesenhagen

CFMX/mySQL Query Problem

I have a query that is giving a generic error and I cannot see what hte problem is ... below you will see the insert statement and the generic error.This is running on mySQL 3.2x and Windows XP, the #variables.urlRoot# is http://localhost/cfquery datasource=#form.dsn# name=step1

Re: CFMX/mySQL Query Problem

type requested Any help would be greatly appreciated! Paul Giesenhagen QuillDesign - Original Message - From: Paul Giesenhagen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, February 11, 2003 9:11 AM Subject: CFMX/mySQL Query Problem I have a query that is giving

Re: CFMX/mySQL Query Problem

But that would make NULL a string instead of a NULL value ... Paul Giesenhagen QuillDesign - Original Message - From: Dave Wilson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, February 11, 2003 9:13 AM Subject: RE: CFMX/mySQL Query Problem Paul, At first glance I

Re: CFMX/mySQL Query Problem

I think Matt R had the solution I had the quotes around the cfqueryparam ... testing it now ... we need the queryparam ... seems that my sql doesn't like the \ so this cfquery param fixes that issue. Thanks! Paul Giesenhagen QuillDesign - Original Message - From: Stephen Moretti [EMAIL

Re: CFMX/mySQL Query Problem

It is a string, it is misleading though. It is the cfqueryparam again still waiting, but I am sure that is the issue. Thanks Paul Giesenhagen QuillDesign - Original Message - From: Dave Wilson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, February 11, 2003 9:52 AM

Re: SOT

Sorta Off Topic ... at least that is what it says to me ... So there is OT (which is just plain ole off topic) SOT Sorta Off Topic WOT Way Off Topic Paul Giesenhagen QuillDesign - Original Message - From: Fregas [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, February

Re: Shopping Cart

It's worth every penny and more :) Paul Giesenhagen QuillDesign - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 06, 2003 3:31 PM Subject: RE: Shopping Cart nevermind $499 :) ...tony Tony Weeg Senior Web Developer

OT Best Practice User Validating

that the system assigns the password and sends the password via email to the member. This is ok, but it is so easy for people to get hotmail accounts that it isn't the best way. What are some of the ways that you all have used to validate/verify a user and who they are?! Thanks for the help Paul

Re: OT Best Practice User Validating

Giesenhagen QuillDesign - Original Message - From: webguy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 05, 2003 2:02 PM Subject: RE: OT Best Practice User Validating client side certs are the most secure way. WG -Original Message- From: Paul

Re: OT Best Practice User Validating

We have considered Credit Card Validation ... and that may be just the ticket .. the serious ones will have no problem while the evil users will not want us to have that information. Paul Giesenhagen QuillDesign - Original Message - From: Ryan Kime [EMAIL PROTECTED] To: CF-Talk [EMAIL

Client Variables - Serious Problem

url=member.cfm?mode=login addtoken=Yes /cfif When I opened my browser and went to the site, It thought i was a different user ... how could something like this have happened?? Any help or if you all need more information, please let me konw. (Win2K, CF5 - Single Machine) Thank you Paul

Re: Client Variables - Serious Problem

It was my understanding that you didn't have to lock client variables ... Paul Giesenhagen QuillDesign - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 3:15 PM Subject: RE: Client Variables - Serious Problem paul

Re: Client Variables - Serious Problem

Could it have anything to do with CFID, CFTOKEN? Are you supposed to track that with the cookies ...?! Paul Giesenhagen QuillDesign - Original Message - From: Raymond Camden [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 3:18 PM Subject: RE: Client

Re: Client Variables - Serious Problem

So, do you see anything wrong I don't think this is a mixup on one record ... I have recieved a few emails that led me to believe that other users on the website are also having these issues. Paul Giesenhagen QuillDesign - Original Message - From: Raymond Camden [EMAIL PROTECTED

Re: Client Variables - Serious Problem

Currently I pass every link like this: a href=whatever.cfm?mode=whatever#urlToken#Link/a I will try your suggestion. NOTE: I just recieved an email from a user who said someone knew all their personal information ... sooo this is looking like a huge problem. Thank you Paul Giesenhagen

Re: Client Variables - Serious Problem

Gel, Sorry, I know you don't lock'm ... but also keep in mind, Raymond was part of the development of CF ..:) Paul Giesenhagen QuillDesign - Original Message - From: Angel Stewart [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 3:45 PM Subject: RE

Re: Client Variables - Serious Problem

Well, I am storing them in the DB... I think I am missing something on Client Variables .. (which I hang my head :) Should I be keeping the key CFID associated with the memberID in the db? Paul Giesenhagen QuillDesign - Original Message - From: Matt Robertson [EMAIL PROTECTED] To: CF

Re: Client Variables - Serious Problem

Why does the cfcookie in the application.cfm file fix the problem?!?! What if they have cookies turned off? Paul Giesenhagen QuillDesign - Original Message - From: Owens, Howard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 4:08 PM Subject: RE: Client

Re: Client Variables - Serious Problem

So making sure EVERY link is passing the #urlToken# keeps you safe ... even from something like anonymizer? Paul Giesenhagen QuillDesign - Original Message - From: Owens, Howard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 4:29 PM Subject: RE: Client

and WDDX

It seems that everytime the is used in a WDDX packet we get an XML parsing error: not well-formed. Has anyone else ran into this and come up with a solution?? Thanks Paul Giesenhagen QuillDesign ~| Archives: http

Incrementing number verification

to see if anyone had any quick sure way (or a UDF) that would make sure the number submitted is in the right increment. (Note:, I am not looking for order an order, just that it is divisable by 25 evenly). Thank you, Paul Giesenhagen QuillDesign

Re: CF Hosting Suggestions

http://www.mediatemple.net ($38.95/month)... CMFX/Linux ... ugh ... many problems .. but a good testing host. Paul Giesenhagen QuillDesign - Original Message - From: Cutter (CF_Talk) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 22, 2003 2:04 PM Subject: CF

Re: Passing URL in query string

Phillip, What is it you're trying to accomplish as an end result ... returning users to where they came from? There may be other solutions to your problem ..(if you stated this, sorry, I must have missed it). Paul Giesenhagen QuillDesign - Original Message - From: Phillip B [EMAIL

Re: Best way to store 40 values?

indexing you should be fine. Paul Giesenhagen QuillDesign - Original Message - From: Paul Campano [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, January 17, 2003 8:51 AM Subject: Best way to store 40 values? I have a database of approx 1 songs. I want users to be able

Re: Best way to store 40 values?

and parse it. I used to be a HUGE fan of storing lists and wddx packets .. but now stay away from it as much as possible.. Paul Giesenhagen QuillDesign - Original Message - From: Bruce Sorge [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, January 17, 2003 8:49 AM Subject: Re

Re: SQL Join - Help!

SELECT A.DepartmentID, A.AdminName, A.GroupID, B.DepartmentName, C.Description FROM DeptAdmin A INNER JOIN Dept B ON A.DepartmentID = B.DepartmentID LEFT OUTER JOIN DeptGroups C ON A.GroupID = C.GroupID Try that out Paul Giesehagen QuillDesign - Original Message - From: Bosky,

Variables in CFMX

with a letter, and can only contain letter, numbers, and underscores. Thanks in advance! Paul Giesenhagen QuillDesign ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com

Re: Shopping Cart Under $500 bux?

. If you have any questions, feel free to email! Thank you and good luck in your search! Paul Giesenhagen QuillDesign - Original Message - From: Ernie Pena [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 08, 2003 9:54 AM Subject: Shopping Cart Under $500 bux? Anyone

Re: Preview a query string

Remove the cfquery /cfquery tags and put an output around it... Paul Giesenhagen QuillDesign - Original Message - From: Luis Lebron [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 08, 2003 2:32 PM Subject: Preview a query string I am building a dynamic query

Output not showing up

do a query cfquery datasource=DSN name=getStuff SELECT content FROM tableName WHERE id = 111 /cfquery cfoutput Recordcount: #getStuff.recordcount#br CONTENT: #getStuff.content# /cfoutput Produces Recordcount: 1 CONTENT: Has anyone ever heard of something like this? Paul Giesenhagen

Re: Output not showing up

Does it matter if the information we put into the field was just test and it didn't return that? (This is not my server, it is one of our customers) Paul Giesenhagen QuillDesign - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday

Cannot Connect to Mail Server CF 5

to server settings, just working on a cf template). I have also rebooted the machine to just make sure it didn't gack on something. Any help would be appreciated! Thank you Paul Giesenhagen QuillDesign ~| Archives: http

Re: SQL Question

cfquery name=currentHits UPDATE sitecount SET hits = hits + 1 WHERE id = #idpassed# /cfquery Hope this helps! Paul Giesenhagen QuillDesign - Original Message - From: Matthew Friedman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 27, 2002 9:18

Re: E-Commerce, and Variations

Medium 2.00 ProductOptions (This table combines the options and products) === productID, optionID 11 1 2 Hope this helps! Paul Giesenhagen QuillDesign - Original Message - From: Chris Alvarado [EMAIL PROTECTED] To: CF-Talk

Re: Payment Gateways? (Was: OPINIONS: PayFlow Pro and CF Integration?)

We wrote a custom tag for CDG Commerce (http://www.quilldesign.com/cdg/index.cfm) It is a simple custom tag to install. The custom tag is free as well as the payment gateway setup is free. You just have to pay the normal processing fee's monthly. Hope this helps! Paul Giesenhagen QuillDesign

Re: MySQL CF

\ is an escape character .. .Matt Robertson gave me a good tip .. use cfqueryparam for your insert and let CF escape all the correct characters. Hope this helps. Paul Giesenhagen QuillDesign - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent

Re: Attribute set validation error in tag CFOUTPUT

Interesting, I copied and pasted your code (added a client.ssmembername variable first) ... but it ran just fine for me. CF5/W2k Paul Giesenhagen QuillDesign - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 11

Where they came from

this problem before and I curious as to what solutions people have come up with. Thanks in advance! Paul Giesenhagen QuillDesign ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http

Re: Yahoo moving to PHP

Yes, I agree .. sounds like they went with open source only .. which is fine . but it also isn't an official Yahoo page either ... so I wouldn't let it hold too much water. Paul Giesenhagen QuillDesign - Original Message - From: Matt Liotta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED

Re: How do they do this?

They probably have a very nice system to do this, but basically they are scanning in pages from a catalog, then dumping the words from the page into a keyword field ... (thus making the keyword searches work). Paul Giesenhagen QuillDesign - Original Message - From: Kris Pilles [EMAIL

Re: Adding a target to a CFLOCATION URL?

Try this: meta http-equiv=Refresh content=.1;URL=http://whatever you want here Paul Giesenhagen QuillDesign - Original Message - From: Russ [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 2:28 PM Subject: Adding a target to a CFLOCATION URL? Hi All

OT: COLLATE SQL 7

, [userid] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [security] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ) ON [PRIMARY] Thanks Paul Giesenhagen QuillDesign ~| Archives: http

Re: OT topics and posts about OT topics

The problem with this is that users could click an on topic post and after 20 people did that a true on topic post would be moved off topic ... it is good in the thinking, but could work against itself. We would have to come up with a way around that. Good thought though. Paul Giesenhagen

Re: Variable locking

cfset session.fullname = variables.fullname /cflock Hope this helps! Paul Giesenhagen QuillDesign - Original Message - From: Luis Lebron [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, October 04, 2002 1:16 PM Subject: Variable locking I have a question on Session variables

Re: Client Variables

if they meant for it to be that way, but all the errors we found could have been done a better way so we changed things. Paul Giesenhagen QuillDesign - Original Message - From: Rob Rohan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:19 PM Subject: Client

Re: Client Variables

Yes, we scope about 99% of all our variables ... I should clarify, that time was of the essense and by changing the name the scalar error went away . at that point in time that is all that was needed. We didn't go deep into why or why not it worked. Paul Giesenhagen QuillDesign - Original

setting variable with a period

I am doing the following but am getting an invalid parser construct, it doesn't like the period is 1.5 cfscript request.shipcode_1.5 = '1.50'; /cfscript Any suggestions? Thanks Paul Giesenhagen QuillDesign ~| Archives

Re: setting variable with a period

No, this is on CF 5.0 .. but for CFMX what can you do to work around this? SO I cannot set the following in CFMX: cfset variables.myStr = Hello World, you are wonderful. (period at the end of a sentance?) That kind of bites! Paul Giesenhagen QuillDesign - Original Message - From

Re: setting variable with a period

Mercy .. I was totally missing it .. I was looking at the actual variable VALUE and it's 1.5 .. I didn't even notice that shipcode1.5 ... sorry .(doesn't work in 5 either). Thanks folks! Paul Giesenhagen QuillDesign - Original Message - From: Mark A. Kruger - CFG [EMAIL PROTECTED

OT: SQL without Subquery

(*) ... Any suggestions? Thank you Paul Giesenhagen QuillDesign ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http

Re: OT: SQL without Subquery

Jochem, Thanks, query worked great! Paul Giesenhagen QuillDesign - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 3:54 PM Subject: Re: OT: SQL without Subquery How about: SELECT l.id

Re: Credit Card Merchant Account/Services

Nathaniel, Go to http://www.quilldesign.com/cdg/index.cfm You will find a custom tag that connects to CDG commerce, we have been with them for 3 years now, great service! Paul Giesenhagen QuillDesign - Original Message - From: Nathaniel Horwitz [EMAIL PROTECTED] To: CF-Talk [EMAIL

Re: list delima

In looking at your code, totalOptPrice shouldn't be overwritten each time, it is outside of the loop .. are you sure that the listLen is more than 1? Output your list before the loop to see what you get. Paul Giesenhagen QuillDesign - Original Message - From: Emmet McGovern [EMAIL

OT (kinda) Unix/CFFILE ?

What permissions would you set on these two directories? Thank You Paul Giesenhagen QuillDesign __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http

Re: credit card processing monthly payments

. Best of Luck! Paul Giesenhagen QuillDesign - Original Message - From: Pete Freitag [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 27, 2002 3:13 PM Subject: FW: credit card processing monthly payments Hi folks, I am looking for a payment service

Re: JOIN Query (with query)

Can't use a subquery, this has to work with mysql. Thanks Paul Giesenhagen QuillDesign Try this: SELECT o.id, o.name, o.description FROM #request.optionTable# o LEFT OUTER JOIN #request.productOptionTable# po ON po.optionid = o.id WHERE o.id NOT EXISTS (SELECT * FROM

Re: JOIN Query (revised)

). I hope this makes sense! Thanks Paul Giesenhagen QuillDesign - Original Message - From: Greg Luce [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 8:31 AM Subject: RE: JOIN Query Why NOT IN? Is the url.productid a list? Have you tried

Re: JOIN Query (revised)

Well .. that did the trick .. I had to tweak alittle, but that was the idea .. very backwards but works!! Thank You! Paul Giesenhagen QuillDesign - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 9:36 AM Subject

Re: Line Nibbler Alert!!!

I had a bunch of dashes in a message and it striped out everything after that plus the dashes... Just FYI Paul Giesenhagen QuillDesign - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 10:36 AM Subject: Re

mySQL - I'm done and need help

figured out and need some guided help! Thank You Paul Giesenhagen QuillDesign __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk

Re: OT: Can't use UNION

v3.2.3 doesn't support FULL OUTER JOIN... Jochem .. I thought you had it for me, dang! Paul Giesenhagen QuillDesign - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 4:31 AM Subject: Re: OT: Can't use UNION

Re: OT: Can't use UNION SOLVED (kinda)

that needed fixing too that by doing a cfif variables.dbType Is mysql mysqlcodecfelseMS SQL code/cfif seemed to work well. Just FYI for those who care :) Paul Giesenhagen QuillDesign - Original Message - From: Tyler Silcox [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday

Re: please do my work for me

I may be missing something but that value is available as #url.pCode# cfoutput#url.pCode#/cfoutput Paul Giesenhagen QuillDesign - Original Message - From: Cantrell, Adam [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 4:37 PM Subject: please do my

OT: JOIN Query

I am trying to run a query that joins two tables and returns all the items that are listed in the optionTable, BUT NOT the ones who have the productid of the url.productid in the productOption table. (o.id = po.optionid) Here is the query I have thus far and it returns no results .. if I

Re: JOIN Query (with query)

Odd the query didn't go through.. here it is again: SELECT o.id, o.name, o.description FROM #request.optionTable# o LEFT OUTER JOIN #request.productOptionTable# po ON po.optionid = o.id WHERE po.productid NOT IN ('#url.productid#') I am trying to run a query that joins two tables and returns

Re: JOIN Query (with query)

Nope, that still pulls out the options that are associated with the productid Paul Giesenhagen QuillDesign - Original Message - From: Matthew Walker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 10:53 PM Subject: RE: JOIN Query (with query) How

CFMX

cflock timeout=20 throwontimeout=No type=EXCLUSIVE scope=SESSION cfset session.security = security /cflock Thank You Paul Giesenhagen QuillDesign __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ

Re: CFMX

Just figured it out ... I changed the query columname to thisSecurity (as opposed to security) and it seemed to fix the problem .. This worked in v5.0 but not CFMX ... Thanks for those who may be replying! Paul Giesenhagen QuillDesign - Original Message - From: Paul Giesenhagen [EMAIL

OT: Can't use UNION

#request.taxCanadaTable# ORDER BY 1 Thank you Paul Giesenhagen QuillDesign __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http

Re: Can't use UNION

Need the order by in there ... UNION is not supported in MySQL and I need a query that works in both MySQL and MS SQL 2000 Thank you Paul Giesenhagen QuillDesign - Original Message - From: Thanh Nguyen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 5

Re: Can't use UNION

This query was orignially written for MS SQL 2000 and needs to work in both MS SQL 2000 and MySQL :) So I am looking for another way around putting two tables together to get results named the same. Thanks! Paul Giesenhagen QuillDesign - Original Message - From: Joshua Tipton [EMAIL

Re: Can't use UNION

It is a distributed app .. Paul Giesenhagen QuillDesign - Original Message - From: Ken Wilson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 7:50 PM Subject: RE: Can't use UNION I need a query that works in both MySQL and MS SQL 2000 Why

Re: Random Product, with a twist?

some control over the products that are added to the list as well. It doesn't need session variables or application variables either. I am sure there are other solutions Good Luck Paul Giesenhagen QuillDesign - Original Message - From: Che Vilnonis [EMAIL PROTECTED] To: CF-Talk [EMAIL

Re: OT? SQL visual editor?

Is there a tool out there that replaces enterprise manager? Does the same things but a third party app? Just curious Paul Giesenhagen QuillDesign Yeah Enterprise manager. Very handy. J. John Wilker Web Applications Consultant, Writer Macromedia Certified ColdFusion Developer

Re: What's wrong with this?

Rick, Are you getting any errors? It looks like you have a 2 dimension array .but you are setting it to a 3 dimension. Try cfset MultipleWaivers=ArrayNew(2) Paul Giesenhagen QuillDesign - Original Message - From: Rick Faircloth [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent

Re: What's wrong with this?

Oops sorry didn't see your error message ... :( Paul Giesenhagen QuillDesign - Original Message - From: Rick Faircloth [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, September 21, 2002 9:02 PM Subject: What's wrong with this? Can anyone tell me what's wrong

Re: OT Generating a data/Enterprise Manager

No, I can export the 'data' but not the actual SQL inserts and data combined .. at least I can't find how to do it I want to include some of this information into an install script that has a number of default values (too many to type in if it can be avoided). Thank You Paul Giesenhagen

OT: Multiple Inserts

Can you do multiple insert statements in one CFQUERY statement? ie cfquery ... Insert into Insert Into ... Insert Into ... /cfquery If yes, is there something special that needs to be added? Thanks Paul Giesenhagen QuillDesign

Re: OT Generating a data/Enterprise Manager DONE

Matt, Thank you for your solution, it worked perfectly! Paul Giesenhagen QuillDesign - Original Message - From: Matthew Fusfield [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 20, 2002 10:35 AM Subject: RE: OT Generating a data/Enterprise Manager Paul, Take

OT Generating a data/Enterprise Manager

the table and import the values at the same time? Is it possible? Thanks Paul Giesenhagen QuillDesign __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http

<    1   2   3   4   5   6   7   >