rar'd to 25 mb
www.jamwerx.com/open/icons.rar
sorry bout the mess that they are but the crap otherwiseknownas winxp keeps crashing when i try to open any folders.
*note to myself: get rid of that xp crap & use linux for anything valuable*
>sounds great...thanx
>
>__
Would you sponsor a green card application?
Aaron
Dreaming in technicolor
- Original Message -
From: Bailey, Neal
To: CF-Talk
Sent: Saturday, August 14, 2004 7:30 AM
Subject: Great Job opportunity... DFW Area
Hello fellow CFers...
The company I work for is looking to fill a CF & .NE
>>Others say you should specify
individual columns unless you intend to use all the columns in the
query because it takes less time to get the part of the data you need
than to get all the data.
Personally I am among these others.
And do not rely on the time shown by the CF server for the query. T
> > Yes, just before I recieved your message
> > I figured that one out :)
> > Paul Giesenhagen
> > QuillDesign
> > 417-885-1375
> > http://www.quilldesign.com
> Damn I'm good. :)
> I need to start an ESP tech-support company. :P
> Shoot, I would call :)
And you already have.
Shoot, I would call :)
Paul Giesenhagen
QuillDesign
417-885-1375
http://www.quilldesign.com
- Original Message -
From: S. Isaac Dealey
To: CF-Talk
Sent: Friday, August 13, 2004 9:53 PM
Subject: Re: Blown Away Query
> Yes, just before I recieved your message I figured that
> Yes, just before I recieved your message I figured that
> one out :)
> Paul Giesenhagen
> QuillDesign
> 417-885-1375
> http://www.quilldesign.com
Damn I'm good. :)
I need to start an ESP tech-support company. :P
s. isaac dealey 954.927.5117
new epoch : isn't it time for a change?
add fea
Yes, just before I recieved your message I figured that one out :)
Paul Giesenhagen
QuillDesign
417-885-1375
http://www.quilldesign.com
- Original Message -
From: S. Isaac Dealey
To: CF-Talk
Sent: Friday, August 13, 2004 9:44 PM
Subject: Re: Blown Away Query
did you not ge
did you not get my reply? ... :)
that was my first guess -- option is a reserved word. :)
> Figured it out ...DB didn't like "option" .. I changed it
> to boatOption and it worked ... go figure..
> Paul Giesenhagen
> QuillDesign
> 417-885-1375
> http://www.quilldesign.com
> - Original Mes
WB Ade! :) (That's "warner brothers" to the uninitiated)
> You'd also use it when you're still developing and you're
> not sure what
> columns will or won't be used.
> Just signed up to CF-Talk again after a while away
> minutes later and I
> have three emails from the list, see as high volum
In T-SQL, OPTION is a reserved word.
Mike
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Long shot, but in QA option is highlighted as a special word. See if
changing it fixes the problem.
Ade
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]
Sent: 14 August 2004 02:10
To: CF-Talk
Subject: OT: Blown Away Query
Ok, this blows me away .. here is the query:
I
You'd also use it when you're still developing and you're not sure what
columns will or won't be used.
Just signed up to CF-Talk again after a while away minutes later and I
have three emails from the list, see as high volume as it used to be I see
:OD
Ade
-Original Message-
From: S.
At 09:09 PM 8/13/2004, you wrote:
>Ok, this blows me away .. here is the query:
>
>INSERT INTO boatOptions (boatID,option) VALUES(13,'x')
>
>Simple enough? Well I am getting Syntax Errors with it..
>
>BoatID = Int
>option = VarChar (75)
>
>Am I missing something here ...?
Option is a reserved wo
Figured it out ...DB didn't like "option" .. I changed it to boatOption and it worked ... go figure..
Paul Giesenhagen
QuillDesign
417-885-1375
http://www.quilldesign.com
- Original Message -
From: Paul Giesenhagen
To: CF-Talk
Sent: Friday, August 13, 2004 8:09 PM
Subject: OT
> Ok, this blows me away .. here is the query:
> INSERT INTO boatOptions (boatID,option) VALUES(13,'x')
> Simple enough? Well I am getting Syntax Errors with it..
> BoatID = Int
> option = VarChar (75)
> Am I missing something here ...?
I wouldn't be surprised if Option is a reserved word.
s
> So OT, why is using Select * a bad practice? URLs anyone?
The general consensus is that it's unnecessarilly inefficient. Not
everyone agrees obviously.
...
I should probably clarify this some...
Some people will tell you that even if you're going to draw every
column in the query anyway, you
Ok, this blows me away .. here is the query:
INSERT INTO boatOptions (boatID,option) VALUES(13,'x')
Simple enough? Well I am getting Syntax Errors with it..
BoatID = Int
option = VarChar (75)
Am I missing something here ...?
Paul Giesenhagen
QuillDesign
417-885-1375
http://www.quilldesign.com
> So OT, why is using Select * a bad practice? URLs anyone?
The general consensus is that it's unnecessarilly inefficient. Not
everyone agrees obviously.
s. isaac dealey 954.927.5117
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
h
> Evening,
> Trying to update multiple rows. If using this:
> morder = '#evaluate("form.morder_#myIDX#")#'
> ..inside the query works fine, but what if the value isn't
> defined and I
> need to set a null?
> Here's what I'm using...
>
>
> UPDATE modules set
>
> #evaluate("form.mnote_
You really ought to be using the DOM standard to get your document
element tho... and cfsavecontent would be a real friend...
>
The value passed to the document.getElementById() method matches an id
attribute in the element you want to use. So if it's a hidden input
field, it'd look like
Evening,
Trying to update multiple rows. If using this:
morder = '#evaluate("form.morder_#myIDX#")#'
..inside the query works fine, but what if the value isn't defined and I
need to set a null?
Here's what I'm using...
UPDATE modules set
#evaluate("form.mnote_#myIDX#")# EQ ''>
mnot
Same error on that one ... I guess I could use the query below for MS SQL and then run a loop with MS Access .. it just seems so simple ... it should work with access.
Paul Giesenhagen
QuillDesign
417-885-1375
http://www.quilldesign.com
- Original Message -
From: Christian Watt
To
> I have a money field that needs to be greater than $0.01.
> The field may
> or may not contain a dollar sign ($) and may or may not
> contain a period
> (.) as a dollar/cents split. When the form loads the
> default value is
> $0.00
> What would be the easiest way to verify the amount is
> great
put this into a function:
var reg = /([^0-9\.])/g;
var str = "$0.01";
var myValue = parseFloat(str.replace(reg,""))
alert(myValue>0);
> -Original Message-
> From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 13, 2004 4:46 PM
> To: CF-Talk
> Subject: OT: _javascript_
you could loop form.fieldnames or the form collection and increment a counter if
FindNoCase("HEADLINEID_", index)
- Original Message -
From: Asim Manzur
To: CF-Talk
Sent: Friday, August 13, 2004 1:39 PM
Subject: Dynamic Form Element
A quick question.
I have dynamic form
> SELECT * FROM tbl001 WHERE name >= ? AND ID <> 125 ORDER
> BY ID DESC
> Any query whose debug output exactly matches this debug
> output will take advantage of the statement pool.
> IN CFML, it is fairly unusual for SQL statements to
> exactly match, unless is used extensively.
> This means th
Honestly I have not idea what to look for in the stack traces, do you,
or anyone else have any idea where I can find some info on what to look
for and how to read the stack traces?
Christian
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, August 13, 2004
interesting. this was for cincinnatti close to ketucky, indiana border
-Original Message-
From: Christian Watt [mailto:[EMAIL PROTECTED]
Sent: Friday, August 13, 2004 5:38 PM
To: CF-Talk
Subject: RE: OT- sql format question
Eric,
I am going to guess that there is a flaw with the other for
Eric,
I am going to guess that there is a flaw with the other formula you
have. I did a lot of searching on the best formula to use, and that is
what I came up with. But if you think about it, 324 zip codes in a 50
mile radius, that means that every 2.7 miles you are in a new zipcode.
The only th
Paul,
I just test this code in MSSQL. Access my not like the or, but this
one works for ProductID of 0 or 18 and works the way you want. I am not
sure if access will like it. You don't have to stipulate the ProductID
as null since you are doing an outer join, also, sorry I didn't catch
this
> Oops, I didn't include that piece, but Yes, I am running the
> latest JAVA version.
In that case, I'm out of easy answers. You'll have to start looking at log
files and/or running stack traces.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[T
Thanks again for the help
Question though. When i run your sp I get 26 zipcodes for the cincinnatti surrounding area of 50 miles. When I run the other code in access i get 324 zipcodes?
Here is that ACCESS code again
SELECT zipCodes.*, Sqr(((69.1*(CDbl(zipCodes.Latitude)-39.166759))^2)+((6
Oops, I didn't include that piece, but Yes, I am running the latest JAVA
version.
Christian
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, August 13, 2004 5:21 PM
To: CF-Talk
Subject: RE: Memory Issues
> Let me add to my last post. When the memor
I tried your example query, and recieved a "join _expression_ not supported" error. I assume that is an MS Access error ..
I am trying to make this work with both MS SQL Server and MS Access (I can use two queries if necessary). Currently I am working in Access for this application.
Paul Giesen
> Let me add to my last post. When the memory jumps, it stays
> up for 2-3 minutes, sometimes longer. It will usually drop
> back down to around 175mb -225mb after that period, and then
> take another jump down a few minutes later. This wouldn't be
> so bad if it never jumped over 750mb, but
I tried your example query, and recieved a "join _expression_ not supported" error. I assume that is an MS Access error ..
I am trying to make this work with both MS SQL Server and MS Access (I can use two queries if necessary). Currently I am working in Access for this application.
Paul Giesen
You need to take your Where clause out and include it on the join. I
believe that since you are including the outer joined table in the
where, you are not going to return any records that don't match the
Where statement.
FROM #request.levelTable# l
RIGHT OUTER JOIN #request.levelPricingTable# p
Let me add to my last post. When the memory jumps, it stays up for 2-3
minutes, sometimes longer. It will usually drop back down to around
175mb -225mb after that period, and then take another jump down a few
minutes later. This wouldn't be so bad if it never jumped over 750mb,
but I can not fig
I tried to ask this on Experts Exchange without any luck ... maybe one of you guys may be able to help out.
I am trying to build some pricing levels into our application and having a hard time with SQL query, here is an explination.
I have 2 tables:
LEVELS
levelID, code, descrip
>>If only I could relocate
May be THEY can relocate? ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
[Todays Threads]
[This Message]
[Sub
I have a money field that needs to be greater than $0.01. The field may
or may not contain a dollar sign ($) and may or may not contain a period
(.) as a dollar/cents split. When the form loads the default value is
$0.00
What would be the easiest way to verify the amount is greater than 1
cent (0.
I just switched all of my data sources and NO CHANGE!!! I am getting
peaks of over 500mb right now. Not that many users and I don't have any
queries that return an extreme amount of data. arrrggg
Christian Watt
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent
If only I could relocate :-(
Michael T. Tangorre
> -Original Message-
> From: Bailey, Neal [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 13, 2004 5:30 PM
> To: CF-Talk
> Subject: Great Job opportunity... DFW Area
>
> Hello fellow CFers...
>
> The company I work for is looking to
Hello fellow CFers...
The company I work for is looking to fill a CF & .NET fulltime position with
benefits and all the good stuff. We need someone who is local to the Dallas
/ Fort Worth area.
The requirements are:
Advanced Skills in ColdFusion MX 6.1.
Advanced Skills in .NET
Microsoft
Thanks. I can search Google myself. Have a good weekend.
-Original Message-
From: Joe Rinehart [mailto:[EMAIL PROTECTED]
Sent: Friday, August 13, 2004 2:59 PM
To: CF-Talk
Subject: Re: Error Handling
where you've defined a form named errorForm that contains error
info
On Fri, 13 Aug 2004 13:26:18 -0700
Matt Robertson <[EMAIL PROTECTED]> wrote:
> The latter approach works far better when you do it
>inside of an
> individual application, and thats my second prong to
>this: You
> mentioned putting CFTRY into Application.cfm and
>terminating it in
> OnReQuest
sounds great...thanx
From: Kris Baca [mailto:[EMAIL PROTECTED]
Sent: Friday, August 13, 2004 3:24 PM
To: CF-Talk
Subject: Re: Document Icons
I'll take em!
- Original Message -
From: dave <[EMAIL PROTECTED]>
Date: Thu, 12 Aug 2004 18:09:55 -0400
Subject:
I like to use a 2-pronged effort when it comes to error handling.
First of all, I establish a site-wide error handler in the CF
Administrator. This is different than a 404 handler. If it comes
down to it, this one tool can handle all CF errors on a particular
server for you. That site-wide erro
I'll take em!
- Original Message -
From: dave <[EMAIL PROTECTED]>
Date: Thu, 12 Aug 2004 18:09:55 -0400
Subject: RE: Document Icons
To: CF-Talk <[EMAIL PROTECTED]>
i have crap loads of these things, if ppl want i will siz them and
upload them but its about a 70 mb dl
-- Original
http://www.houseoffusion.com/error.ppt
This is an old presentation, but it has the basics. What I do now is just a CFMAIL with a number of CFDUMPs for the error, url, form, cgi, and memory var scopes.
>I want an email to go out every time there is an error on
>a given application. Is it a little
> I have not. I just downloaded the Microsoft JDBC Driver SQL
> 2000 and the SP1 for the driver. Is just an install enough,
> or do I need to do something in JRUN as well??? Thank you
> for help Dave...I greatly appreciate it.
I thought the latest version of the MS SQL Server JDBC driver was
where you've defined a form named errorForm that contains error information.
If you need more details, let me know and I'll find a tutorial real
quick via google, but I'm on my way out of the office for the weekend.
On Fri, 13 Aug 2004 14:17:35 -0500, Andy Ousterhout
<[EMAIL PROTECTED]> wro
>This is usually accomplished by specifying an error template via the
>CFERROR tag in your application. Because the template specific has a
>narrow range of CF it can execute, most people then use _javascript_ to
>have the error template post a hidden form to a full-fledged CF
>template that email
thanx BarneyB,
so far so good...I've tried several ways...but not that one!
I appreciate it -
Frank
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Friday, August 13, 2004 2:38 PM
To: CF-Talk
Subject: Re: _javascript_ syntax (quotes)
Try this (remo
Try this (removed the plus signs and replaced the backslashes with apostrophes):
>
>
>
>
>
>
>
>
>
>
> >
> src="" >
> is giving me an error. I think that this is because or the quotes...how
> do I solve this?
>
> Thank you -
>
I have not. I just downloaded the Microsoft JDBC Driver SQL 2000 and
the SP1 for the driver. Is just an install enough, or do I need to do
something in JRUN as well??? Thank you for help Dave...I greatly
appreciate it.
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Se
That's what I wondered as well...apparently it's not too bad, and we haven't had any noticeable decrease. See below, again from MM.
This excerpt is part of a discussion we had internally about this. I hope it helps clarify this.
"If you set maxpooledstatements = 100; for each connection, the la
> Yes, I have installed all of the hot fixes and latest drivers
> as of about 2 1/2 months ago. That is when I set everything
> up as a clustered environment. Hoping that both clustering
> and getting all of the updates/patches installed and a clean
> install would help correct this issue. S
hello all,
I'm running this code:
>
src="" >
is giving me an error. I think that this is because or the quotes...how
do I solve this?
Thank you -
Frank
---
Yes, I have installed all of the hot fixes and latest drivers as of
about 2 1/2 months ago. That is when I set everything up as a clustered
environment. Hoping that both clustering and getting all of the
updates/patches installed and a clean install would help correct this
issue. Same problem st
Joe,
Do you have an example of the _javascript_?
Andy
-Original Message-
From: Joe Rinehart [mailto:[EMAIL PROTECTED]
Sent: Friday, August 13, 2004 1:57 PM
To: CF-Talk
Subject: Re: Error Handling
Lee,
This is usually accomplished by specifying an error template via the
CF
My last post included a 200 mile radius. Just change the 200(s) to 50
for a 50 mile radius.
Christian
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Friday, August 13, 2004 2:02 PM
To: CF-Talk
Subject: RE: OT- sql format question
OOOPs it looks like I f
> I am having a huge issue with memory right now. I have
> turned off all session and application variables. If I get
> more than 50-75 simultaneous users, my memory starts to
> explode rather rapidly from around 150mb to over 750mb for
> the jrun service. Two problems here, 1) even though I
At 03:02 PM 8/13/2004, Eric Creese wrote:
>OOOPs it looks like I forgot to paste the rest:
>
>
>WHERE
>(((Square(((69.1*(CDbl(zipCodes.Latitude)-39.166759))^2)+((69.1*(CDbl(zipCodes.Longitude)-84.53822)*Cos(39.166759/57.3))^2)))<50));
Okay...
WHERE
SQRT(POWER((69.1*(zipCodes.latitude-39.166759
I don't know if you are dealing with degrees or radians, but here is my
SQL code using radians.
Of course this is a stored procedure where I pass the Lat and Lon.
SELECT Zip
FROM Zip
WHERE((lat >= (@TLat - (200 * 0.0005))) AND
(lat <= (@TLat + (200 * 0.0005 AND
((lon
Hmm,
I wonder what that does to performance though.
George
On Fri, 13 Aug 2004 13:57:23 -0500, Pat Wenke <[EMAIL PROTECTED]> wrote:
> George -
>
> We were getting the same errors when adding / removing columns from the DB. You might want to try the following (if you're still wanting to use and
OOOPs it looks like I forgot to paste the rest:
WHERE (((Square(((69.1*(CDbl(zipCodes.Latitude)-39.166759))^2)+((69.1*(CDbl(zipCodes.Longitude)-84.53822)*Cos(39.166759/57.3))^2)))<50));
-Original Message-
From: Phillip Beazley [mailto:[EMAIL PROTECTED]
Sent: Friday, August 13, 2004 1:58
I am having a huge issue with memory right now. I have turned off all
session and application variables. If I get more than 50-75
simultaneous users, my memory starts to explode rather rapidly from
around 150mb to over 750mb for the jrun service. Two problems here, 1)
even though I have set up m
At 02:38 PM 8/13/2004, you wrote:
>This was written in access, can anyone convert to T-SQL
>I keep doing it and keep missing something.
>
>SELECT zipCodes.*,
>Sqr(((69.1*(CDbl(zipCodes.Latitude)-39.166759))^2)+((69.1*(CDbl(zipCodes.Longitude)-84.53822)*Cos(39.166759/57.3))^2))
>AS DistanceInMile
George -
We were getting the same errors when adding / removing columns from the DB. You might want to try the following (if you're still wanting to use and SELECT *) from Stephen Dupre at Macromedia:
"Maybe the statement cache is getting us. Try shutting off "Max Pooled Statements" (set t
Lee,
This is usually accomplished by specifying an error template via the
CFERROR tag in your application. Because the template specific has a
narrow range of CF it can execute, most people then use _javascript_ to
have the error template post a hidden form to a full-fledged CF
template that emai
I want an email to go out every time there is an error on
a given application. Is it a little nutty to do this?
Put the beginning cftry tag in the application.cfm file
and put the cfcatch with cfmail and the closing cftry tag
in the onrequestend.cfm file? Can I do something similar
in just the
Hey Ray,
This is another approach I've used. Since there's a pattern to the
names, I just reReplace out the fields we're trying to count from
form.fieldNames and take the difference.
listLen(reReplaceNoCase(form.fieldNames, "headlined_[0-9]+,*", "",
"all"))>
-joe
- Original Message
This was written in access, can anyone convert to T-SQL
I keep doing it and keep missing something.
SELECT zipCodes.*, Sqr(((69.1*(CDbl(zipCodes.Latitude)-39.166759))^2)+((69.1*(CDbl(zipCodes.Longitude)-84.53822)*Cos(39.166759/57.3))^2)) AS DistanceInMiles
FROM zipCodes
WHERE (((Sqr(((69.1*(CDbl(z
So OT, why is using Select * a bad practice? URLs anyone?
George
On Fri, 13 Aug 2004 16:42:18 +0100, Alistair Davidson
<[EMAIL PROTECTED]> wrote:
> I've heard of similar things happening on queries where you use SELECT * (see http://www.1pixelout.net/index.cfm/blog/entry/cfqueryparam.htm )
>
> A
Thanks guys, Both of Barney's suggestions worked fine. And as for
what you were saying Dave, in thinking it over I can use the session
scope to do what I need and skip the dynamic naming entirely. Just
don't have that scope in use or even enabled in this particular app
and didn't want to start i
thanks
-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: Friday, August 13, 2004 12:44 PM
To: CF-Talk
Subject: RE: OT- Zip code question
http://www.pengoworks.com/workshop/js/gateway/index.cfm#downloads
Michael T. Tangorre
> -Original Message-
> From:
Hey Matt,
I'd do the following:
- Original Message -
From: Matt Robertson <[EMAIL PROTECTED]>
Date: Fri, 13 Aug 2004 11:06:53 -0700
Subject: Deleting a dynaically-named struct: Brain Freeze!
To: CF-Talk <[EMAIL PROTECTED]>
This can't be difficult, but I'm not getting
> I have a dynamically-named application-scope struct. I can
> create it just fine, and put stuff in it, but when I'm done I
> can't get the structdelete() syntax right. What am I doing
> wrong? Code below.
>
>
>
> ...
>
Well, it looks like you have two problems. The first is that StructD
how about structDelete(application, listRest(variables.myname, "."),
false) or structDelete(application, "mystruct_"&client.foo, false)?
cheers,
barneyb
On Fri, 13 Aug 2004 11:06:53 -0700, Matt Robertson
<[EMAIL PROTECTED]> wrote:
> This can't be difficult, but I'm not getting it this morning.
>
I assume you can set a hidden form field (intHeaderCount) for the number
of HEADLINE_ID fields on the form page.
#form['HEADLINEID_' & x]#
HTH,
Mike
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
You certainly do not need to do any of the below.
Items in the Form scope are treated like a structure. To get all the
fields, you can use structKeyList(). You can also use form.fieldnames,
a built in list of form fields.
To get the value, you use struct notation. Assume "key" is one form
field.
This can't be difficult, but I'm not getting it this morning.
I have a dynamically-named application-scope struct. I can create it
just fine, and put stuff in it, but when I'm done I can't get the
structdelete() syntax right. What am I doing wrong? Code below.
--
First off, on that page, make a hidden field, name it like num_heads, and give it the value of the number of headlineid forms.
Then on the action page, which I am sure you will be using a loop, you can access each of those forms. You will use the evaluate function to access the form variables.
http://www.pengoworks.com/workshop/js/gateway/index.cfm#downloads
Michael T. Tangorre
> -Original Message-
> From: Eric Creese [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 13, 2004 1:03 PM
> To: CF-Talk
> Subject: OT- Zip code question
>
> Does anyone know of a FREE list of zipcod
A quick question.
I have dynamic form fields like
HEADLINEID_1
HEADLINEID_2
HEADLINEID_3
HEADLINEID_4
how can I count those in the action page.
Also there are so many more fields are also getting submitted so, I can't use StructCount()
I need something like I can specify that count that mactched
Does anyone know of a FREE list of zipcodes that also has longitude and latitude information?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Dwayne,
I'm not sure how well it works for access, but I'd google for
"coldfusion datasource serviceFactory" - there are ways to create
datasources on the fly in CFMX.
-joe
- Original Message -
From: Dwayne Cole <[EMAIL PROTECTED]>
Date: Fri, 13 Aug 2004 12:15:01 -0400
Subject: DSN-Less
there will be around 100 records that need to be batch run every hour
its too get almost real time river flow data
-- Original Message --
From: "Mark W. Breneman" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Fri, 13 Aug 2004 11:57:24 -0500
>Will t
Will the task run manually?
If so how long does it take?
How many records / http requests are we looking at here?
Do we know that it is not just one http request that is causing the problem?
You could set up a task that would run and get the first record / http then
it would set up a s
Dear all
We are getting some weird behaviour on an Intranet which has been
working fine for 2 years. CF5 / WIN2K / IIS
It uses a fairly standard client variable setup, they are stored in a
DB. User logs in, is recognised, client variables are initialized Etc.
thru the CFID / CFTOKEN cookies.
what i have been using, timesout even when specifying a longer timeout
almost like it is trying too do them all at once instead of one at a time
-- Original Message --
From: Thomas Chiverton <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Fri, 13 Aug
The following code does not work for me. Can anyone tell me why?
I'm using DB_EMPTY as a pass through Database and I would like to add a table to a database that does not have a DSN set up. Apparently CFMX does not support DSN-less connection and MM suggested a using a pass through. Basically y
On Fri, 13 Aug 2004 10:42:29 -0400, S. Isaac Dealey <[EMAIL PROTECTED]> wrote:
> Thanks Dave, that's a great explanation, and not more info than I
> needed -- I hadn't even noticed that wasn't a regular chmod value when
> I googled it. But the explanation makes it all a lot clearer and will
> help
Jochem and Isaac have got it right. It's probably the reason Jochem
mentioned. When I took the cfqueryparam tags out, they worked fine.
Thanks guys!
George
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
I've heard of similar things happening on queries where you use SELECT * (see http://www.1pixelout.net/index.cfm/blog/entry/cfqueryparam.htm )
Are you using select * ?
If so, consider the error a slap on the wrist! ;)
Cheers,
Alistair
Alistair Davidson
Senior Technical Developer
Headshift.com
Smallint seems like an odd choice for an identity column... you might
try cf_sql_integer or try dropping the cfqueryparam tags and testing
it that way just to isolate the issue. You do want the cfqueryparam
tags, but if it works when you drop them, then you know it has
something to do with the chos
What is the best way to set up an index for a mixture of dynamic and static
pages?
Looks like vspider is the tool for this but unfortunately I don't have
access to the box.
Is it possible to run vspider remotely - not command line?
If not any thoughts on the best way to set up a search for a mixt
Thanks Dave, that's a great explanation, and not more info than I
needed -- I hadn't even noticed that wasn't a regular chmod value when
I googled it. But the explanation makes it all a lot clearer and will
help if I ever have to google it in the future. :)
> Since we tend to think in terms of per
Peter,
I will get rid of those pesky #'s. I learned CF from a book. and I did a lot of this scripting in the first few months of programming.
Bryan,
This is what I am trying to do.
1. This is for a registration for a conference. (1500+ registrants)
2. This part is for a hotel rooms for th
1 - 100 of 125 matches
Mail list logo
