There's a common idea amongst database guys that NULLs are evil, but I
think that's mainly because they can screw up joins and introduce
three-valued logic into queries. For an example, if you have (say) a field
called nullfield that contains a NULL value -
nullfield 0
will return false.
Check your IIS Application Protection Level. On the properties of your
site in IIS, at the bottom of (I think) the Home Directory tab, there's a
dropdown box called Application Protection. By default, it's set to
Medium (Pooled), and that setting can cause 500 errors. It should always
be set to
CFPARAM NAME=session.Account DEFAULT=#StructNew()#
CFPARAM NAME=session.Account[LoggedIn] DEFAULT=no
Did you try escaping (doubling) the characters?
Doh! That works... thanks.
Aidan
--
Aidan Whitehall [EMAIL PROTECTED]
Macromedia ColdFusion Developer
Fairbanks Environmental +44
I do it in 2 stages; MSFILTER 2 will get rid of a lot of guff, but not
all, I then send it up to the server where I then run it thru a CF
custom tag I wrote which strips out everything (inc extraneous white
space) leaving some style text and most of the body text, (file is then
CFINCLUDEed in
Haven't tried it, but what if you simply write the content to myfile.xls
with cffile and then cflocation to it?
zap005 wrote:
Hi There,
My hosting provider does not allow cfcontent or COM objects.
I need a way to insert the excel document type into the header of a document
without
whoops...I meant myfile.csv, which excel should open as the default
application.
Richard Meredith-Hardy wrote:
Haven't tried it, but what if you simply write the content to myfile.xls
with cffile and then cflocation to it?
zap005 wrote:
Hi There,
My hosting provider does not allow
.biz domains are global, so when you've got a name you've got it
worldwide, whereas .com, .co.nz, .com.au, .co.uk etc aren't.
com is supposed to be global. Isn't it?
Nick
**
Information in this email is confidential and may
We got round this by making it into a two stage process, asking the user to
download the file rather than squirting it straight to them:
!--- create file and output field headings ---
cffile action=write
file=#path#RegisteredUsers.xls output=Name
Title Email Date_Added
!--- append query
Also - as far as your syntax, you try to do cfif request = cat which is
incorrect. Regardless of how you build your query you would have to do cfif
request EQ Cat the = is used for assignment and that is why your code
is blowing up. But, I would also do what Steven suggests. Much cleaner...
Mike
For what it is worth, this list is an amazing resource. Keep up the good
work MD!
I was going to say that the benefit that I have received from this list is
more than most courses I have taken and certainly more than any magazine I
have purchased (except maybe a lasting subscription). My
I thought I replied to this before, but I guess it got lost... I do not
secure my datasources on the code level as would be the case of
specifying usernam/password in cfquery. I either create a db user with
rights only for that application or I create application roles (sql
server). I also only
For what it is worth, this list is an amazing resource. Keep up the good
work MD!
I was going to say that the benefit that I have received from this list is
more than most courses I have taken and certainly more than any magazine I
have purchased (except maybe a lasting subscription). My
Read this:
http://www.allaire.com/Handlers/index.cfm?ID=20370Method=Full
and this:
http://www.allaire.com/handlers/index.cfm?ID=17196Method=FullTitle=Locking
%20in%20ColdFusionCache=False
That ought to do it for you.
Cheers,
--Matt--
- Original Message -
From: Gonzo Rock [EMAIL
Ray - Check your max timeout in cf admin - I would bet that's your
problem. You can't set a session timeout in your cfapplication that is
greater than your max timeout in cf admin. If you want your sessions to
timeout at 3 hours, make sure your max timeout is = 3 hours
Mark
-Original
Kelly - I've used the image datatype before (sql server) and I've since
reverted back to just storing images on disk and entering the path in
the db. We stored the images as blobs - there are two custom tags out
there cfx_putimage and cfx_getimage that do this for you. Someone above
me stated
I've been tempted to do this and have stopped because I've been told it's
not a good practice. I suppose it's inefficient to do all that extra DB
work when you can just store a path to the image. I'd like to hear any
opinions on just why this is a bad practice. Any thoughts?
Thanks,
Same here. We use activepdf to convert images to pdf's on the fly and it
works just fine.
Mark
-Original Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 09, 2001 4:08 AM
To: CF-Talk
Subject: RE: CF output as PDF
Sharon, try ActivePDF
Anyone want to write a FAQ on this - it seems to come up every few weeks
(you could try looking at the archives...)
-Original Message-
From: Carlisle, Eric [mailto:[EMAIL PROTECTED]]
Sent: 10 September 2001 13:56
To: CF-Talk
Subject: RE: Question about SQL and the IMAGE datatype
I've
Sounds like a good timesaver. Thanks :)
EC
-Original Message-
From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 9:01 AM
To: CF-Talk
Subject: RE: Question about SQL and the IMAGE datatype
Anyone want to write a FAQ on this - it seems to
I am pulling from an oracle database and need to do a lookup on the sql
server. How can I do this been working on this one all weekend please help.
SELECT PROBLEM_ID, SEVERITY, USER_ID, PROBLEM_CODE, SYSTEM,
CLOSE_DATE, CLOSE_TIME, FIRST_LOCATION_ID, FIRST_CONTACT_ID,
LOCATION_ID, CALLER_ID,
I sometimes have to do HTML versions of docs I recieve in PDF format
and being dumb lil me I do this manually copying text and all
Anyone know a faster way? A tag perhaps?
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ:
Anyone want to write a FAQ on this - it seems to come up
every few weeks
I'm going to add it.
Aidan
--
Aidan Whitehall [EMAIL PROTECTED]
Macromedia ColdFusion Developer
Fairbanks Environmental +44 (0)1695 51775
~~
Your ad could be here.
Does anybody have a phone number for Robert at ATSWebnet? My site's been
down for a week and he isn't answering my e-mails.
Thanks!
~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
it was very easy. it's simply an ODBC database to CF.
one thing to watch for, PostGres doesn't support UPDATE statements with
an extra-table WHERE clause. a small thing, but it stuck me for almost
a day before i figured it out.
christopher olive, cio
cresco technologies, inc
Hmm he usually answers all his emails rather
quickly.
Not sure. Never had his # but not have a problem
before with ATSwebnet
-Original Message-
From: stas [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 10:18 AM
To: CF-Talk
Subject: ATSwebnet
Does anybody have a phone
stas wrote:
Does anybody have a phone number for Robert at ATSWebnet? My site's been
down for a week and he isn't answering my e-mails.
I don't. But phone and fax numbers of ATSWebnet are readily available
WHOIS atsnetweb.com
Domain Name.. atswebnet.com
Creation Date
Hi,
Our site was down all last week also.
There seemed to be registry situation on the server we were on.
He was able to fix it by the end of the week. Our site appears to be
working again. I haven't heard from him since last Wednesday. Phone for
Robert: 678-416-0048.
John
- Original
I have Imail 6 running on a server, and want to switch to an External Access
database for user registration.
I actually want to add fields to this database that I would write to using
CF and hten pass the standard paramaters to the Imail CGI script using
CFHTTPPARAM and CFHTTP.
However, I can't
Hello Everyone,
I have a strange situation with CFGrid that neither my ColdFusion admin nor
the network admin can solve. I'm hoping someone here may have encountered
something similar. My apologies for the length of my question.
Before:
Using cfgrid did not cause any problems, all users could
Jeffry,
Thanks. The idea was to create Next Record and Previous Record buttons
on my page. Perhaps it would be simpler to find the next alphabetical
element, but I just couldn't see it.
I was thinking was that, if my current record's index was 5, I could get
the next record by simply adding 1
select *
from sysobjects
where type = 'u'
order by name
Mark Stewart [EMAIL PROTECTED] on 09/06/2001 02:23:36 PM
Please respond to [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
cc:
Subject: RE: cfquery Question
There is a SqL Server stored procedure that will describe a database for
Odd, my site has been up non-stop for about a year. He usually replies
almost immediately. Try one of these numbers.
-Gary
[whois.crsnic.net]Whois Server Version 1.3Domain names in the .com, .net,
and .org domains can now be registered
with many different competing registrars. Go to
Not sure if I'm remembering this right but
If you specify the first row of your table with TH cells, then I think the
table header get's printed on each page. Could be wrong though.
You'd probably have to move to Crystal Reports, or something similar to get
full reporting capabilities.
Our September meeting is tomorrow night! A ColdFusion author will be
speaking! Here's the details!
First off, Don Huffman will be doing a short presentation on two
brand-spanking new tags to ColdFusion: CFFlush and CFDump. CFFlush is
great for increasing virtual response time (the response
Ok I am hoping to make this clear.
I have a page that uses 2 tables for display. This table is set in an index
page, not on the actual display page.
The one column lists all the options (which homeroom student to change
grades for) and the 2nd one shows the grades that can be changed. It works
I'm taking a Java course currently; the teacher stated that
Java has something like 80% of the server programming market
at present. If this is true, MS is going to have a very tough
time penetrating the Java's inroads.
There are lies, damn lies, and statistics. I kind of doubt that 80%
Yes, but outside the USA that's not how it's seen. Of course any URL can be
accessed by any browser anywhere, but for marketing purposes it's different.
My own domain is a .COM domain, but I often get people here in Australia
complaining because they can't send to me. They keep adding .au to my
I know the answer to my problem is easy I just can't seem to get my brain
functioning today.
My problem is that I want to get the number of times an integer ID appears
in a list of columns for every row in a table. The integer ID is from an
outer SQL statement that I am looping through.
An
The dupes that everyone got were due to a clog in the mail directory. I
know that sounds strange, but some messages were being processed but not
deleted for whatever reason and it just went on and on for up to 5 copies.
I've since fixed it all.
At 02:14 PM 9/7/01, you wrote:
I figure Michael
Thanks Randy. Do you use his SQL server? I haven't been able to connect to
it as well.
- Original Message -
From: Adkins, Randy [EMAIL PROTECTED]
Hmm he usually answers all his emails rather
quickly.
Not sure. Never had his # but not have a problem
before with ATSwebnet
Having worked for Allaire-Macromedia I can give my relatively professional
opinion and state that this list is the best. We are very lucky to have it
and we should NEVER overlook the fact that a very dedicated person runs it
and that ColdFusion luminaries give very $valuable$ advice and specific
Has anyone sucessfully used Microsoft's SCC API to intgrate QUME Version
Control System (QVCS) with ColdFusion Studio?
Kind Regards, Mike Brunt
Sempra Energy
213.244.5226
Brunt, Michael.vcf
~~
Structure your ColdFusion code with Fusebox. Get
Does anybody know a way to get the originating domain the user is accessing
your site from?
Thanks,
Rick
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives:
Here is his number. 678-416-0048.
Regards,
Gary McNeel, Jr.
Executive Director - DAC-Net
Rice University
713-348-6266
Visit us at: http://dacnet.rice.edu/
-Original Message-
From: stas [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 9:18 AM
To: CF-Talk
Subject:
Hey can someone tell me the command that will allow me to print out more
then one form of the activepdf. My query-tested separately- shows all 40
chosen people that I want to print info for-1 or2 pags per person. However,
when I do the activepdf it shows only the 1st person.
1. What command
I suppose, though, it may be like a lot of other systems where technology
places a great deal of power
into the hands of the user... it depends a lot upon how that user makes
use
of the technology.
That's pretty rude pal! Get off the list if you don't like it you
ingrateful wretch! Why don't
I know Frank uses PostGres extensively and posts all his findings on his
website. (Hi Frank!)
http://FrankHilliard.com
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Are variables passed by reference or by value in CF UDFs?
Thanks,
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives:
Simply have Imail build the database for you (you specify an existing
datasource). You can then add as many extra fields as you like.
The actual fields required are:
USERID PASSWORD FULLNAME USERDIR MAILADDR MAXSIZE MAXMSGS FLAGS TYPE
root password System Administrator
Have you tried this doc?
http://www.allaire.com/handlers/index.cfm?ID=17318Method=Full
best,
Chris Norloff
-- Original Message --
from: Gonzo Rock [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
date: Wed, 05 Sep 2001 09:45:21 -0700
A couple of questions
One of my colleagues is building that as we speak. He's a .Net fanatic and
also loves Cold Fusion, so he wants the best of both worlds.
I'm not sure of the details of his implementation, but I'll certainly post a
note to the list when this happens.
-Original Message-
From: Dick
At 10:02 AM 09/10/2001 -0500, you wrote:
Jeffry,
Thanks. The idea was to create Next Record and Previous Record buttons
on my page. Perhaps it would be simpler to find the next alphabetical
element, but I just couldn't see it.
You could run the query once, and either cache it or load the whole
I know when I turned on NT Challenge/response security in the
/cfide/administrator part of my site that cfgrid did not work. Do you think
perhaps that security was turned on on that directory and not all users have
access?
By the way, there is no IE 4.72. I recon you mean Netscape?
Let's get this list back on track. Messages shouldn't be receieved more
that 1 hour after they're sent. They shouldn't be received more than once.
Beyond that, there are no excuses.
I'm not convinced that a Cold Fusion driven mail server makes any sense at
all. Perhaps this list is a good
Simple variables are passed by value. Complex variables (query, structure,
array) are passed by reference. I think that object variables are also
passed by reference.
At 01:24 PM 9/10/01, you wrote:
Are variables passed by reference or by value in CF UDFs?
Thanks,
If the var is simple or array, then it is by value. If you pass in a
struct or a query, then it is by ref.
===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
Email: [EMAIL PROTECTED]
Yahoo IM :
There is an easier way of doing this. You cache the query and modify your
startrow attribute in your cfquery tag.
There's also a custom tag in the developer gallery I believe.
-Deanna
Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]
Imail will automatically make the database up for you once you set up a
database, and ODBC driver. All you have to do is point imail to it and it
creates it for you.
Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire
-Original Message-
From: Angel Stewart [mailto:[EMAIL
Are variables passed by reference or by value in CF UDFs?
Queries, structures, and variables created using CFOBJECT are passed by
reference. Other variables are passed by value. This is true whether passing
them to UDFs or custom tags or whatever, as far as I can tell.
Dave Watts, CTO, Fig
I know we have discussed this a good bit lately but I am still needing some
understanding. In my application, I make MANY session variables. I use these
variables to check certain things on many pages. Because of the past threads on
this I have surrounded them with CFLOCK tags. NowCan
I appreciate everyone's kind words on this as well as the criticism. I will
be the first to admit the following:
Programming is the art of trial and error. Even when you write something
beautiful you still have to debug it, deal with events that you did not
take into account and more.
For
One possible way, which works for IE (I love Intranet development),
you will need this style element
style type=text/css
!--
break {page-break-after: always}
--
/style
determine how many rows you can fit on the page: RowsPerPage
use something as a count of how many rows you have output:
My only thought on this is that some people already have the Applet-cab
files locally and other's have not and those who don't have them can't get
them because of the proxy server which may be acting as some sort of
firewall for java Applets. The SSL should not make any difference, I assume
you
I was wrong in saying that an array was passed by reference. I just tested
it out and it is passed by value. I was assuming based on the normal array
function results that it would be. I hate when things are not 'standard'.
Causes an error
CFSCRIPT
function test(aVar)
{
While I can understand this in a UDF, I just can't understand why this is
true for a custom tag. I just tried it out and an array is passed by value
to a custom tag. A structure is passed by reference. This totally breaks
the paradigm of custom tags being totally independent processes.
At
hi again,
does anyone have any idea ?
On 9/5/01 2:32:53 PM
[EMAIL PROTECTED]
wrote:
hi everybody,
I need help to modify CF_TwoSelectRelated.
does anyone has ever modify CF_TwoSelectsRelated so it can take
preselected values, like the assigning values to default1/default2
parameters in
They are passed by value. You can see this from this simple code:
===
cfscript
function AddOne(n)
{
return n+1;
}
/cfscript
cfset num=1
cfoutputn+1=#AddOne(num)#br
num=#num#/cfoutput
===
HTH,
Is there anyone out there using CF and a Progress database. What drivers
have you found to perform best, and how has the combination handled under
load?
Any other tips/tricks you can share is much appreciated!
Kevin
~~
Structure your
Hey folks, just a quick question.
I'm working on an application and just noticed a difference between the help
file on my computer (Studio 4.01) and my co-worker's machine (Studio 4.5)
regarding the CFLock tag.
Basically, what are the differences between the two releases. I didn't get
a chance
I'm going to assume you are using NT4 or Win2k on the server end. In IIS,
create a virtual directory that is mapped to the CFIDE directory. This
should fix the problem of users not getting the apps to load.
Dan Phillips
CFXHosting.com
-Original Message-
From: Harper, Laura
Where can I get more info on Imail please?
At 03:17 PM 10/09/01 -0400, you wrote:
Imail will automatically make the database up for you once you set up a
database, and ODBC driver. All you have to do is point imail to it and it
creates it for you.
Robert Everland III
Dixon Ticonderoga
Web
What about using UNION?
select count(*) from
(
SELECT * as Total FROM Cycles WHERE BrandNameID1_1=#LoopIndex#)
union
SELECT * as Total FROM Cycles WHERE BrandNameID2_1=#LoopIndex#)
union
.
.
.
Steve
-
Steven Monaghan
Oracle DBA
MSC Industrial Direct Co.,
What version of ColdFusion are you running, Brian? The SCOPE attribute of
the CFLOCK tag was not introduced until (group, correct me if I'm wrong
here) ColdFusion version 4.5. If you're running a version earlier than
this, you'll need to use named locks instead of scoped locks.
You can find
Thanks, Micheal.
I appreciate taking the time to do the fieldwork :).
EC
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 3:35 PM
To: CF-Talk
Subject: RE: Passing variables in UDF
I was wrong in saying that an array was
Couldn't have said it any better Mike... You've got our support.
Lee Fuller
Chief Technical Officer
PrimeDNA Corporation / AAA Web Hosting Corporation
We ARE the net.
http://www.aaawebhosting.com
-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
Sent: Monday,
I just got CF 5. Does anyone know if the verity search engine in it can be
configured to search PDF documents via text search?
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe:
Makes sense though, as an array is basically a structure. And structures
are passed by reference.
Btw, Just wanted to add my two cents and say thanks for the list. Great
resource.
Shawn Grover
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday,
Are these two the same? If not, what is the difference between them?
Brian Yager
President - North AL Cold Fusion Users Group
Sr. Systems Analyst
NCCIM/CIC
[EMAIL PROTECTED]
(256) 842-8342
~~
Get the mailserver that powers this list at
I'm trying to call custom tags via a cfmodule tag. The tag is
cf_htmlhead. I need to emulate the end tag /cf_htmlhead.
/cfmodule doesn't seem to trigger the executionmode variable inside
the tag. Any suggestions.
~~
Your ad could be here.
#CGI.SERVER_NAME#
that is the host header if that helps at all.
Trishan Singh
ACP/CCFD
[EMAIL PROTECTED]
316-204-1097
Paracom Technologies
Wichita KS
- Original Message -
From: Rick Lamb [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, September 10, 2001 10:52 AM
Straight from the online documentation:
--
Passing arguments
ColdFusion passes arrays and simple data types including integers, strings,
and time and date values into the function by value. It passes queries and
structures into the function by reference. As a result, if
Here's a new CF Resource site - www.cfugorama.com
We built it using a ColdFusion based content management solution called
COMMONSPOT.
I believe that for many firms, CommonSpot finally delivers on the
promise of cost-effective content management. It's template-based
approach, 30+ built-in
http://www.ipswitch.com/
They also have a very active mailing list which you can sign up for on
the site.
jon
Brook Davies wrote:
Where can I get more info on Imail please?
At 03:17 PM 10/09/01 -0400, you wrote:
Imail will automatically make the database up for you once you set up a
Coming into this a bit late (I'm still catching up on my list reading)...
There was an excellent article on how to do this in a recent issue of
ColdFusion Developer's Journal (http://www.sys-con.com/coldfusion/). Look
for the article Harnessing The Power Of HTML E-Mails by Kelly Brown in
the
I was wrong in saying that an array was passed by reference.
I just tested it out and it is passed by value. I was assuming
based on the normal array function results that it would be. I
hate when things are not 'standard'.
I'm not sure I understand what you mean by this (that is, based
Someone correct me if I'm wrong but I believe the best way to copy is
to use the duplicate function. I believe the difference is there's
sometimes a problem when you have nested structures and those nested
structures don't get copied or may be corrupted when you use
structcopy(). I'm not sure if
Lets look at the difference between a function that works on variables vs.
one that works on an array.
ucase(attribute) returns the attribute after it has been made all uppercase.
ArrayResize(array, minimum_size) - this will resize the array that you pass
to it. The array is NOT returned as a
Out of curiosity do you know which email program is doing this?
jon
Michael Dinowitz wrote:
I appreciate everyone's kind words on this as well as the criticism. I will
be the first to admit the following:
Programming is the art of trial and error. Even when you write something
beautiful you
Are these two the same? If not, what is the difference between
them?
StructCopy was introduced to the language before Duplicate. I suspect that
there's very little need for StructCopy anymore, really.
StructCopy creates a separate copy of a structure (passing it by value
instead of by
I'm trying to call custom tags via a cfmodule tag. The tag is
cf_htmlhead. I need to emulate the end tag /cf_htmlhead.
/cfmodule doesn't seem to trigger the executionmode variable
inside the tag. Any suggestions.
Using CFMODULE with a closing CFMODULE tag has always executed the custom
Hi,
Has anyone had any problems setting up CF5 and Spectra 1.0.1?
I installed CF5 and Spectra 1.0.1 and noticed that no userDirectory
or security cointext was created in CF advanced security. I have installed
CF4.5 and Spectra 1.0.1 in the past, the userDirectory and security context
been
Hi,
Same here. I have each message at least 2 or 3 times.
Thanks
-Brent
-Original Message-
From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 06, 2001 9:51 PM
To: CF-Talk
Subject: NSOT: Att Master Dinowitz
Michael, are we all receiving copies of messages
Just bought the Mastering book on Friday, and now I'm addicted to CF; I'm a
true convert from vbs.
Anyhow, I'm not clear on what to expect back from the system on this, or how
to handle it. I've also searched several of the sites, but frankly I'm not
sure what to look for so I don't know if
Can anyone offer any comments on a standard developers desktop when
developing for a MS CF site?
In W2K, do you use IIS with CF server loaded locally or on a Network?
What type of Source Control do you use?
What tool is best when developing cfx_Tags?
How about using MTS??
.
.
.
.
Thanks,
I have a possible client whom will have nearly 5k registered users and would
like to send out mass emails to these users. My current hosts has a limit
of 2K emails. Can anyone recommend a solution or a company that would
perhaps allow me to run a query off my database and send an email off
hi,
did anyone knows any resources or articles on how to package a CF
application?
~~
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:
My development strategy on Win2k is CFStudio with a single user version of
CFServer locally. Depending on the Win2k version either IIS or Personal Web
Server, locally. Then a QA Staging box (or boxes if you're rich) in the same
environment as production and as near to production as possible in
Try to reverse the problem: run the query in MS SQL and select from Oracle.
Create a linked server in MS SQL to point to the Oracle DB.( See MSSQL BOL
for details on how to do this)
You must install the Oracle client( Net8 or SQL*Net ) on the SQL Server
machine for this to work.
Then run a query
Hmm, we don't use Win2k, but for what it's worth, this is our setup
Our development server is an NT4 server, running CF4.5, IIS and SQL Server
etc.
However we use jEdit running under Linux on our dev workstations. While
this has proved to be more stable, cost effective and reliable for
iMS-SE can send many more times that. It is completely integrated with
CF and can use CFMAIL, a CFX tag (included) or COM object (also
included) to send mail directly from hundreds of applications including
SQL Server. With iMS-SE you don't need to have a separate mail server
for sending
1 - 100 of 102 matches
Mail list logo