I am moving a site from an Access DB to SQL Server 7.0 and have run into a
function that was being used that is not supported in SQL Server 7.0 The
function is: InStr([start, ]string1, string2[, compare]) Is there a new
name for this function in SQL Server?
--Aaron
Hi all. If I send an e-mail with an attachment to multiple recipients
via query results, will the attachment be sent once, as in actually
using up bandwidth to go from server to internet, or once for every
recipient? How about if I send it with the recipients CC'd?
Thanks
Bud Schneehagen -
Thanks, it works now :)
The thing that was causing my errors was the fact I was calling my
formfields by numbers ie 1,2,3,4 etc
It was throwing an error when trying to evaluate it, didn't realise calling
then numbers would cause a problem.
Thanks again
Brian
- Original Message -
From: "Computer Simplistics Suppoer" [EMAIL PROTECTED]
Can someone explain the term "deprecated". I see it come up in Studio every
once in a while and I am guessing that it means the function I am using is
no longer in use, but what is the technical explanation of it?
Basically, it is a
Hi,
Can Cold Fusion easily connect to an NNTP server, to perform general tasks
such as reading and searching?
Thanks,
Will
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
- Original Message -
From: WL [EMAIL PROTECTED]
Sent: 30 April 2000 13:06
Hi,
Can Cold Fusion easily connect to an NNTP server, to perform general tasks
such as reading and searching?
I wouldn't say "easily" as such. NNTP is a protocol, and what would be required
would be a custom
- Original Message -
From: "Adrian Cooper" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, April 30, 2000 1:15 PM
Subject: Re: NNTP and Cold Fusion
- Original Message -
From: WL [EMAIL PROTECTED]
Sent: 30 April 2000 13:06
Hi,
Can Cold Fusion easily connect to an
I believe Fuseware have such a beast, goes by the name of CFX_NNTP
- Original Message -
From: "Adrian Cooper" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, April 30, 2000 1:15 PM
Subject: Re: NNTP and Cold Fusion
- Original Message -
From: WL [EMAIL PROTECTED]
Sent:
Hy!
There's a problem in CF Server 4.x. If you run more then 5 cfhttp tags
simultaneous, then will CF crash (Allaire knows about this bug). Because
cfhttp is very important to us I was wondering if there is a timeout
option I can add to cfhttp tag. Is there?
OK, here's another solution to my
- Original Message -
From: WL [EMAIL PROTECTED]
Sent: 30 April 2000 13:23
I thought as much. The same was/is said with PHP - but I think CF would do
a really good job, probably better. I did a search on allaire.com and found
only ~one~ which was pretty limited (it posted a msg to
You could use the IN() function
WHERE FIELDNAME IN (LIST)
ex:
WHERE myID IN (1,2,3,4,5,6,7)
Duane Boudreau
CFExperts.Com
-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 30, 2000 4:10 AM
To: CF-Talk
Subject: Access function in SQL Server
I am
Try CHARINDEX
- Original Message -
From: "Aaron Rouse" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Sunday, April 30, 2000 2:09 AM
Subject: Access function in SQL Server
I am moving a site from an Access DB to SQL Server 7.0 and have run into a
function that was being
As WBB noted, for NT errors drop into a command box and type:
net helpmsg errornumber [enter]
On Fri, 28 Apr 2000 "Ron Anderson" [EMAIL PROTECTED] writes:
Anyone know what causes this error and how to get rid of it?
Windows NT error number 1060 occurred.
Error Diagnostic Information
An
- Original Message -
From: "Adrian Cooper" [EMAIL PROTECTED]
Newsgroups: cf-talk
Sent: Sunday, April 30, 2000 2:41 PM
Subject: Re: NNTP and Cold Fusion
There are already a few proprietory Web based frontends for NNTP/Usenet,
including that made by the makers of "D-News" - the best NNTP
- Original Message -
From: WL [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, April 30, 2000 1:01 PM
Subject: Re: NNTP and Cold Fusion
But I agree - a CF approach to NNTP has alot of potential, and it would
be
particuarly useful to be able to store selected Usenet groups and
- Original Message -
From: WL [EMAIL PROTECTED]
Sent: 30 April 2000 18:01
http://www.netwinsite.com/
That looks very good.
They are - I can tell you that from experience.
It really would - imagine the power. The problem is getting it *in*to SQL
Server - once it's in,
From: WL [EMAIL PROTECTED]
Hi,
Can Cold Fusion easily connect to an NNTP server, to perform general tasks
such as reading and searching?
You could use Lewis Sellers' CFX_TCPClient at
http://www.intrafoundation.com/freeware.html
Pan
Hubert,
if you are using MS-Sql server "text" is a datatype, so you might run into
problems there
and your code
cfquery Name="Select_vals" Datasource="Jokes"
Select JokeTitle from Jokes_Table (dont use text for a table name, its a
keyword)
/cfquery
Select Name="S_Options"
cfoutput
Thanks I reached the same conclusion
- Original Message -
From: "Howie Hamlin" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 28, 2000 7:45 PM
Subject: Re: Integrating coldfusion with MS word
The application that opens is determined by the MIME type setings on your
PC
(if
I believe there is a timeout attribute CFHTTP timeout="number of seconds"
There are also several CFX_HTTP tags in allaire's tag gallery that claim to
fix problems that the native CFHTTP call has.
___
Pete Freitag
CFDEV.COM
Cold Fusion Developer
HI all,
I got a strange problem and am wondering if anyone has slain this beast before.
I can't minimize my Studio window on my desktop. I click the _ and the window flashes
quickly, but stays on the desktop. Sometimes it will go behind other windows,
sometimes not. Any standard method of
I'm having trouble and I was hoping someone can help me.
Senario: I have a page that I'm trying to extract pieces from. To mark the
section I'm trying to edit, I've place !-- snip -- and !-- /snip --
around the section. Next, I'm opening the file (CFFILE) and doing a regular
expression to find
Hey All,
I have come across this weird problem. I was trying to use cfexecute to
run some server side scripts, but I can never get it to work.
Here is a test I did
(I am running under Solaris 2.6 CF4.5)
cfexecute name="touch" arguments="/tmp/cftestfile" timeOut="30"
/cfexecute
This
Max Paperno wrote:
HI all,
I got a strange problem and am wondering if anyone has slain this beast before.
I can't minimize my Studio window on my desktop. I click the _ and the window
flashes quickly, but stays on the desktop. Sometimes it will go behind other
windows, sometimes
I have a Matrox G400 also, and I'm willing to bet money the problem is with
your display settings, not with Studio. I have not had your problem
specifically, but I've had other weird problems with applications not
minimizing correctly, or maximizing then disappearing from the screen
completely.
- Original Message -
From: "Adrian Cooper" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, April 30, 2000 7:46 PM
Subject: Re: NNTP and Cold Fusion
Problem is that a current full NNTP news feed requires about 8Mbs of
dedicated
bandwidth, and to archive for anything like a
Sorry if this is a lame question. I'm not very strong in SQL yet and am having a brain
freeze on how
to do this.
I have table A where I pull one record. In this one record are name ID's that
correspond to table B
where the name ID's are associated with full name, email, phone, etc.
How do I
You have to do a join on the tables...something like:
select * from tablea left join tableb on tabea.id=tableb.id where ...
That's the general idea. There are several join types (dependent on your
database platform) and you would also not usually use a wildcard (*) but
instead use the field
I found a section of AOL.COM that is driven by CF. This section is linked
from almost every page on AOL.COM ("webmaster info", on the bottom
navigation)./
Interesting because AOL = Netscape = Livewire = CF competition
http://webmaster.info.aol.com
PS- This section suffers from the SQL Server
I vaguley remember a custom tag that retrieved the headlines from the
SlashDot site, I can't find it on the gallery and can't seem to find it
anywhere. Can anyone refresh my memory and point me in the right direction
please?
Thanks
Brian
At 4/30/2000 01:24 PM -0700, Josh Black wrote:
I have a Matrox G400 also, and I'm willing to bet money the problem is with
your display settings, not with Studio.
Yep, I think you're right. I switched to older Matrox drivers and now when I disable
the "prevent display spanning" feature the
Old News.
- Original Message -
From: "Philip J. Kaplan" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, April 30, 2000 3:48 PM
Subject: AOL uses CF!
I found a section of AOL.COM that is driven by CF. This section is linked
from almost every page on AOL.COM ("webmaster info",
Didn't your mother teach you any Manners? Postings another sites
vulnerability to a list of people you don't know? hmm..did you email the
webmaster at AOL, that would have been a better idea. Do you have a
website? What's the url? Can I look for hacks and post the results to a
list your not a
Yes. Style sheets.
At 09:10 AM 25/04/00 -0700, you wrote:
Is it possible in CF to remove the underline from a
link?
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
This is a multi-part message in MIME format.
--=_NextPart_000_000B_01BE93C0.DB208CE0
Content-Type: text/plain;
charset="windows-1257"
Content-Transfer-Encoding: quoted-printable
a couple of quick questions
locally when I test it the results are fine when I upload it to the =
server
Jeffrey,
Thanks. I'm just starting to check out this tool.
-David
On Wed, 26 Apr 2000 8:51:46 -0400 "Jeffrey G. Brown"
[EMAIL PROTECTED] writes:
You may find the Backwards Compatibility Viewer
http://www.delorie.com/web/wpbcv.html useful in this regard.
JGB
=== original message ===
= and = are not the proper syntax for a cfif statement
check page 96 of the ColdFusion "Developing Web Applications with ColdFusion
(manual that came with program)
= is represented by IS
= is represented by GREATER THAN OR EQUAL TOor GTE, GE
See other examples on page 96
Good luck
Gary
On 4/30/00, Chris Giminez penned:
Sorry if this is a lame question. I'm not very strong in SQL yet and
am having a brain freeze on how
to do this.
I have table A where I pull one record. In this one record are name
ID's that correspond to table B
where the name ID's are associated with full
thanks for the reply, but that's not what I am trying to do. The only way I can think
to accomplish
this is to use multiple - separate queries. If someone can show me how to improve
this, I'd
appreciate it.
Let me give you an example:
Say I run a query for a real estate listing (this isn't
Wouldn't it be:
CFQUERY Datasource="MyDataSource" Name="MyName"
SELECT TableA.NameID, TableB.NameID, TableA.Data, TableB.Data
FROM TableA, TableB
WHERE TableA.NameID = TableB.NameID
/CFQUERY
That will get the info from the table with matchin NameIDs.
Then:
CFOUTPUT Query="MyName"
SELECT Agent_Id, Name, LName, Email
FROM Agents
WHERE Agent_ID IN (Select * From Listings Where WHERE Listing.Id =
#url.id#)
- Original Message -
From: "Chris Giminez" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, April 30, 2000 8:56 PM
Subject: Re: tying
Chris,
Usually, you'd want to create a third table to contain the relationships
associating the listings table with the agents table (a many to many
relationship). This table might only need two columns - listingid and agentid.
Then just add a record for each agent that shows a property. You
style type="text/css"
!--
A{text-decoration:none}
--
/style
in the head
At 09:24 AM 01/05/00 +1000, you wrote:
Yes. Style sheets.
At 09:10 AM 25/04/00 -0700, you wrote:
Is it possible in CF to remove the underline from a
link?
As a community that promotes the use of CF as a scaleable, viable solution
for web applications, we should all hail Brook for making an excellent
point. Drawing attention to CF vulnerable sites is only killing our plight.
- Original Message -
From: "Brook Davies" [EMAIL PROTECTED]
To:
Hello:
The list box on my search screen won't work. First, it lists ALL
counties (e.g., if "Ventura" is listed in 20 records then "Ventura" is
listed 20 times in the list box). Second, selecting a county returns a
result of ALL counties (e.g., if I select "Ventura" then BOTH "Ventura"
and "Los
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello, list!
Fusion Trio Inc (F3I) has begun an Open Source initiative that I
think you guys and girls might be interested in. It's called
"FuseObjects", and it is an Open Source API definition that allows
developers to do one of two things: To
Try SELECT DISTINCT
- Original Message -
From: "LH Rothman" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, April 30, 2000 10:08 PM
Subject: List Box Search Question
Hello:
The list box on my search screen won't work. First, it lists ALL
counties (e.g., if "Ventura" is
On 4/30/00, Chris Giminez penned:
Let me give you an example:
Say I run a query for a real estate listing (this isn't what I'm
doing, but it correlates well)
CFQUERY NAME="property_detail" DATASOURCE="properties"
SELECT *
FROM Listing
WHERE (Listing.Id = '#url.id#')
/CFQUERY
It's described somewhere on defusion.com.
-Original Message-
From: Brian Mitter [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 30, 2000 5:56 PM
To: [EMAIL PROTECTED]
Subject: SlashDot NewsTag?
I vaguley remember a custom tag that retrieved the headlines from the
SlashDot site, I can't
On 4/30/00, Bud penned:
CFQUERY NAME="property_detail" DATASOURCE="properties"
SELECT *
FROM Listing
WHERE (Listing.Id = '#url.id#')
/CFQUERY
Now, lets say this returns the address, city, zip, price, etc along
with 5 ID's of agents that have
shown this particular
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
We've also release "RSS2CF" which can pull RSS-format feeds from a
number of sites, including Slashdot.
http://www.fusiontrio.com/rss2cf/
Good luck,
Dustin
-Original Message-
From: stas [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April
As a community that promotes the use of CF as a scaleable, viable solution
for web applications, we should all hail Brook for making an excellent
point. Drawing attention to CF vulnerable sites is only killing our plight.
I can't say I agree wholeheartedly with this statement. The sooner these
Hi!
The list box on my search screen doesn't work. Regardless of the county
I select, it displays ALL counties. Can someone please take a look at
my query and option value stuff? (BTW - other search items work fine.)
Thank you!
-L
CFQUERY DATASOURCE="A2Z" NAME="GetCounty"
SELECT DISTINCT
Hi all,
I'm writing a fusebox-app and I've put the cfapplication-tag
(sessionmanagement="yes") in the app_globals.cfm in the root. But now the
app
cannot handle session-variables and returns an error. When I copy the
cfapplication-tag to an application.cfm-template it does work.
Initially I
I have a client who's proposing to use CF with an access database under th
ecircumstances listed below, and I'd like the views of this list as to
whether you think it's going to work satisfactorily.
While I've used access before, I have only used SQL with ColdFusion so I
dont have any direct
55 matches
Mail list logo