Re: CF, JQuery and IE

2008-09-16 Thread Azadi Saryev
btw, you can easily implement cfdiv and cfwindow functionality with just jquery... jquery has native methods to load ajax content into an element on a page like a div, and there are nice plug-ins like thickbox and jqmodal that have same functionality as cfwindow... of course, cf makes it a lot eas

Re: CF, JQuery and IE

2008-09-16 Thread Charlie Griefer
yeah, to add to what Azadi said... i've not done anything yet with cfdiv, but i've worked with cfwindow. integrating jquery into a cfwindow is tricky. as per the docs, functions inside cfwindow (and maybe cfdiv as well?) need to be in the format of: myFunction = function (args) { stuff } no

Re: CF, JQuery and IE

2008-09-16 Thread Azadi Saryev
i have had issues with running jquery-based scripts inside cfwindow/cfdiv. make sure you initate jquery and write the functions you call in the calling page, not in the page loaded inside cfdiv. you may also have to re-initiate events and/or properly delegate events on content load in cfdiv. hth

Period at end of domain name causes SSL warnings

2008-09-16 Thread Dan LeGate
An interesting situation arose when someone sent an email with our server URL that included a period (dot) at the end of the domain name like this: http://www.servername.edu. and they actually included the period as part of the link. It throws a nasty SSL warning. Strangely, it does not say

RE: Flex CFC Call Problem - Unable to invoke CFC - Could not find the ColdFusion Component or Interface"

2008-09-16 Thread Dave Watts
> I'm using web services since those were provided to me the > database people that I am trying to talk to. > > I wish this were easier, but unfortunately this is my first > hack at Flex/CF and this is not a straight forward program at all. So, in your Flex app, you have something like this?

Re: cfmail no longer working AND scheduled tasks arent being run

2008-09-16 Thread Rob Parkhill
Well there are two places where credentials can be supplied to the mail server from CF. Either in the Administrator, there is a login and password combination supplied, or it is done in the cfmail tag in the page that is actually sending the e-mail. Again look in the mail.log to see if there is a

Re: cfmail no longer working AND scheduled tasks arent being run

2008-09-16 Thread Torrent Girl
The logs indicate that the processes are running. I am not sure of what auth the mail server is using. >What do the log files for the mail indicate. Usually they will give a >reason as to why they are undeliverable. What authentication is the mail >server using? I mean, when it hits your mail

Re: CF and PHP same server

