> >
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.
~~
Get the mailserver tha
> 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..?
>
>
> .
> .
>
>
> ?? or must it be query within a query?
>
>
> .
> .
>
> .
> .
>
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(As
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
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: http://www.ma
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 dynamic
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
Yes, Access will support that.
http://cfhub.com/forum/index.cfm?FuseAction=Thread&TopicID=1914&Start=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 fi
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 o
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,
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..?
.
.
??
or must it be
query within a query?
.
.
.
.
.
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 su
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 data
> 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 do
> 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 va
> > 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.
> >
> > //
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.
So
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 externa
If your using db like SQL Server you can do cross database joins by doing
this:
SELECT n.name
FROMDbname.dbo.tablename r, dbname2.dbo.tablename2 n
WHERE r.id = n.r_id AND
n.id = @id
Etc etc
Is that what you mean?
Darryl
-Original Message-
From:
Is their a way to insert a comma delimeted list of values into a
structure for an update of an existing structure, or will it always
create a new one? Example appreciated.
http://www.carnivorepc.com";>
~~
Structure your ColdFusion code with Fuse
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
v
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
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
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
24 matches
Mail list logo
