Re: Random Records

Keen wrote: I need to run a query and return 10 random records. I used the following to get the records but can have the same random number returned more than once. I would like to insure that the 10 records returned are distinct. Any suggestions? TIA Why not just return 10 random

Re: Random Records

If you're using SQL Server, you can try: SELECT*, NewID() FROM tblWhatever ORDER BYNewID() -Nelson - Original Message - From: Keen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, November 03, 2001 8:28 PM Subject: Random Records I need to run a query

can CF do multiple DB connection?

hi... ppl... i will like to check with u..ppl can cold fusion link to multiple database at the same time..?? i noticed under application.cfm .. we normally put only 1 DSN connection. juz wonder.. is it possible to create multiple DSN connection..? and is it possible to do multiple database

Re: can CF do multiple DB connection?

It sounds like you are confused by why the application.cfm has the DSN connection defined -- the main reason is so that you don't have to define it on every page and can change it in one place if you need to change it for any reason. If you want to use more than one, simply define more than one

Re: locking within CFSCRIPT

At 10:30 PM 11/2/2001, you wrote: If serviceAvailable() requires the use of the external variable application.services I would say that it is a Bad Thing (TM) if you can invoke it like serviceAvailable('borkyService'). The UDF should be modified so it has to be invoked by sending all external

SOT: I owe ya! (Javascript Question)

Sorry for asking for free code.. But I've tried about 20 different ways of doing this, and I can't seem to get it right. 8/ I need to simply take the value of one field (string), and then prepend (and possible append) some info to it, and set a field on the same for to the concatenated value.

RE: Error processing CFFILE

Anyone ever seen this before while trying to upload with CFFile? The server admin seems to be having a hell of a time giving me a straight answer. Supposedly he is trying to set the proper permissions for the directory, but is frumping it up.

RE: I owe ya! (Javascript Question)

I need to simply take the value of one field (string), and then prepend (and possible append) some info to it, and set a field on the same for to the concatenated value. So basically.. function autoFills() { if( document.myForm.thisfield.value != '' ) { **set the value of

Re: locking within CFSCRIPT

I still disagree, why should my greater application have or want to know anything about how serviceAvailable() and related UDFs do the job they say they will ? Because that's the way it is. You have two choices -- adapt your thinking and implement it the way that it works currently, or

Re: can CF do multiple DB connection?

Can Access support cross-database joins? Will - Original Message - From: Darryl Lyons [EMAIL PROTECTED] Newsgroups: gradwell.lists.cftalk Sent: Sunday, November 04, 2001 8:23 PM Subject: RE: can CF do multiple DB connection? If your using db like SQL Server you can do cross database

RE: can CF do multiple DB connection?

Don't think so as you've generally got one datasource per access database.. I'm not really an Access-using person.. -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Monday, 5 November 2001 10:05 AM To: CF-Talk Subject: Re: can CF do multiple DB connection? Can Access

Re: can CF do multiple DB connection?

thank you ppl for yr fast reply.. :) ok... wat i need is to hav multiple DB connection in a query statement.. for example.. i need to hav a joint query from a oracle database and a ms sql database.. can i actually do this..? cfquery name =eg1 datasource=oracle.dsn, mssql.dsn . . /cfquery

RE: I owe ya! (Javascript Question)

Excellent! Thanks Dave... That was it. And I received basically the same thing from Stas too. Thanks to both of you. Was really simple, I know. But I'm not a JS person. ;) Take care... Lee -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Sunday,

Re: locking within CFSCRIPT

At 12:28 PM 11/5/2001, you wrote: I still disagree, why should my greater application have or want to know anything about how serviceAvailable() and related UDFs do the job they say they will ? When I first started CF I couldn't believe that I didn't have a way to call a function of my own

Re: can CF do multiple DB connection? (Access)

Yes, Access will support that. http://cfhub.com/forum/index.cfm?FuseAction=ThreadTopicID=1914Start=Last Datasource1=iether of your valid datasources t2 *the path to the second database *be sure to add the table name as SecondDBTable *SecondDbase is the

Re: Fw: commas in lists

At 01:06 AM 11/3/2001, you wrote: So, I say to him, if want to put commans in there, you have to quote the text. Ex: wide,very, deep,too easy,rugby OR 'wide','very, deep','too easy','rugby' Well, this didn't work. CF ignors the quotes and treats all commas it finds as delimiters Any ideas how

Currency Conversion

Hi all, I am building a site that will require currency conversion from $US to $AUD - prices on the site are in $USD but the cc payment gateway requires $AUD. I would rather get the current exchange rate on a daily or twice daily basis and then use the stored value rather than get a value

Random Letters?

Anyone have a quick way of generating a couple of random letters? Something basic? TTAIA Lee ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives:

Re: Random Letters?

Uppercase: Chr(Asc(A) + RandRange(0, 25)) Lowercase: Chr(Asc(a) + RandRange(0, 25)) Jim - Original Message - From: Lee Fuller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, November 04, 2001 9:33 PM Subject: Random Letters? Anyone have a quick way of generating a

RE: Random Letters?

Thanks Jim! Exactly what I needed. Lee -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 04, 2001 8:52 PM To: CF-Talk Subject: Re: Random Letters? Uppercase: Chr(Asc(A) + RandRange(0, 25)) Lowercase: Chr(Asc(a) +

RE: can CF do multiple DB connection?

ok... wat i need is to hav multiple DB connection in a query statement.. for example.. i need to hav a joint query from a oracle database and a ms sql database.. can i actually do this..? cfquery name =eg1 datasource=oracle.dsn, mssql.dsn . . /cfquery ?? or must it be query

Re: can CF do multiple DB connection?

cfquery name =eg1 datasource=oracle.dsn, mssql.dsn coming from the sql server end of things, look at the OPENROWSET OPENQUERY rowset functions though as other have indicated, you'll need just 1 dsn that has some sort of access to the other dsn you'll be talking to.