You should be able to use the CreateTimeSpan function for the expires
attribute.
IE EXPIRES="#CreateTimeSpan(0,0,5,0)#"
This will set it to expire in 5 minutes.
- Original Message -
From: "Art Broussard" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30,
Jeremy,
I know a few good ones in the states.
Would you consider hosting in ireland?
D
Daryl Fullerton,
Managing Partner,
BizNet Solutions,
Allaire Premier Partner (Ireland)
133 - 137 Lisburn Road
Belfast
BT9 7AG
Ireland
Direct +44 (0) 28 9022 7888
Tel +44 (0) 028 9022 3224
Fax +44 (0) 028 90
Get bent Lee. We can trash Bush if you want with much more validity;
politics belongs on CF-Politics. Check it out.
Eric J Hoffman, MAIP
Director of Internet Development
Small Dog Design
-Original Message-
From: Larry C. Lyons [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 200
Looking for a few other suggestions.. Admin swears he installed CF on NT 4
SP 6a Server as the Administrator but you can't even test the installation
without getting prompted for a login and password.. if you cancel, you get
the 401.3 Error "ACL on Resource"
It seems to be a permissions problem,
Hi,
I wonder if someone could help me out with some queries I'm running on a
scheduled task.
I need to send out outstanding invoices, including details of what they have
bought (i.e. an Advert - details of which are in advert_details). Once
done, I need to set the "Sent" column of the Invoices
Switch the where statement to
UPDATE JobInfoUpload
SET CheckedOut='Yes',
CheckedOutBy=#InSol.Name#
Where JobInfoUpload.FileID = '#URL.FileID#'
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 1
or maybe this (use field = value):
UPDATE JobInfoUpload
SET CheckedOut='Yes', CheckedOutBy=#InSol.Name#
Where JobInfoUpload.FileID = '#URL.FileID#'
> -Message d'origine-
> De: Chad Gray [SMTP:[EMAIL PROTECTED]]
> Date: Thursday, November 30, 2000 11:52 A
I am looking for a tool to Encrypt my Coldfusion Source Code. Any help
please.
Corey Dakin
County IS Director / Network Security Officer
Phone: 816.792.6532
Email: [EMAIL PROTECTED]
~~
Structure y
try this:
UPDATE JobInfoUpload
SET CheckedOut=1, CheckedOutBy=#InSol.Name#
Where '#URL.FileID#' = JobInfoUpload.FileID
> -Message d'origine-
> De: Chad Gray [SMTP:[EMAIL PROTECTED]]
> Date: Thursday, November 30, 2000 11:52 AM
> À:CF-Talk
> Objet:
There are lots of ways to do it, but if you start by finding out whether
there is a period, then you could use ListFirst() and ListLast() with '.' as
a delimiter to get both the first and last part. You could then use the
Mid() function combined with the Len() function to extract the different
pi
If your reading this, then the list has been moved to the new filtering
system. This has the effect of removing multiple footers and all of the
garbage generated by HTML email. I'm going to add in an on the fly subject
filter to kill threads that should not be on the list. I'm hoping I'll never
ha
Michael Dinowitz
Publisher - The Fusion Authority (www.fusionauthority.com/alert)
ListManager - CF-Talk, CF-Jobs, Spectra-Talk, JRun-Talk, etc.
(www.houseoffusion.com)
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http
This is a multi-part message in MIME format.
--=_NextPart_000_0010_01C05ACF.7A7A4F20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
CFlocking large if statements?
=20
How would you go about this if the "if" statement requires a "readonly" =
With , does CF have implicit file locking or
serialization of access to one file (such as a logging file common
used by all a site's pages) or do we have implement our own locking scheme?
In either case, what happens when there is a collision?
Does CF do its own retry/timeout thing or do we
The statement should be:
DELETE from auction_records where auction_id='#id#' and userid='#userid#'
- Sean
Sean Daniels
Manager, Engineering
Marketplace Technologies
(t) 207.439.6030
(c) 207.332.6340
http://www.dealforce.com
You don't need * in a delete statement
try
delete auction_records where auction_id='#id#' and userid='#userid#'
Marius Milosav
www.scorpiosoft.com
Virtual Help Desk Demo (VHD)
www.scorpiosoft.com/vhd/login.cfm
- Original Message -
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL
We are having the same problem on the development server. It was an
upgrade from 4.0.1 to 4.5.1sp2. Today, I uninstalled the CF4.5.1sp2 per the
following Allaire instructions:
Uninstall ColdFusion using the Add/Remove Programs Control Panel Applet.
Reboot.
Delete the entire \cfusion directory
Why the * ?
DELETE from auction_records where auction_id='#id#' and userid='#userid#'
If your 'deleting' your all of the record anyway.
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:11 AM
To: CF-Talk
Subject: SQL 7.0 Question
Ok I ju
Hold on Larry! You sound just like Sore and Loserman when you first get
your spin and slams in then say "let's tone down the rhetoric". If you're
going to say "lets keep politics out of CF-Talk", don't interject your
political views FIRST!
Hey, I feel like Sean Hannity! - LOL 8-)
Dave
Do you have your clause flip-flopped?
Where '#URL.FileID#' = JobInfoUpload.FileID
Should be:
Where JobInfoUpload.FileID='#URL.FileID#'
- Original Message -
From: "Chad Gray" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 10:51 AM
Subject: UPDAT
Chad, are you sure, you have the right datasourcename ?
It looks more like the raw DB-name you used.
Uwe
Mail: [EMAIL PROTECTED]
WWW: www.sdsolutions.de
- Original Message -
From: "Chad Gray" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 5:51 PM
you don't need the cfoutputs in the query, just the # signs will do, and you
probably need single quotes around #insol.name#. Also, if
JobInfoUpload.FileID is a numeric field then you need to remove the single
quotes from #URL.FileID#. Also, I'd reverse the where clause parameters to
make it mor
No the * is not used in SQL 7.0 when using the DELETE function
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:11 AM
To: CF-Talk
Subject: SQL 7.0 Question
Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
works great
At 08:42 AM 11/30/00 -0500, you wrote:
>Question: What does it mena if CF Studio 4.5.1 returns an error that
>says "Canvas can not be used for drawing"? If anyone knows, I'd really
>appreciate it. Thanks!
>
>
>Scott Wolf
>Goodfriend Computer Training
It means the memory leak in Studio has use
Chad, you probably just need single quotes around
'#InSol.Name#' Single quotes let the database know
that you are inserting a string, for instance into a
TEXT field. They're easy to forget by mistake.
(and you may also be missing a (but that's
not likely the cause of your problem here))
Eron
Just to pass on something I learned recently - CFERROR doesn't like comments in the CF
pages it calls (putting them at the end of the CF page worked better than at the
beginning).
We have CFERROR call a CF page, which then runs SendMail and calls another CF page.
With comments at the beginnin
NO POLITICS PLEASE everyone has different beliefs, no need to spout of
yours to a cf list. Go to alt.politics.gore.bashing.whining
Emmet McGovern
-Original Message-
From: Lee Surma [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 9:09 AM
To: CF-Talk
Subject: Gore is OJ!
You should be setting up primary keys or unique index's in your database for
the fields you don't want duplicates. Then around your insert/update
statements us cftry type="database" to catch it when they try and insert
duplicate information, then deal with them appropriately.
Rick
-Original
This is a multi-part message in MIME format.
--=_NextPart_000_000B_01C05AC9.FD0C4520
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
CFlocking large if statements?
How would you go about this if the "if" statement requires a "readonly" =
an
Yes.
This gives you today
This will give a date 365 days before today
If your date is older than a year the datecompare function will return 1.
- Original Message -
From: "fr me" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 9:59 AM
Su
You don't need the s inside of a .
Also, you need single quotes around #InSol.name#, or else the database
thinks "chad" is a field name and will compain when it can't find it.
Todd Ashworth
- Original Message -
From: "Chad Gray" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent
Check out the function dateDiff()
-Original Message-
From: fr me [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 9:59 AM
To: CF-Talk
Subject: Get the last 12 months transactions?
Does anyone know how to test that a date is in the last 12 months?
Chad,
Is your last line of code switched around? Should it read
Where JobInfoUpload.FileID = '#URL.FileID#'
instead?
Mark
Mark Wimer, Bird Point Count Database
American Bird Conservancy, c/o
USGS-Patuxent Wildlife Research Center
12100 Beech Forest Road, Laurel, MD 20708-4038
Ph: 301-497-
How about this? It's a cfm file that you can include to check for
duplicates. I wrote it awhile ago, for a particular purpose, and I just now
noticed that it only deals with character fields. You could add extra logic
to deal with numeric fields as well. Perhaps it will give you an idea of
wha
A simple request to keep this type of commentary off list would have been
sufficient - yet you wasted little time and gave little effort in
contemplating the reprocussions of tossing your 2 pence in the ring.
No more commentary on this - now that you've got your verbal diarrhea off
your chest rig
Here are a couple of things. When you get too few parameters, you have
messed up your SQL statement: here is where you messed up:
Checkedoutby needs single quotes around it like checked out.
I don't know if this is mandatory or not, but you might want to switch
JobInfoUpload.FileID and #URLFil
I second that!!!
I am here to read up on ColdFusion as well.
Jamey
- Original Message -
From: "William J Wheatley" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 8:26 AM
Subject: RE: Gore is OJ!!
> WTF???
>
> I dont subs
Of course we can get back to CF - but only after you snipe your tripe in
there... right? Typical.
The guy obviously posted to the wrong list - I suppose as a stereo typical
"perfect" democrat youve never made a similar mistake?
Your post was so ... "Mean Spirited" ... tsk tsk tsk.
If you are s
don't use a '*' in the delete statement on SQL7
At 11:11 AM 11/30/00 -0500, you wrote:
>Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
>works great except one statement.
>
>
>DELETE * from auction_records where auction_id='#id#' and userid='#userid#'
>
>
>Here is the err
Larry:
If you wanna keep polotics out of CF-Talk, I suggest not starting more
problems by insulting others. Let's just kill this message thread right
here.
Greg
- Original Message -
From: "Larry C. Lyons" <[EMAIL PROTECTED]>
Newsgroups: cf-talk
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Th
Try this:
(will run 'start' code in tag)
(will run 'end' code in tag)
In your tag, you can run the appropriate code depending on the value of
Attributes.Part.
Kevin
>>> [EMAIL PROTECTED] 11/30/00 05:32AM >>>
I don't know if what you are trying to do is possible. Double
checking
That would be what I would suggest as well. Just set up a custom tag that
executes any time a file is uploaded. Read in the content of the file and
use regular expressions to sort out the links and kill or mangle them.
PS the jnl site still hasn't changed
Kevin Schmidt
Allaire Certified Cold Fu
I believe the SQL should read:
DELETE from auction_records where auction_id='#id#' and userid='#userid#'
(minus the *)
- - - Jeanne
- Original Message -
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 11:11 AM
Subject: SQL 7.0 Questi
I'm surprised that statement worked in Access.
The delete statement automatically deletes a whole row. You do not
need to specify a wildcard, or column as you would in a select statement.
DELETE from auction_records where auction_id='#id#' and userid='#userid#'
ibtoad wrote:
>
guess what lee I do not appreciate this at all either I find it to be
unprofessional and childish but Mr. Wheatley you could be a little more
professional as well I personally am uninterested in the whole election
bumble that has turned out so please do not post any more political comments
on this
Why does the following always return TRUE?
TRUE
FALSE
Do I need to put the values into an array?
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Simon Park Computer Systems Management, Inc.
Ph: 703-823-4300 x119 205 South Whiting Street #201
fax: 703-823-4301 Al
Look up the syntax for sp_dettach and sp_attach.
With that you can move the db by hand with no leftovers.
Chris
--
Original Message
From: "ryo watanabe"<[EMAIL PROTECTED]>
Subject: SQL 7 database transfer from one server to another
Date: Thu, 30 Nov 200
Thanks Dave... I couldn't have said it any better...
Marcus
A net admin
> With all due respect, I suspect you're not a network admin!
>
> Any time you open a port, it's a risk - it's another thing that has to be
> watched. There are typically limited resources for what a network
> administrator
On 11/30/00, j p penned:
>Example:
>Section A - is the actual page code I want to generate, with all character
>that cause a problem replaces with something else. This is needed beacuse a
><, >, or " inside a CFSET (or inside teh CFFILE) will cause the tag to
>fail.
There should be no problem us
Try just DELETE FROM WHERE
You'd have to use UPDATE to delete/mangle individual cell data, so the * in
the previous statement is unnecessary. :)
--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC 28270
www.solutionmasters.com
704.563.5559 x 228 Voice
704
Hi
i have created a calendar with date functions,
examples;
#daysInMonth(now())#
#dayofweek(now())#
#dayofweekAsString(todayOfWeek)#
the problem is, that netscape takes a long time to process these functions.
it works fast in IE though.
are there any alternative functions i can use?? or an
Watch your language man. I don't want to see that filth on the list. I agree
that the previous post could be left off, but your post is worse than the
one you are complaining about.
So chill.
-Original Message-
From: William J Wheatley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November
That's right, don't use the *
Just DELETE FROM ... WHERE ...
Regards,
Gaston
> -Mensaje original-
> De: ibtoad [SMTP:[EMAIL PROTECTED]]
> Enviado el: Jueves 30 de Noviembre de 2000 13:11
> Para: CF-Talk
> Asunto: SQL 7.0 Question
>
> Ok I just did a local upg
ok this is way Way OT:
i wanted to get my fiance a cheap PDA that has internet capabilities.
so i can beging to experiment on building wap app's.
what is good, what is worth its price?
i have been looking at the hand springs & palms but would like your feed
back if you have any good or bad exp
try
DELETE auction_records where auction_id='#id#' and userid='#userid#'
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:11 AM
To: CF-Talk
Subject: SQL 7.0 Question
Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
Your statement for SQL would be:
DELETE from auction_records where auction_id='#id#' and userid='#userid#'
(basically delete the "*")
Gregory Harris
Web Developer
Stirling Bridge Group LLC
- Original Message -
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: T
Take out the * in the Query in SQL all you need is
DELETE from auction_records where auction_id='#id#' and userid='#userid#'
Instead of
DELETE * from auction_records where auction_id='#id#' and userid='#userid#'
You will need to do this on all you DELETE if you have many
-Original Messa
I do not think this is the medium for Political Debates. Please take this
off-list.
Vance Duke
Cold Fusion Application Developer
i2 Technologies
(469) 357-4729
If you're deleting, you don't need the "*". SQL Server understands that you
want to delete the whole row just by saying "DELETE FROM tablename where
something = 'somethingelse'".
Evan
> -Original Message-
> From: ibtoad [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 30, 2000 11:1
I got your message 12 minutes after it was sent. Its possible that the list
is having problems sending mail to you. This happens when the connection
between the HoF server tries and fails to connect to another mail server for
some reason. The message is then 'queued up and then tried again in an h
This doesn't even belong on CF-Community let alone CF-Talk.
This is SPAM.
Stop it.
> -Original Message-
> From: Lee Surma [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, November 30, 2000 6:09 AM
> To: CF-Talk
> Subject: Gore is OJ!!
>
> This is a multi-part message in MIME format.
>
Anyone else having problems sending to the list?
I have sent 2 messages already.
First one was at 11:32 AM (Eastern Time)
Second one was at 1:02 PM (Eastern Time)
And now this one at 1:51 PM (Eastern Time)
All dated 11/30/2000.
I can send and receive to other people and to
other lists.
Is CF
Something like
--
Billy Cravens
[EMAIL PROTECTED]
fr me wrote:
>
> Does anyone know how to test that a date is in the last 12 months?
> _
> Get more from the Web. FREE MSN Explorer download : http:
In Oracle you just use DELETE FROM TABLE. No * is necessary.
Duncan Hays
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:11 AM
To: CF-Talk
Subject: SQL 7.0 Question
Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
hmm.. maybe my judgement is a bit different than most, but this strikes
me as a smidgen off-topic.
--
Billy Cravens
[EMAIL PROTECTED]
Lee Surma wrote:
>
> This is a multi-part message in MIME format.
>
> --=_NextPart_000_0005_01C05AA4.D737AB20
> Content-Type: text/plain;
> charse
welcome to the club...We're having the same problem. Reinstalling didn't help.
CFLOCKs didn't help. Not sure what to do but it looks like 4.0.1 may be the fallback.
We're running Oracle 8, NT sp6a and IIS4.
dave
-- Original Message --
From: [EMAIL
I'm trying to build a tag that gets the article text from an access memo
field and returns part of it as a news excerpt on another page. I thought of
doing a cfhttp from the main news page and stripping it down, but I think
that would be slow and I was wondering if anyone had a better suggestion
Yes, you don't need * when doing a SQL delete statement.
Dave
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 10:11 AM
To: CF-Talk
Subject: SQL 7.0 Question
Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
works great
Yes, * is the syntax for ALL in SQL7, but you don't need to specify that
for a DELETE.
When you issue a delete, you delete the entire record, so there is no need
to specify columns.
Try:
DELETE from auction_records where auction_id='#id#' and userid='#userid#'
Chris
-
You do not need the *.
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 10:11 AM
To: CF-Talk
Subject: SQL 7.0 Question
Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
works great except one statement.
DELETE * from a
I believe you want:
DELETE from auction_records where auction_id='#id#' and userid='#userid#'
in other words, you don't want that asterisk.
~Simon
> Simon Horwith
> Certified ColdFusion Developer
> Fig Leaf Software
> 1400 16th St NW, # 220
> Washington DC 20036
> 202.797.6570 (direct line)
If
the date you are testing if the date is greater than or equal to last year
(substitute your favorite operator as needed)
Gregory Harris
Web Developer
Stirling Bridge Group LLC
- Original Message -
From: "fr me" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thurs
Eastern :P
Scott Wolf
Goodfriend Computer Training
-Original Message-
From: Rif Kiamil [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 9:00 AM
To: CF-Talk
Subject: What Time Zone
Dear All,
I know this is not the place for this type of message but does any body
know
what T
The Lyris server I was using for news crashed the network services (as I
mentioned in a different post). Now that it is off, the posts are flying.
> Has anyone experienced a LONG TIME before they
> receive emails from House of Fusion or even their
> own POSTS?
>
>
>
> ~~~
Take this topic over to CF-Community or better yet take it totally off the
lists. It is very OT for CF-Talk and I don't want to come down hard on
anyone.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauth
Lee: You better don some protective gear... not only did you start a
polarizing political topic in the development-oriently CF-Talk list, you did
it with an HTML message. :)
Everyone else: Please, let this die now. Send your responses to
mailto:[EMAIL PROTECTED] if you really feel the need.
thx,
Love to keep things on topic of computers, especially CF. Take your
political jargon over to CNN bulletin boards or anything.
Robert Everland III
Web Developer
Dixon Ticonderoga
~~
Structure your ColdFusion code with Fusebox. Get the official book
> We had this problem and needed to reinstall MDAC. There is a
> copy of it in
> \mdac
If you're running Win2K, you can't reinstall MDAC to my knowledge.
Installing CF on Win2K sometimes breaks ADO for ASP, so having OLEDB broken
too doesn't surprise me. Unfortunately, sometimes only a Win2K rei
You are correct, just leave off the *
- Original Message -
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 10:11 AM
Subject: SQL 7.0 Question
> Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
> works great e
Has anyone experienced a LONG TIME before they
receive emails from House of Fusion or even their
own POSTS?
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www
Allaire's HQ in Massachusetts is in the Eastern Timezone
(Glad to get a question I know the answer to..thanks to all for all the help
over the past year.)
John Tierney
-Original Message-
From: Rif Kiamil [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 9:00 AM
To: CF-Talk
S
Or if you want to do it in SQL, use the BETWEEN operator
-Original Message-
From: fr me [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 7:59 AM
To: CF-Talk
Subject: Get the last 12 months transactions?
Does anyone know how to test that a date is in the last 12 month
You can use DateDiff()
-Original Message-
From: fr me [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 7:59 AM
To: CF-Talk
Subject: Get the last 12 months transactions?
Does anyone know how to test that a date is in the last 12 months?
___
I'm guessing auction_id or userid are numeric -- not text -- fields; try
removing the single quotes where appropriate.
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 10:11 AM
To: CF-Talk
Subject: SQL 7.0 Question
Ok I just did a local upgrad
No, just remove the asterisk (*) and it should work fine. In delete queries, it
is assumed that you want to delete all records that match the criteria in the
WHERE clause, unless you explicitly specify which fields to delete.
-- Bruce
> -Original Message-
> From: ibtoad [mailto:[EMAIL PR
Why on earth do that??
That will be chaos!
THe subjectline should be enough to see the type of error or help needed or
offered, or at least the first few lines of the
message.
How will having 10 different mailing lists for each facet of CF help? Would
anyone ONLY subscribe to say the "Security"
You may want to use FROM instead of from, I am not sure if it is that picky
or not, but * does mean all in SQL 7.0 as well.
Robert
- Original Message -
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 11:11 AM
Subject: SQL 7.0 Question
You don't need the * ... DELETE FROM will work just fine.
Todd Ashworth
- Original Message -
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 11:11 AM
Subject: SQL 7.0 Question
| Ok I just did a local upgrade from Access 2000 to SQL
who's gore? Is he an allaire certified doodah?
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://
This is a multi-part message in MIME format.
--=_NextPart_000_0017_01C05ACB.7FC19D70
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hey Guys:
I am building a web site that randomly pulls 4 different categories from =
a database and display
> -Original Message-
> From: fr me [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 30, 2000 10:59 AM
> To: CF-Talk
> Subject: Get the last 12 months transactions?
>
>
> Does anyone know how to test that a date is in the last 12 months?
>
>
>
Try something like this:
SELEC
the date variable is within one year of now.
the date variable is older than one year
By te way,
A less efficient way of doing this, which is more flexible in that you don't
have to be testing for a date within an interval of now (i.e. you could
specify a range) might look something like thi
OK, so you populate your "select distributor state" control from tblstate,
with the values = state_name
Then do the same query on your listing page, but add WHERE dis_state =
'#FORM.#'
You can even put a conditional in your cfquery:
select
FROM
etc
etc
NEQ >
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
You might be able to use the HTTP Referer of the request to determine
whether to show the page or not. We use a similar thing to prevent
direct linking to image content on our site -- we use CF to serve
images via CFCONTENT. The page checks the refe
Anyone know of any goof CF Hosting companies that charge about 20 to 30 per month. I
am with BMI.net right now and they are not very good.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkin
Hi,
I wonder if someone could help me out with some queries I'm running on a
scheduled task.
I need to send out outstanding invoices, including details of what they have
bought (i.e. an Advert - details of which are in advert_details). Once
done, I need to set the "Sent" column of the Invoices
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
>
> DELETE * from auction_records where auction_id='#id#' and
> userid='#userid#'
>
>
> Here is the error:
>
> ODBC Error Code = 37000 (Syntax error or access violation)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1:
> Incorrect syntax
> companies like checkpoint (they might have been acquired - not sure)
> make/made great products for securing internet/network traffic.
Just a FYI, Check Point are still running happily;
Check Point Software Technologies
Suite 5B
Enterprise House, Vision Park
Histon,
Cambridge
Cambridgeshire
CB4
> Question: What does it mena if CF Studio 4.5.1 returns an error that
> says "Canvas can not be used for drawing"? If anyone knows, I'd really
> appreciate it. Thanks!
Your resources are too used up
Close some applications and try again... it's bleeding annoying
Philip Arnold
Director
Certi
> I have a unique problem. I know how to keep folks from linking to my
> pages on my server, but I allow others to also post pages to my web
> servers. Their pages contain links to places I don't want folks going to.
> So, I could prevent them from writing their pages on my server, or I
> could
1 - 100 of 154 matches
Mail list logo