2008-09-16 Thread James Holmes
PHP requires a single threaded webserver (as some of the libraries it runs aren't thread safe: http://neosmart.net/blog/2008/dont-believe-the-lies-php-isnt-thread-safe-yet/), so you need to run the Apache Prefork MPM. This is less than optimal for high volume sites, but it will work. On Wed, Sep 1

Re: CF and PHP same server

2008-09-16 Thread Kay Smoljak
On Wed, Sep 17, 2008 at 2:11 AM, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > BTW...what OS and web server are you doing this with? > We'd be Windows 2003 with IIS 6 for this one. I've been running this config on shared hosting for 3+ years - so I can run WordPress for my blog and CF for demos. Ha

Re: Flex CFC Call Problem - Unable to invoke CFC - Could not find the ColdFusion Component or Interface"

2008-09-16 Thread Brian Kotek
Make sure "use-mappings" is set to true in your services-config.xml. On Tue, Sep 16, 2008 at 2:55 PM, Matthew Dolloff <[EMAIL PROTECTED] > wrote: > Hey all. I'm really new to Flex and CF and I am having to get someone > else's code running on my local machine (ie local apache, local mssql, local

Re: cfcookie expires default

2008-09-16 Thread Charlie Griefer
it's been fixed for a couple of versions. as of 6.1 (maybe 6.0) :) On Tue, Sep 16, 2008 at 4:00 PM, Phillip M. Vector < [EMAIL PROTECTED]> wrote: > Back in CF5 (and 6 I think), if you did a cflocation on the same page as > the cfcookie, the cookie didn't take. Are you doing it? If so, try > remo

Re: cfcookie expires default

2008-09-16 Thread Phillip M. Vector
Back in CF5 (and 6 I think), if you did a cflocation on the same page as the cfcookie, the cookie didn't take. Are you doing it? If so, try removing the cflocation and see what happens. I suspect they fixed the bug in CF8, but perhaps not. Ioannis Papanikolaou wrote: > Philip, > I am not aware

Re: cfcookie expires default

2008-09-16 Thread Ioannis Papanikolaou
hello Nathan, It is not a browser issue or that I am reseting the cookie on the page load. The cookie it self is not not taking the corect Expires parameter. If I check on the cookie manager on firefox I have "at end of session" This has been tested on opera chrome and firefox. Philip, I am not

Re: CF, Ajax and Autocomplete Problems

2008-09-16 Thread Mark Picker
Hi, I may also be missing something here, but why are you opening a and then closing it straight away? cfsetting enablecfoutputonly="yes">. The very last line of code has a closing cfsilent with no opening tag. Cheers Mark ~~~

Re: capture url variable?

2008-09-16 Thread John P
Thank you all, that's exactly what I wanted to do. >cgi.query_string > > > > >> ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912

Re: capture url variable?

2008-09-16 Thread Charlie Griefer
cgi.query_string On Tue, Sep 16, 2008 at 3:00 PM, John P <[EMAIL PROTECTED]> wrote: > Hi, > > I need to capture a url variable then add it to a redirect so my > application which is changing servers will still work. > > Not sure where to start. Thanks, John > > > >

Re: capture url variable?

2008-09-16 Thread Alan Rother
K... Could you give us a little more info? What url variable are you looking to capture and what do you want to do with it in the re-direct? Are you looking to simply take whatever is in the URL string and pass it off to another server like this: http://www.MyOldAndSoonToBeGoneServer.com/index.c

Re: capture url variable?

2008-09-16 Thread Shannon Peevey
Here is a link to a tutorial: http://www.peachpit.com/articles/article.aspx?p=30497&seqNum=9 Here is my take on it with a meta-refresh: http://localhost/ ?#URL.myvar#"> But, it is pretty much 5pm, so I wouldn't trust it :) speeves On Tue, Sep 16, 2008 at 5:00 PM, John P <[EMAIL PROTECTED]> wrot

Optimize Query of Query

2008-09-16 Thread Jim McAtee
I have a process that needs to do about 500 record lookups by ID. I thought I'd do a single query of the table, pulling down the needed data for every record on file (say 1000 records, just three columns) and then use QoQ instead of hitting the database so many times. Is there any way to index

capture url variable?

2008-09-16 Thread John P
Hi, I need to capture a url variable then add it to a redirect so my application which is changing servers will still work. Not sure where to start. Thanks, John ~| Adobe® ColdFusion® 8 software 8 is the most important and

Re: cfcookie expires default

2008-09-16 Thread Phillip M. Vector
Is the "No cookies before a cflocation" bug still there in CF8? Nathan Strutz wrote: > Check to make sure you're not deleting it when you log out of your > application, if you log out. Also, check to make sure you're not recreating > it or changing the value anywhere, such as with a cfset or in ja

Re: cfcookie expires default

2008-09-16 Thread Nathan Strutz
Check to make sure you're not deleting it when you log out of your application, if you log out. Also, check to make sure you're not recreating it or changing the value anywhere, such as with a cfset or in javascript, as both of these can change it to the default session based timeout. Otherwise, t

Re: Flex CFC Call Problem - Unable to invoke CFC - Could not find the ColdFusion Component or Interface"

2008-09-16 Thread Matthew Dolloff
>> Hey all. I'm really new to Flex and CF and I am having to > >Are you using Remoting? Or WebService? > >If you're using Remoting, did you recompile your app after changing >services-config.xml? > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ > >Fig Leaf Software provides the high

cfcookie expires default

2008-09-16 Thread Ioannis Papanikolaou
Hello every one. coldfusion 8 I am using this to setup my cookie problem is that the cookie expires at the end of session and when I restart the browser is not there any nore. This means that it is taking the default parameter. Any ideas ? Thanx Ioannis ~~

Re: CF, JQuery and IE

2008-09-16 Thread adam sontag
Typically, when there's jQuery AJAX stuff working in FF3 but not IE, it means you're returning malformed markup. Seems counterintuitive, but IE is the browser that barfs. ~| Adobe® ColdFusion® 8 software 8 is the most importan

RE: Flex CFC Call Problem - Unable to invoke CFC - Could not find the ColdFusion Component or Interface"

2008-09-16 Thread Dave Watts
> Hey all. I'm really new to Flex and CF and I am having to > get someone else's code running on my local machine (ie local > apache, local mssql, local cf). I can get the page to semi > load but when I load it I get an error that says "Unable to > invoke CFC - Could not find the ColdFusion C

Re: Flex CFC Call Problem - Unable to invoke CFC - Could not find the ColdFusion Component or Interface"

2008-09-16 Thread Matthew Dolloff
>Flex searches from the web root down. You should be able to point from the >web root down and invoke it using the url. > >http://localhost/folder1/folder2/myservice.cfc?method=test > >If you can not then it is not pointing to the right location of the cfc. > >Thank You >Dan Vega >[EMAIL PROTECTED]

Re: Flex CFC Call Problem - Unable to invoke CFC - Could not find the ColdFusion Component or Interface"

2008-09-16 Thread Dan Vega
Flex searches from the web root down. You should be able to point from the web root down and invoke it using the url. http://localhost/folder1/folder2/myservice.cfc?method=test If you can not then it is not pointing to the right location of the cfc. Thank You Dan Vega [EMAIL PROTECTED] http://ww

Flex CFC Call Problem - Unable to invoke CFC - Could not find the ColdFusion Component or Interface"

2008-09-16 Thread Matthew Dolloff
Hey all. I'm really new to Flex and CF and I am having to get someone else's code running on my local machine (ie local apache, local mssql, local cf). I can get the page to semi load but when I load it I get an error that says "Unable to invoke CFC - Could not find the ColdFusion Component or

Re: CF and PHP same server

2008-09-16 Thread Barney Boisvert
I use Apache on Linux everywhere I've done both, using both JRun and Tomcat as the JEE server for CF to live in. cheers, barneyb On Tue, Sep 16, 2008 at 10:11 AM, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > BTW...what OS and web server are you doing this with? > > Windows/IIS? > > Windows/Apache

Re: CSS Question

2008-09-16 Thread Scott Stewart
Scott Stewart wrote: > I've applied a style (background-color=red) to an individual option tag > and it's colored in the drop down. > > Sandra Clark wrote: > >> You can't color individual option tags. You can however color >> tags >> >> >> Sandra Clark >> = >> http://www.shayna.co

Re: CSS Question

2008-09-16 Thread Scott Stewart
this slid in late Scott Stewart wrote: > I've applied a style (background-color=red) to an individual option tag > and it's colored in the drop down. > > Sandra Clark wrote: > >> You can't color individual option tags. You can however color >> tags >> >> >> Sandra Clark >> =

Re: CF and PHP same server

2008-09-16 Thread Bryan Stevenson
On Tue, 2008-09-16 at 09:42 -0700, Barney Boisvert wrote: > I do it without issue on several boxes. Web server just delegates to > the right engine based on extension: works like a charm. > > cheers, > barneyb Thanks Barneyfigured it would be fairly safe/straightforward. BTW...what OS and we

Re: SQL Help

2008-09-16 Thread C S
> It also begs the question, if they were only supposed to have one > entry > per e-mail address, why wasn't there error checking or a constraint on > > the table to force this in the first place? True enough. I was thinking the same thing myself ;-) ~

RE: CSS Question

2008-09-16 Thread Sandra Clark
Sorry, I saw color. Its been a while since I attempted a color in an option. I tend to use for those. Mea Culpa Sandra Clark = http://www.shayna.com Training and Consulting in CSS and Accessibility Team Fusebox -Original Message- From: Dave Francis [mailto:[EMAIL PR

Re: SQL Help

2008-09-16 Thread Justin Scott
> The records are from contest entries. People can only enter with one email > address. Some people entered multiple times, using the same email address. So, why all the complexity with joins and subqueries? Just... SELECT DISTINCT email FROM sometable then pick a winner from the list of

RE: CSS Question

2008-09-16 Thread Dave Francis
Hi Sandra, First off, let me say that I absolutely accept you as the authority on CSS, at least on this list. But... This seems to work (in the drop-downs if no size specified), even on chrome: Green Red -Original Message- From: Sandra Clark [mailto:[EMAIL PR

Re: SQL Help

2008-09-16 Thread Jeff F
The records are from contest entries. People can only enter with one email address. Some people entered multiple times, using the same email address. I need to get a record set used to pick a winner, including just one of the records from the duplicate email entries. ~

Re: CSS Question

2008-09-16 Thread Scott Stewart
I've applied a style (background-color=red) to an individual option tag and it's colored in the drop down. Sandra Clark wrote: > You can't color individual option tags. You can however color > tags > > > Sandra Clark > = > http://www.shayna.com > Training and Consulting in CSS and

Re: SQL Help

2008-09-16 Thread C S
> I need to get a record set used to pick a winner, including just one > of the records from the duplicate email entries. If it does not matter which one, try the query I posted in my first response. The syntax is not tested, but it has the right concept. ~

Re: CF, Ajax and Autocomplete Problems

2008-09-16 Thread Dominic Watson
That code should through errors or output invalid xml, unless what you have posted is not the complete code. Visit the page in your browser and you should see some verbose errors from either coldfusion or your browser's xml parser. Dominic 2008/9/16 Ian Vaughan <[EMAIL PROTECTED]>: > Hi Mike > >

Re: CF and PHP same server

2008-09-16 Thread Barney Boisvert
I do it without issue on several boxes. Web server just delegates to the right engine based on extension: works like a charm. cheers, barneyb On Tue, Sep 16, 2008 at 9:40 AM, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > Hey All, > > Just checking for any major gotchas with running CF and PHP on

CF and PHP same server

2008-09-16 Thread Bryan Stevenson
Hey All, Just checking for any major gotchas with running CF and PHP on the same server (a VPS BTW)?? Would be CF 8 and whatever the latest PHP is. TIA Cheers - Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.

RE: CSS Question

2008-09-16 Thread Sandra Clark
You can't color individual option tags. You can however color tags Sandra Clark = http://www.shayna.com Training and Consulting in CSS and Accessibility Team Fusebox -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2008 1

Re: CSS Question

2008-09-16 Thread Scott Stewart
exactly... :) Weidler, Wilfred C. wrote: > > Ok, I get what you are trying to do now. You want a colored box beside > the hex value in the option tag. > > Correct? > > Chuck > -Original Message- > From: Scott Stewart [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 16, 2008 12:30 P

Re: CF8 Report Builder - Report Format Error

2008-09-16 Thread Jim Gabler
Thanks Marcus. Just using the absolute path did the trick (could have sworn that I had tried that). What threw me off was that Dreamweaver provided only 3 options for the filename attribute and they were "ftp:", "http:", and "https:". So I was really led astray by Dreamweaver (guess this is a

Re: SQL Help

2008-09-16 Thread Jeff F
The records are from contest entries. People can only enter with one email address. Some people entered multiple times, using the same email address. I need to get a record set used to pick a winner, including just one of the records from the duplicate email entries. ~

RE: CSS Question

2008-09-16 Thread Weidler, Wilfred C.
Ok, I get what you are trying to do now. You want a colored box beside the hex value in the option tag. Correct? Chuck -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2008 12:30 PM To: CF-Talk Subject: Re: CSS Question this colors the ent

Re: CSS Question

2008-09-16 Thread s. isaac dealey
> > get_category.hex_id>selected> >  #hex_id# > > > > any reason why the span tag shouldn't produce a small box colored with > the dynamic hex value Oh I read the other replies first before I noticed that it was inside an option box... I've not done much with styling option elements, bu

RE: CSS Question

2008-09-16 Thread Andy Matthews
I don't believe that option tags can contain children. -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2008 11:30 AM To: CF-Talk Subject: Re: CSS Question this colors the entire option tag here's the rendered html with a div in place, still

Re: CSS Question

2008-09-16 Thread s. isaac dealey
If you can live without support for IE6, you can set the display for the span to "inline-block" which (as best I can tell) makes it behave the way an image behaves with regard to its "surface area". That will let you give it a width without needing to float it left or the like. -- s. isaac deal

Re: CSS Question

2008-09-16 Thread Scott Stewart
this colors the entire option tag here's the rendered html with a div in place, still no love  #CC  #66CC66  #CC6699

RE: CSS Question

2008-09-16 Thread Weidler, Wilfred C.
Put the style attribute in the tag and get rid of the . Chuck -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2008 12:07 PM To: CF-Talk Subject: CSS Question selected>  #hex_id# any reason why the span tag shouldn't produce a small

RE: CSS Question

2008-09-16 Thread Andy Matthews
Because a span is an inline element and cannot have a width applied to it. If you want a block you're either going to have to put more non-breaking spaces inside your span, use a div, or set display: block on your span. -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent

Re: SQL Help

2008-09-16 Thread C S
> You could try something like this. Not tested, but the idea is to > select a single PK for each email. Then use a JOIN to display the > details for those PK's. Note, the previous query assumes it does not matter which record is returned.

Re: SQL Help

2008-09-16 Thread C S
> When there are records with duplicate > emails addresses, I need to include one of them. So you are trying to display one record for each email address? You could try something like this. Not tested, but the idea is to select a single PK for each email. Then use a JOIN to display the detail

Re: SQL Help

2008-09-16 Thread Judah McAuley
Are the other fields in your table the same when the email is the same? Meaning, are the records really duplicate? Or is it just the email that is duplicate and the other fields may have varying values for two rows that have the same email? If they do vary, do you care which of the "duplicate" rows

Re: Using Google Maps API

2008-09-16 Thread Lawrence Mak
> Hi, Lawrence, > > Before you do anything else, I would suggest changing your > into a regular (and launch the JavaScript function with a > hyperlink or something) just to make sure that there isn't something > about the way s are rendered that the Google API doesn't like. > > If you get th

CSS Question

2008-09-16 Thread Scott Stewart
selected>  #hex_id# any reason why the span tag shouldn't produce a small box colored with the dynamic hex value -- Scott Stewart ColdFusion Developer Office of Research Information Systems Research & Economic Development University of North Carolina at Chapel Hill Phone:(919)843-2408

RE: CF, Ajax and Autocomplete Problems

2008-09-16 Thread Dawson, Michael
Also, I see an ending tag, but no beginning tag. Mike -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2008 9:28 AM To: CF-Talk Subject: RE: CF, Ajax and Autocomplete Problems Hi Mike I have surrounded it with a cfsilent tag to remove the w

RE: CF, Ajax and Autocomplete Problems

2008-09-16 Thread Dawson, Michael
Can you provide us with the link to this page? Mike -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2008 9:28 AM To: CF-Talk Subject: RE: CF, Ajax and Autocomplete Problems Hi Mike I have surrounded it with a cfsilent tag to remove the white

Re: Custom Tag Paths

2008-09-16 Thread s. isaac dealey
Hey Adam, You probably have a good handle on what's going on in your environment... certainly better than I do, given that I'm only hearing about it second hand. I just thought I'd throw out that I was a bit confused when I first discovered that CF will throw a "template not found" error if you g

Re: CF8 Report Builder - Report Format Error

2008-09-16 Thread Marcus Raphelt
Hi Jim, the filename attribute requires an absolute system path, you might try expandpath(). bye, marcus Jim Gabler schrieb: > filename="http://dtsc-dev/temp/SBA_Temp.pdf"; >format = "PDF" >template = > "c:\\inetpub\wwwroot\Database\Military_Billings\CFR_Templates\SBA.cfr" >ove

CF8 Report Builder - Report Format Error

2008-09-16 Thread Jim Gabler
I'm trying out Report Builder for the first time to generate a report. While I can output the file to the screen without any problems (by leaving out the filename attribute), I am getting an error when trying to save it. If I place a document in the location where I've specified with the filen

Re: CF, JQuery and IE

2008-09-16 Thread Scott Stewart
As far as it happening in all plugins, the answer is yes. It'll work like a champ in FF3 and fail completely in IE7 J.J. Merrick wrote: > Scott, > > though I don't think this is the case with the CF ajax stuff but I > know that when we used prototype and jquery together the use of the $ > sign co

Re: SQL Help

2008-09-16 Thread Jeff F
Thanks Jim. Now I see. I guess what I'm looking for would be something like this then: SELECT mytable.lastname,mytable.email FROM mytable GROUP BY mytable.email HAVING distinct(mytable.email) Which of course does not work. When there are records with duplicate emails addresses, I need t

Re: SQL Help

2008-09-16 Thread Jim Wright
On Tue, Sep 16, 2008 at 10:13 AM, Jeff F <[EMAIL PROTECTED]> wrote: > SELECT distinct mytable.email > FROM mytable > I get 19588 as a recordcount. This number would include email addresses that are duplicated in the table (but only a count of 1 for each distinct address). >SELECT mytable.

RE: CF, Ajax and Autocomplete Problems

2008-09-16 Thread Ian Vaughan
Hi Mike I have surrounded it with a cfsilent tag to remove the white space, and its still the same, no errors but no results appear? And I'm using cfcontent as below. cfsetting enablecfoutputonly="yes"> SELECT surname FROM tablename WHERE surname LIKE ORDER by surname ASC #theXML#

Re: SQL Help

2008-09-16 Thread Jeff F
Jim, At first glance that seems to work, however the recordcounts appear to be off. What I did was a simple query to find the total number of distinct email addresses: SELECT distinct mytable.email FROM mytable I get 19588 as a recordcount. When I run SELECT mytable.lastname,

RE: SQL Help

2008-09-16 Thread Rick Faircloth
Sorry about the output part in the bottom; that was from my test query. Should be: select distinct email from mytable select lastname, firstname, city, state from mytable where email = '#select_distinct

RE: CF, Ajax and Autocomplete Problems

2008-09-16 Thread Dawson, Michael
My suggestion would be to create a .cfm page with no dynamic code. Have it ONLY output pure XML. Heck, even take the XML generated by the PHP page and paste it into the .cfm page. As with the original poster, however, make sure there is no white space above the first XML tag. Also, us the CFCON

Re: CF, Ajax and Autocomplete Problems

2008-09-16 Thread Phillip M. Vector
Sorry man. Just got a bit annoyed that someone came onto a CF list and starting saying PHP can do something that CF can't (which is a lie). http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_i_07.html Read that over and try it out. Pay special attention to autosuggest. Your

Re: CF, JQuery and IE

2008-09-16 Thread J.J. Merrick
Scott, though I don't think this is the case with the CF ajax stuff but I know that when we used prototype and jquery together the use of the $ sign conflicted. jQuery has a great function you can run that changes that to anything. it is called noConflict() var $j = jQuery.noConflict(); that th

Re: CF, Ajax and Autocomplete Problems

2008-09-16 Thread Phillip M. Vector
Ian Vaughan wrote: > Just tried what you suggested, but its still the same? Do you mean that as a question "Is it still the same?" or do you mean that as a statement "It is still the same."? > This is the original php script, perhaps Coldfusion can't offer the same > functionality as PHP, that'

RE: CF, Ajax and Autocomplete Problems

2008-09-16 Thread Ian Vaughan
Hi Dominic Just tried what you suggested, but its still the same? This is the original php script, perhaps Coldfusion can't offer the same functionality as PHP, that's why there are problems implementing it in CF? --- ($i+1) ,"value"=>htmlspecialchars($aUsers[$i]), "info"=>htmlspeci

Re: SQL Help

2008-09-16 Thread Jim Wright
On Tue, Sep 16, 2008 at 8:58 AM, Jeff F <[EMAIL PROTECTED]> wrote: > I've got a table (MySQL) with about 20k records. I'd like to be able to get > all fields from the table with distinct email addresses. Essentially, I'm > weeding out records with duplicate email addresses. > > What I'm trying do

Re: SQL Server 2005 permission problems

2008-09-16 Thread James Buckingham
Well I got this up and running through ODBC but unforunately when I did Transfer ORM, which I'm using to manage my DAO, throws an error message. How do permissions work in SQL Server in terms of CF. From what I can all I need is the datawriter and datareader roles applied to that user. This is w

RE: SQL Help

2008-09-16 Thread Rick Faircloth
To view all your records with duplicate email addresses, you might try something like this: select distinct email from mytable select lastname, firstname, city, state from mytable where email = '#select_

Re: SQL Help

2008-09-16 Thread Gert Franz
Assuming your PK is named customerID you can do the following: SELECT mytable.lastname, mytable.firstname, mytable.city, mytable.state FROM mytable WHERE mytable.customerID in (select min(customerID) from mytable group by email) There is at least one problem in your query. The in () statement is

Re: cfmail no longer working AND scheduled tasks arent being run

2008-09-16 Thread Rob Parkhill
What do the log files for the mail indicate. Usually they will give a reason as to why they are undeliverable. What authentication is the mail server using? I mean, when it hits your mail server what are the credentials supplied? Rob On Tue, Sep 16, 2008 at 7:44 AM, Torrent Girl <[EMAIL PROTECTE

SQL Help

2008-09-16 Thread Jeff F
I've got a table (MySQL) with about 20k records. I'd like to be able to get all fields from the table with distinct email addresses. Essentially, I'm weeding out records with duplicate email addresses. What I'm trying does not work: SELECT mytable.lastname, mytable.firstname, mytable.city, my

Custom Tag Paths

2008-09-16 Thread Adam Haskell
We are load testing one of our internal apps and seeing some odd errors. We defined a cutomtag path in the Application.cfc with 100,000 requests in just under an hour (these request call different pages but 80% use the custom tag, it's a portlet) we see 1-1.5% returning a customtag not found error.

Re: cf 7.0.2 freezes on install

2008-09-16 Thread Greg Morphis
I tried 3 different versions, they all did the same. I'll get with the LAN people tomorrow and see what's up. On Tue, Sep 16, 2008 at 3:47 AM, Azadi Saryev <[EMAIL PROTECTED]> wrote: > + make sure windows firewall (or any other firewall you may be using) is > turned off or at least not blocking p

CF, JQuery and IE

2008-09-16 Thread Scott Stewart
Hey all, i think I've got multiple issues going on here, but I'll try to explain this as best as I can... I. Using JQuery and cfdiv on the same page. I've got a page that loads content into a cfdiv, inside the loaded content is a call to the JQuery popupwindow plugin. Is the JQuery call negate

SQL Server 2005 permission problems

2008-09-16 Thread James Buckingham
Hi there, I'm trying to setup an exported 2000 server DB on my local SQL Server (2005 Express) and getting a permissions problem when I try and set things up in ColdFusion. The error I'm getting is: Connection verification failed for data source: myDB java.sql.SQLException: [Macromedia][SQLServ

Re: Using Google Maps API

2008-09-16 Thread Brian Swartzfager
Hi, Lawrence, Before you do anything else, I would suggest changing your into a regular (and launch the JavaScript function with a hyperlink or something) just to make sure that there isn't something about the way s are rendered that the Google API doesn't like. If you get the same error whe

Re: cfmail no longer working AND scheduled tasks arent being run

2008-09-16 Thread Torrent Girl
I logged in and check both The tasks are still there and the mail server settings are there. >i'd probably log into the cf admin and verify the mail server settings, as >well as take a look at the specific tasks that aren't running, to see how >they're configured (or if they're even still there)

Re: CF, Ajax and Autocomplete Problems

2008-09-16 Thread Dominic Watson
Perhaps the js code is wanting the response format to have an xml type header and/or dislikes whitespace at the top of the output. Try this: #theXML# You may also want to take a look at and http://betterautosuggest.riaforge.org for native ColdFusion/YUI solutions if things get messy with your cu

RE: CF, Ajax and Autocomplete Problems

2008-09-16 Thread Ian Vaughan
Hi I'm trying to incorporate an Ajax autosuggest feature into a Coldfusion search page I have. The example I have found is for PHP, and I'm trying to get this to work with Coldfusion The original autocomplete script and working example can be found athttp://www.brandspankingnew.net/archive/200

Using Google Maps API

2008-09-16 Thread Lawrence Mak
Hi, I was trying to use the Google Maps API in a template called from a border type cflayoutarea with no luck. The maps simply doesn't show up: http://maps.google.com/maps?file=api&v=2&key=x"; type="text/javascript"> load=function(lat,lng){

Re: CF8 cfc problem

2008-09-16 Thread Tom Chiverton
On Wednesday 10 Sep 2008, erik tom wrote: > this code get executed on CF7 , but display blank in cf8 Which bit is blank ? Does any but by itself run ? Do you have error squished by a setting in Application.cfc or the admin ? What happens if you turn robust exception information on, or set a brea

Re: cf 7.0.2 freezes on install

2008-09-16 Thread Azadi Saryev
+ make sure windows firewall (or any other firewall you may be using) is turned off or at least not blocking ports required by installation (there is a list of those somewhere on abode website... i prefer to just turn firewalls off). Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Brad Woo