Re: Hosting Problems

2008-03-09 Thread Mary Jo Sminkey
First of all if you need to install your own tags then you shouldn't be on shared hosting and if you do choose to use them and IF and I said IF the host will even let you install them at all but you shouldn't expect them to be an expert on every tag out there. I'd agree with this, but

Trying to create a query with a subquery dependent on an aggregate function result

2008-03-09 Thread Scott OConnell
Hi, I have a large query which uses many left joins in order to list a directory of contacts. Select id, name, summary, countryname, categoryID, categoryName From table_contacts left join . Where ... The where statement includes cfif statements in order for the user to choose which

Re: Trying to create a query with a subquery dependent on an aggregate function result

2008-03-09 Thread William Seiter
instead, you can order by ID cfoutput query='[queryname]' group='ID' Use the group part as the display the person; cfoutputUse the inner part to display the categoryname and categoryID/cfoutput /cfoutput It will return many more rows than you had originally intended, but it

CFLDAP finds cn but can't find password or certain attributes

2008-03-09 Thread david reiter
I'm using a standard CFLDAP query pair for auth just as Adobe describes (http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_18169), and it works great for all but the latest of my application users. The first query (confirming the user in the name server with admin credentials) works

Re: using CFQuery across multiple DSNs

2008-03-09 Thread Ben Conner
Hi Mike, That will work. Thanks! --Ben Dawson, Michael wrote: You cannot query from more than one DSN at a time, however, there are some alternatives: * Use the database server to create links between other database servers. * Use Query of Query (QoQ) to merge multiple recordsets after

RE: Hosting Problems

2008-03-09 Thread Jim Davis
On Thu, Mar 6, 2008 at 10:19 AM, Richard White [EMAIL PROTECTED] wrote: we have had severe problems with host my site hosting company, can anyone recommend a really good coldfusion 8 and mysql hosting site. I think most of the problems that we see talked about here are with the hostee, not

Re: Slow machine - JRun?

2008-03-09 Thread James Holmes
If you are seeing a lot of paging the following things are among those relevent: - How much physical RAM do you have on this box? - How much memory is allocated to the ColdFusion JVM (heap, stack and perm space)? - What else is the box running (e.g. is the DB on the machine)? On Sun, Mar 9,

Re: Slow machine - JRun?

2008-03-09 Thread James Holmes
And now that I've taken the five seconds to look at your pics that I should have spent before posting, I can answer these for myself (sorry). It seems Windows is being really helpful by sticking JRUN in the swapfile and running it all from there. It's also paging a fair amount of SQL server,

RE: CFLDAP finds cn but can't find password or certain attributes

2008-03-09 Thread Dawson, Michael
What directory server are you using? Active Directory, Novell, etc? Why do you need the user's password? If you need the password, caputure it when the user logs in. Once they have successfully logged-in, then you will know that the password is correct. Knowing any incorrect passwords is

Is cflocation like a link??

2008-03-09 Thread Ali
Hi: I was working on a page which was sending some URL variables to another page and I figured out that using cflocation could help me there but every time I use cflocation the following error comes back: Syntax error (missing operator) in query expression 'Tbl_Users.UserID = Tbl_AccOrders.UserID

Forms And Coldfusion

2008-03-09 Thread Phillip Perry
Hello, I'm building a shopping cart and I've hit a bit of a snag. I'm using ± buttons on a form to increase/decrease the qty of the item(s) in the cart before purchase. Now I know how to access the new quantity of items, but I don't know how to display them properly on the screen. If i pass the

RE: Is cflocation like a link??

