Stick the complied class in web-inf\classes and createObject(java,
className) should instantiate it iirc.
One thing I've wondered about is how does CF handle a java class
compiled with a different JRE version that CF is running on top of
work? I assume this should be avoided...but I'm not sure.
Is anyone running this combination yet? Any problems?
--
jon
mailto:[EMAIL PROTECTED]
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
Web Services...
--
jon
mailto:[EMAIL PROTECTED]
Monday, July 7, 2003, 3:40:35 PM, you wrote:
GF Hi everybody,
GF Fairly new to CFMX, so sorry if this question is obvious, but I've been
GF slowly but surely pushing for the use of CFMX where I work, an insurance
GF company. I've been giving my
How does one remove a toolbar in Homesite+...I can't seem to uncheck
it in Tools/Customize.
--
jon
mailto:[EMAIL PROTECTED]
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
I don't know...this hs_plus52_updater.exe sitting in my download
folder I ran today would seem to be contrary to that notion ;)
That said...I've had the same experience. HS+ is much more stable on
my machine than Studio 5 was. Still crashes, just not every other day.
--
jon
mailto:[EMAIL
From what I know not being part of the beta, I've been thinking of
RedSky as CF v6.5.
--
jon
mailto:[EMAIL PROTECTED]
Wednesday, July 9, 2003, 3:42:25 PM, you wrote:
TW oh, cool. so its not a *MAJOR RELEASE* more of a consummate updater
TW with lots of bug fixes...?
TW tony weeg
TW
I looked at this method and all the others, and decided to go with
the non-traditional method outlined here.
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=7321lngWId=4
Much faster in just about every regard (except updating) than the
below method, and sorting is built in.
Wednesday, July 9, 2003, 5:13:02 PM, you wrote:
MR Jon Hall wrote:
I looked at this method and all the others, and decided to go
with the non-traditional method outlined here.
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?
txtCodeId=7321lngWId=4
MR Thats actually a fairly old idea
Wednesday, July 9, 2003, 5:50:33 PM, you wrote:
I speak not for this guy...except to say he sounds pretty
typical of the average VB dork's I run into.
MR I'll bet. I wasn't lumping you in with His Majesty's royal attitude. :D
MR Did you look at Michael Dinowitz' cf_maketree? He mentioned it
Just walk out the door, and come back in...sometimes the sensor
doesn't trip when it should. :)
Going to a different domain or ip will cause the cfid and cftoken
cookies not to be read, hence the session variables would be reset.
Other than that, a Wins or IP change by itself would not cause a
Obviously all you have to do is go to the server and turn the clock
back to when you know it was working then :)
Seriously...we can't help if we don't know any more info about what
exactly is failing. Session variables disappear for a lot of reasons.
--
jon
mailto:[EMAIL PROTECTED]
Thursday,
Just a warning if you haven't updated yet...we just had SP4 totally
hose a web server to the point IIS needs to be reinstalled. Most of
our sp4 updates have gone fine though.
Make sure you backup...
--
jon
mailto:[EMAIL PROTECTED]
This will do it...only available as a DW plugin though. I remember
just opening up the plugin and hacking out what I was interested in
though.
http://massimocorner.com/index.html?body$http://massimocorner.com/dw/behaviors.htm
It works using the fileSize attribute in IE4+ iirc.
img src=test.gif
I'm not sure using this would be the best idea for someone just
getting into css layouts, but it help get rid of a lot of the leg
work. At least it isn't a copy/paste solution.
http://www.fu2k.org/alex/css/layouts/3Col_NN4_FMFM.mhtml
--
jon
mailto:[EMAIL PROTECTED]
Sunday, July 13, 2003,
Why not have the function logic in the cfc as well?
mycfc.execute(url.function)
where execute() looks at the value pass, executes the necessary method
and returns back the result.
Maybe it's just me, but mycfc.#url.function#(); would seem to be the
antithesis of self-documenting...
--
jon
What is the js error you are getting? If you don't have Mozilla, I'd
highly recommend it, as it's js debugger is the best available.
Also have you tried replacing top.mainFrameSet.main with parent? For
what you are doing they should have the same effect. At least it would
get rid of a few
Surely this feature-rich monitoring tool lets you monitor ports 389
and 636 on your LDAP server?
--
jon
mailto:[EMAIL PROTECTED]
Tuesday, July 15, 2003, 8:49:59 AM, you wrote:
AC Hi,
AC I'm searching for a free LDAP monitoring utility/tool
AC or atleast a script. Basically I want to have an
If this is a high traffic site, or the query takes extraordinarily
long to execute, keep in mind the people hitting the site while the
query is recaching, and right after the server is restarted, etc. They
could get errors, bad data, or long delays...
I've got an app that does something similar
and deletions only happen in the BackOffice.
Very similar to my app, except with a PowerBuilder frontend located
halfway across the country.
JB Regards,
JB JB
JB jon hall wrote:
If this is a high traffic site, or the query takes extraordinarily
long to execute, keep in mind the people hitting the site
dtsrun /? is a good place to start, but here is the syntax to send a
dynamic parameter to the dts package.
dtsrun /SsqlServerName /NLoad pr_Labor Table /E /Apayrolldt:=dateString
/E is for trusted connection, otherwise you will need to supply
username and password in the command line.
--
jon
We have an MX install here that has been having a strange problem
connecting to SQL Server databases. When actually registering the
datasource...it takes about ~30 seconds before it actually succeeds.
The problem also shows up in apps running on the machine. There is a
huge delay in page
Anyone know if the 5.2 Homesite+ update broke the Imagemap editor?
None of the machines that have Homesite+ 5.2 will display the images
in the editor. This did work previously to the update according to
one of the guys here.
--
jon
mailto:[EMAIL PROTECTED]
xmlspy does this as well. Probably my favorite feature.
--
jon
mailto:[EMAIL PROTECTED]
Wednesday, July 16, 2003, 11:44:06 AM, you wrote:
TW thanks.
TW I have developer here who is working with that xml stuff, and was
TW wondering if my community as he calls it ... had any ideas ... thanks
?
--
jon
mailto:[EMAIL PROTECTED]
Wednesday, July 16, 2003, 12:39:35 PM, you wrote:
MT I believe they are waiting on a patent issue, so all previewing/displaying
MT of GIFs is currently not available in the current version of Homesite+
MT HTH
MT Mikey
MT -Original Message-
MT From: jon
I'm not sure cf-talk is the best place to ask this question...but I'd
love to be wrong here, because I would like to hear what a usability
expert has to say about this. Is there even a standard practice at
all?
Personally, I'd try the webdesign-l or the new boxesandarrows list.
Wednesday, July
I can relate fully. You would think that a coders tool would be the least
buggiest tool in your arsenal...but nooo
Studio 4.5 is so full of bugs I cant count them all.
Ultradev is not a replacement for Studio, it's nice in that it recognizes CF
tags and does not break anything. It's good for when
cfexit is what you are looking for
- Original Message -
From: "Kevin Miller" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 15, 2000 6:10 PM
Subject: CFABORT in Custom Tags
CFABORT seems to halt the flow of page processing even when used in custom
tags (called using
Err this database already exists...I call it a file system. What would you
dynamically change in an image? Changing the size of an image is already
possible via the img tag. Changing resolution on the fly would require
processing power that is way beyond capabilities today, not to mention the
missed that...yes cfabort stops all processing.
- Original Message -
From: "Kevin Miller" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 15, 2000 8:06 PM
Subject: Re: CFABORT in Custom Tags
CFEXIT will exit only the current custom tag. I am trying to verify
that
INPUT type="checkbox" name="RoleID" value="1"CFIF ListContains(RoleID, 1)
checked/CFIF
...
I am assuming you are storing the 'RoleID' value as a comma delimited list
in the database here.
- Original Message -
From: "sebastian palmigiani" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
I dont even know what you speak of. If I ever got away from my computer or
work I might. I did however try to find a Jon Hall kicker in the NFL on
espn.com :-) The only one I could find was a guy who played for the Jets,
but it doesn't appear he has played this year...anyway, since the Jets
The key is type="html"
cfmail to="" from="" subject="" type="HTML"
pre
This request was received through the website from:
#form.fname# #form.lname#
#form.company#
#form.address#
#form.city#,#form.state# #form.zip#
#form.phone#
#form.email#
#form.id#
/pre
/cfmail
Keep the easy ones
My solution to the original problem is to just use cfsets above the include.
cfset WebPage_ID = 20
cfset DID = 9
CFINCLUDE TEMPLATE="/acb/webpage.cfm"
jon
- Original Message -
From: "Homer Simpson" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, September 28, 2000
We recently ran into a problem where the database was so huge that pulling a
list box was too slow. The solution was to perform a query that wrote the
contents of the select box to a comma delimited file once a day. In this
case, it was much much faster to read the box from a file.
jon
-
This is a multi-part message in MIME format.
--=_NextPart_000_03AA_01C02A44.87489EC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Ok, maybe someone could point me in the right direction here. I am =
working with a database with 750,000
sKeyWords, and maybe ProductsStyleNumber). If you haven't
already tried it, you might experiment with normalizng these... let
the db engine do its thing. (you might be surprised by the results)
HTH
Dick
At 6:38 PM -0400 9/29/00, Jon Hall wrote:
This is a multi-part me
This is a multi-part message in MIME format.
--=_NextPart_000_036A_01C02F0E.BE3F4900
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I am playing around with arrays for the first time and I get this error =
when I try to initialize an array
Ah
I see now. The ArrayNew function expects a number of dimensions, NOT columns
as I was trying to do.
Thank You
- Original Message -
From: "Jim McAtee" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, October 05, 2000 10:53 PM
Subject: Re: CF Arrays question
I
This is a multi-part message in MIME format.
--=_NextPart_000_03C2_01C02F3E.4206BEB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I am trying to populate an array from a query and I am running into =
problems...
From what I have infered
dont know why my query got all garbled but I hope this looks better
cfif application.queryStatus IS 1
cfquery datasource="#productdsn#" name="PriceBreaksQuery" dbtype="ODBC"
SELECT *
FROM Pricing
/cfquery
cfset pricebreaks = ArrayNew(2)
cfloop query="PriceBreaksQuery"
cfquery
Thank you Jim! You realize though that you have said Ben Forta is wrong...I
wouldn't be standing in the middle of any fields during a thunderstorm if I
were you. :-)
jon
- Original Message -
From: "Jim McAtee" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, October 06,
try here
http://wordlist.sourceforge.net/
jon
- Original Message -
From: "Nick Baker" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, October 06, 2000 11:39 PM
Subject: Need electronic list of words
Hey Folks,
I am in need an electronic list of words found in English
I may be mistaken, but I dont think this can be done within a cfinput only
an input. I was trying to do the same on a text box recently and had to
use regular input's
jon
- Original Message -
From: "Hayes, David" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, October 09,
I do not think that a person spoffing their ip would be able to surf the
web, at least normally. That's not the purpose of spoffing your ip anyway. I
have also never heard of a way to spoof an ip on a windows machine if that
helps you any.
Do a search on ip spoofing at your favorite search
I second the Red Bull suggestion...although I have to look up Pro Plus. The
only problem is 5 Red Bulls cost $10 around here...that's minimum after 24
hours.
jon
- Original Message -
From: "Mark Skeggs" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, October 10, 2000
I am kind of confused since the question seems to be asking why doesn't
orange juice come out of my apple...
If the user is not running an ftp server, you will not be able to ftp to
them. Much better to just include a link in the same page to the generated
file. That would let them download the
Look at your #HTTP_HOST# variable...
jon
- Original Message -
From: "Craig Newitt" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, October 10, 2000 7:36 PM
Subject: RE: pointing different domain names to different sub directories on
the one server
Yes you can
Mark look at you #HTTP_HOST# variable, that should help you out.
On a side note make sure you have debugging on the CF server set on for your
ip.
jon
- Original Message -
From: "Mark Lapole" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, October 11, 2000 11:17 AM
cffile does note like Macs. I'm not sure if this is your problem and I wont
reiterate the specifics since it's probably been beat to a horse here in the
past.
I do not know of a fix that enables cffile to work with a mac. If anyone
does I'd be interested.
jon
- Original Message -
From:
Brian you get my nomination for most humorous post of the day!
jon
- Original Message -
From: "Brian bouldernet" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, October 11, 2000 4:17 PM
Subject: Re: CF 5.0???
Birthday Suits I hope.
My serial is EVALUATION..
The absolute easiest way to solve this problem would be to make the option
value a comma delimited list as follows:
select name="Region"
option value="[EMAIL PROTECTED],Africa" selectedAfrica/option
option mailto:value="[EMAIL PROTECTED],Asia amp; Pacific"Asia amp;
Kevin, Why not have the web site make some random folders like:
http://www.yoursite.com/software/sd332wcdf/er23232/mystuff.zip
then copy the sofware to the folder, then you could direct the customer to
click on a link to download the software immediatedly, after the download
completes remove the
That is not the only hole you will find when multiple CF sites are hosted on
the same server. Although, most hackers are not paying customers, so this
usually is not a problem.
If you are that sensitive about security, you should have a dedicated web
server.
Although I would like to see a
This is a multi-part message in MIME format.
--=_NextPart_000_0011_01C03731.8F6351F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Anyone know how I can get a list of all URL variables?
I know the #query_string# variable gives all the
-
From: "Steve Martin" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, October 16, 2000 5:36 AM
Subject: RE: url variables
StructKeyList(URL)
Steve
-Original Message-----
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 16, 2000
tructKeyList(URL)
Steve
-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 16, 2000 10:26
To: CF-Talk
Subject: url variables
This is a multi-part message in MIME format.
--=_NextPart_000_0011_01C03731.8F6351F0
Content-Type: tex
I gotta nominate Pan...while he doesn't post much. He is da man.
jon
- Original Message -
From: "Adam Phillip Churvis" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, October 17, 2000 6:44 PM
Subject: CF_MENSCH Awards
FusionFolks,
I would like to propose an annual
I dont have an answer for you, but you question piqued my curiosity also. I
couldn't find anything about what wish is, but I did find another program
that may be helpful for testing. Basically is is a local browser proxy that
lets you control everything that is sent and received when you are on a
Just wanted to comment to this older thread...
I was just looking over some stats from a consumer oriented non ecommerce
site that has been hitting 3.5 million hits+ per day for the past few
weeks, and Gecko based browsers are more popular than NS4 for the
first time. Not by a small margin
You may already know these, but these are the refs I use. I'd use the
msdn site, but the frames really get on my nerves sometimes :)
http://www.w3.org/DOM/
http://www.mozilla.org/docs/dom/domref/
http://www.devguru.com/Technologies/ecmascript/quickref/javascript_intro.html
and a good links
I'll believe it when I see it. Anyway, if Microsoft has you in their
sights...you know you have to be doing something right.
Of course, Microsoft isn't allowed to distribute any Java technology
without making nice with Sun, because of the lawsuit, and we all know
that isn't going to happen.
So if
Hey, how about just getting them to stop detecting Gecko based
browsers as Netscape 4 on the dev exchange? They already did it for
the rest of the macromedia.com site...It's impossible to read the
text.
The untapped potential of the dev exchange is incredible really. I'd
turn it into a
Tuesday, December 24, 2002, 4:01:14 AM, you wrote:
That's gives a little background about the two types of JVMs. As far as
performance, you might find this link interesting:
http://www.javaworld.com/javaworld/jw-12-1997/jw-12-volanomark.html
PH interesting? geez thats darned shocking. ms's
Does a free one of these exist? I faintly remember the topic coming
up in the past, but my searches are coming up empty.
I did find this one for $99.
http://www.netwebapps.com/Products/speedDB/introduction.cfm
--
jon
mailto:[EMAIL PROTECTED]
Churvis
AC Advanced Intensive ColdFusion MX Training
AC http://www.ColdFusionTraining.com
AC E-mail: [EMAIL PROTECTED]
AC Phone: 770-446-8866
AC Team Macromedia Volunteer for ColdFusion
AC http://www.macromedia.com/support/forums/team_macromedia/
AC - Original Message -
AC From: jon hall
My sentiments exactly. Other than the session variable issue,
extensive use of subquery's to pull up those little counts of
messages, and dare I say, looping over select query's, absolutely
kills performance once it gets big enough.
We (or one of clients to be specific) have the dev edition as
MSSQL's Query Analyzer and DBArtisan both have functionality that will
generate INSERT statements from a table. Saves a ton of time, I would
hate to have to write every insert from scratch...
I'm sure one of the MySQL frontends does something similar.
--
jon
mailto:[EMAIL PROTECTED]
Friday,
Only in IE because of it's support for the click() method on anything.
You have to create a hidden input type file, and a normal button and
textbox...
input type=file name=nameFile onchange=this.form.nameText.value=this.value
style=display:none;
input type=button name=nameButton value=Browse
I assume you mean to a different server, if same server just use
enterprise manager wizard.
First Step - get database name:
restore filelistonly
from disk = 'c:\backup.bak'
Second Step:
restore database dbname
from disk = 'c:\backup.bak'
with move 'dbname_Data' to 'C:\Program Files\Microsoft SQL
I hadn't extended it to the page context, but I do something similar
for my customer object. I have a structure called 'contextInfo' that is
sort of a dumping grounds for any information that applies to the
customer for a page or two only.
Extending the idea to the page context would seem like a
How about calling the UDF with an extra parameter only when you do the
recursive call? Then test the length of the arguments array to see if
the function was called by itself or from outside?
--
jon
mailto:[EMAIL PROTECTED]
Monday, January 6, 2003, 9:17:31 AM, you wrote:
TS Is there a way to
Depending on the version of CF and OS, different ways would be
preferable. Assuming they haven't disabled cfobject though, using the
Scripting.FileSystemObject (GetFile() or OpenTextFile()), or
java.io.FileReader will both work.
http://java.sun.com/j2se/1.4/docs/api/java/io/FileReader.html
It uses the KHTML rendering engine, which appears in my professional
opinion...to suck. Luckily it looks like they also are apparently
spoofing the browser by default (as NS5), so it will never show up in
server logs, and we can safely pretend it doesn't exist.
, rewrote much of it, and
DA are publishing their rewrite as open-source.
DA They did the same thing with parts of the JVM.
DA So, everyone (potentially) benefits.
DA Dick
DA On Tuesday, January 7, 2003, at 12:25 PM, jon hall wrote:
It uses the KHTML rendering engine, which appears in my
I did the same thing not to long ago, importing emails from an ACT
exported list. I ended up using reading the uploaded file via an ODBC
Text DSN. This lets the ODBC driver handle any corrupted data, and
turns the csv into a query automagically.
All I did was manually create a ODBC Text DSN to get
Unless you really want this in custom tag format, I'd suggest using
this one. It's got a lot of nice helper functions, is well written js,
and is free.
http://www.mattkruse.com/javascript/optiontransfer/
--
jon
mailto:[EMAIL PROTECTED]
Wednesday, January 8, 2003, 12:45:05 PM, you wrote:
CM
I have a set of db inserts involving two datasources and if there is
a failure in the 2nd datasource, I need to roll back the transaction
on the first datasource.
In a perfect world I could somehow hold up the first transaction
commit until the transaction on the second datasource has
Yeah, that's actually what I am doing, if the first fails, no need to
do the second one at all. The problem lies in that when the second query
fails, I need to roll back the first.
--
jon
mailto:[EMAIL PROTECTED]
Thursday, January 9, 2003, 3:27:33 PM, you wrote:
MA According to Mastering
Just had a thought...if cfobject is disabled, you could try getting
the more command via cfexecute to read a text file too...
--
jon
mailto:[EMAIL PROTECTED]
Tuesday, January 7, 2003, 4:57:00 AM, you wrote:
RB I can use CFExecute on my host. But the file I create I need to read it
RB into a
Formatted an MBR? Not really applicable...no place for a filesystem
that i know of in the MBR. fdisk /mbr might be what you are looking
for though, if you want to avoid reformatting.
Otherwise, if you have already formatted everything, fdisk is good at
wiping all traces of anything out :)
--
Wednesday, January 15, 2003, 4:26:21 PM, you wrote:
IL Hi all,
IL We've got a server that's suddenly become very cranky - running slowly,
IL hanging, etc. 3-4 times per day.
When you say hanging, do you mean the CF process, or the entire
machine? If the entire machine is locking, then it's
I believe you may be getting the scopes confused. Cached querys are
for most intents and purposes stored in some place equivalent to the
application scope. Your query also suggests that the information being
pulled is specific to the application, not the user (session). If
there is not any
a href=javascript:void(0) onclick=submitHandler(0)Submit/a
submitHandler(formNumber) {
formObj = document.forms[formNumber];
formObj.submit();
}
Pass the form number in the link...the first form on the page will be
form 0, the second form 1, etc..
--
jon
mailto:[EMAIL PROTECTED]
Yes :)
cfquery looks at the actual sql string (and the cfquery parameters) to
decide whether or not to look at the cache, or make a connection to
the database, not just the name.
--
jon
mailto:[EMAIL PROTECTED]
Thursday, January 16, 2003, 5:27:15 PM, you wrote:
JM So if I understand that
Thursday, January 16, 2003, 6:16:27 PM, you wrote:
ps (Narrowly) I think the answer might actually be NO, because you specified
ps the values below :)
Unless I am misunderstanding what you are saying, the answer no, would
be incorrect.
Query caching does not make any distinction based upon
http://www.macromedia.com/desdev/topics/xml.html
This by one by Nate Weiss is pretty much a walk-through. It starts from
the beginning, and includes code samples.
http://www.macromedia.com/desdev/mx/coldfusion/articles/xmlxslt.pdf
--
jon
mailto:[EMAIL PROTECTED]
Sunday, January 19, 2003,
Not books, but here are some great blogs for more tangible learning.
Books have to stay pretty theorhetical since the technology and
prevailing in style of the web are changing so much. You can pretty much
follow the links on these three to most of the UI resources on the
web.
Look up the cfsavecontent tag. It's exactly what you need.
Just be aware that cfhttpparam automatically urlencodes all values.
Your partner will have to urldecode before they can parse the xml.
--
jon
mailto:[EMAIL PROTECTED]
Wednesday, January 22, 2003, 11:43:12 AM, you wrote:
MF I am
This js lib does it.
http://webfx.eae.net/dhtml/combobox/combobox.htm
I'm not to big a fan of that one though, it has some browser issues.
Personally I'd take an existing combobox script and combine it with a
type ahead script.
Like these...
http://www.oztek.net/jon/combobox.htm
On CF5, I'm getting this error on random pages at random times. The
queries have nothing in common other than they connect to the same
datasource.
However I am starting to get it fairly (1-2 times a day, and
today 3 times) consistently now as load starts to climb on a new app.
Anyone
Thanks for your replies, it's good to know I'm not alone at
least...I'm kind of tempted to call Macromedia Support, as there is no
mention of the error anywhere on the Macr site, or even on Google.
I'm a bit scared I will end up explaining the same thing 10 times
before I get to someone who tells
Anyone want to take a shot at why this query throws a PCCode error
every once in a while? CF5...
cftry
cfquery name=qry_prod datasource=#variables.dsn# cachedafter=01/01/01
select *, lower(keywords) as l_keywords
from v_products
where WebStoreID = #request.webStoreID#
/cfquery
cfcatch
With all the work you've put into this solution, I hate to even say
this, but may I suggest a better way, that will should a lot of headaches?
Create a ODBC Text Datasource to the file one the machine and then
just use cfquery to turn it into a query...which you can loop over or
whatever else you
, the schema.ini will be automatically
created in the directory you selected.
--
jon
mailto:[EMAIL PROTECTED]
Wednesday, January 29, 2003, 6:36:38 PM, you wrote:
AO Jon,
AO what does a sample INI look like?
AO Andy
AO -Original Message-
AO From: jon hall [mailto:[EMAIL PROTECTED]]
AO Sent
By editing the schema.ini file you can add a text datasource with CF's
ini file functions. That way you can dynamically add dsn's when the
end user uploads the file. Take a look at the format of the schema.ini
file that is created, it's pretty straightforward.
The fact that these files are very
Any chance of cfc's implementing built in set/get methods on
properties, like c# and the javabean framework?
--
jon
mailto:[EMAIL PROTECTED]
Thursday, January 30, 2003, 12:19:23 PM, you wrote:
SAC On Thursday, Jan 30, 2003, at 07:17 US/Pacific, webguy wrote:
Look at Seans excellent rules ..
No they wont. Query caching takes more than the query name into account.
Think of the sql string and the cfquery parameters as a
hash that CF uses to look up to see if the query is in it's cache. If
the parameters _and_ the string match exactly then the query will be
pulled from cache, otherwise
cfif NOT getProduct CONTAINS FOR
--
jon
mailto:[EMAIL PROTECTED]
Monday, February 3, 2003, 3:11:41 PM, you wrote:
RAB I need to verify if a field does NOT contain FOR ... I have tried
RAB CFIF #ProductDesc# IS NOT LIKE FOR FREE GIFT/CFIF
RAB and
RAB CFIF #GetProduct# NOT CONTAINS FOR FREE
!---
First go to Tools - Options - click on Hidden Objects and System
Objects, then go back to Tools - Security - User and Group permissions -
highlight the MSSysObjects table and then check the Read Data check box,
then click OK..
---
cfquery datasource=#dsn# name=GetTables
SELECT name
FROM
Yeah that's my thought as well, take a look at your web logs and see if
someone was playing around with putting SQL in the URL...
--
jon
mailto:[EMAIL PROTECTED]
Tuesday, February 4, 2003, 5:30:27 PM, you wrote:
RS Are you type checking the variables that get passed into your queries?
RS If
901 - 1000 of 1373 matches
Mail list logo