2008-03-09 Thread Dawson, Michael
CFLOCATION performs a browser-side redirect. On your second page, CFDUMP the URL scope and see if you are passing the variables correctly. m!ke _ From: Ali [mailto:[EMAIL PROTECTED] Sent: Sun 3/9/2008 2:24 PM To: CF-Talk Subject: Is cflocation like a link?? Hi: I was working on a

Re: Is cflocation like a link??

2008-03-09 Thread Dominic Watson
You don't need to use cfoutput in the url string of your cflocation - indeed, you don't need to use cfoutput in any attribute of a ColdFusion tag. So try: cflocation url=/dampezeshki_final/Accessories/SingleAccessories_PurchEdit.cfm?OrderID=#rsCheckdup.OrderID# addtoken=no HTH Dominic -- Blog

Re: Is cflocation like a link??

2008-03-09 Thread Ali
You don't need to use cfoutput in the url string of your cflocation - indeed, you don't need to use cfoutput in any attribute of a ColdFusion tag. So try: cflocation url=/dampezeshki_final/Accessories/SingleAccessories_PurchEdit.cfm?OrderID=#rsCheckdup.OrderID# addtoken=no HTH Dominic

Re: What are the Necessary Code Changes for Migrating from 6.1 to 8?

2008-03-09 Thread Aaron Rouse
We had to change all of our LDAP calls to be secure or else they would fail in CF8 On Fri, Mar 7, 2008 at 5:23 PM, Nathan Wells [EMAIL PROTECTED] wrote: I posted this issue on Adobe's forums a couple of days ago, but I haven't had any (good) responses. I recently started testing our code,

Re: Is cflocation like a link??

2008-03-09 Thread Ali
You know what, I used DW8 and I used the parameters options in cflocation insertion button when I browsed but DW8 behaves like it is a normal link and puts cfoutput there. I didn't know I didn't need the cfoutput there and the problem came out. So I hope Adobe edits the problem in Cflocation

test...please ignore

2008-03-09 Thread Eric Roberts
Test...please ignore ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive:

Datetime issue as of This morning

2008-03-09 Thread BA Hellman
Hello, I'm seeking advice on a recent bug which I believe is due to daylight savings time. This morning I noticed that the date/time elements on my project were incorrect. Items on the site will say 2 hours ago or 1 min ago etc. how they are saying -1hr ago or -3600s ago, which is exactly an

Re: CFLDAP finds cn but can't find password or certain attributes

2008-03-09 Thread david reiter
Thanks, Michael. I don't think the syntax is the problem because it works when I replace #FORM.UserLogin# with the admin account username and #FORM.UserPassword# with the admin password. I assume it's an AD because the password name is unicodePwd - their admin isn't sure (believe it or

Re: CFLDAP finds cn but can't find password or certain attributes

2008-03-09 Thread david reiter
Thanks, Michael. I don't think the syntax is the problem because it works when I replace #FORM.UserLogin# with the admin account username and #FORM.UserPassword# with the admin password. I assume it's an AD because the password name is unicodePwd - their admin isn't sure (believe it or

Re: Datetime issue as of This morning

2008-03-09 Thread Matthew Williams
My understand is that Coldfusion and MS SQL Server 2005 all use the server's time when using the GETDATE() type functions. Does anyone have any idea why there would be a discrepancy? ColdFusion derives its date/time from the JVM. This became an issue last year. If you're running CFMX 7 you'll

Re: CFLDAP finds cn but can't find password or certain attributes

2008-03-09 Thread david reiter
Thanks, Michael. I don't think the syntax is the problem because it works when I replace #FORM.UserLogin# with the admin account username and #FORM.UserPassword# with the admin password. I assume it's an AD because the password name is unicodePwd - their admin isn't sure (believe it or

Re: Hosting Problems

2008-03-09 Thread James Holmes
I simply expected from HMS a shared linux CF server that stayed functional most of the time. They were unable to provide this - to the point where they no longer offer shared Linux CF hosting. I'll leave it to your judgement as to whether I expected too much. They recommended I move to VPS, so I

RE: Hosting Problems

2008-03-09 Thread Jim Davis
-Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Sunday, March 09, 2008 9:56 PM To: CF-Talk Subject: Re: Hosting Problems I simply expected from HMS a shared linux CF server that stayed functional most of the time. They were unable to provide this - to the

cflayout tabs/uploading images is erroring

2008-03-09 Thread Will Tomlinson
I'm trying out cflayout tabs with a cfform in each tab. One of the cfforms has a simple image upload field. It works fine as a page by itself, but stick it in the layout tab, and I get an Element EVENTIMAGE is undefined in FORM error. I dumped it and sure enough, cfform doesn't seem to be

Re: cflayout tabs/uploading images is erroring

2008-03-09 Thread Will Tomlinson
Yep, I commented out the cflayout tags'n'such, and the eventimage field magically showed up again. What's the trick to it? Been readin docs and don't see it. Thanks, Will ~| Adobe® ColdFusion® 8 software 8 is the most

Re: Problem uploading file from form in cfdiv

2008-03-09 Thread Will Tomlinson
Yeah I was thinking about doing it with a pop window but I was trying to avoid doing that, I might have to though. Thanks for the help. Anyone else have any ideas? Did you ever figure out a workaround steve? Will ~|

Re: cflayout tabs/uploading images is erroring

2008-03-09 Thread Will Tomlinson
Found a thread on this subject. It's kinda sucky. I can't do a file upload in my tab? Ug! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial