On 5/20/05, Jeff [EMAIL PROTECTED] wrote:
I downloaded the CFMX 7 installer (don't even have CFMX 6 installed, it's a
new computer) and it kept asking me to choose another location to extract
the installer to.
Your installer is corrupt. Download it again. I nearly ripped all my
hair out over
Help! This keeps failing after the first 25 records are displayed and it
shows all records in the database 25 at a time not just the ones queried
originally by say company_name. Anyone know why?
cfset todayDate = Now()
!--- query the EmployeeDirectory table. Cache the result set for 15
Joshua,
I also encountered this problem when I tried to execute a Java-based Hello
world! in my CF app for the very first time (which was about 3 days ago). I
solved it by configuring CFIDE so that it would point to the directory where my
*.jar file resided.
In CFIDE, simply navigate to
Ray
In my search I was just doing a cfdump var=#custom2#. However when
I removed this the search was returning no results? When it should have
?
Here is the code for the search results page, can you find anything that
may be causing this problem??
As I said before, if I remove
and CF_CUSTOM2
I'm confused. I thought you said the search was working now - since
you added quotes around the part for custom2. I thought it was working
but you just had a bug with the cfdump?
On 5/20/05, Ian Vaughan [EMAIL PROTECTED] wrote:
Ray
In my search I was just doing a cfdump var=#custom2#.
Your installer is corrupt. Download it again. I nearly ripped all my hair
out over that one - and I have a LOT of hair :)
I think so too, I've downloaded it twice so far.
I have a question...how do you verify the MD5 Checksum value?
It turns out it was probably an explicit garbage collection call from one of
the applications. As soon as I disabled the ability to explicitly call a GC
(just let the JVM manage its own memory) the GC dropped to once an hour on an
idle server.
Much better.
thanks,
Chris Norloff
--
Nope even with the quotes shown in the results page I sent in the last
post, the search is returning no results ? .
What is strange though is if I remove the
and CF_CUSTOM2 IN #session.groupname#
The search brings back all matched results, and if I run a cfdump it
shows that the custom2 field
It might be useful to determine your business needs as opposite to what
features developers want to play with. If you have no use for the
additional features in your project(s) it might be a decision based on
emotions instead of rational arguments and the extra investment might
never pay itself
Your installer is corrupt. Download it again. I nearly ripped all my
hair
out over that one - and I have a LOT of hair :)
I think so too, I've downloaded it twice so far.
I have a question...how do you verify the MD5 Checksum value?
Use md5sum: http://www.etree.org/md5com.html .
--
mack
Ah, this looks great. I'll suggest the steps. I'm pretty sure I get it all.
Thanks a bunch (again) Deanna. I owe you at least a beer.
Been there, had that client. You do still need to keep in mind things like
whether or not a record is complete if they haven't filled everything in,
when
http://tinyurl.com/
www.antiwrap.com
http://houseoffusion.com/tinyurl.cfm
Or there's a version I wrote a little while ago:
http://short.badpen.com/
There's a download for source there and it includes both a PHP and a CF
version.
Tim.
--
Sorry for the off-topic, but I have been beating on this one for a while and
the only answer I can find is really, really ugly. So, hopefully somebody
knows more about queries that I do and can show me the error of my ways
I have a table that looks something like this
crID
I have had a problem recently which results in a base tables have
changed error message.
This stems from a batch file that I run each night that copies a bunch
of database files from an application on another server to my webserver.
The dilemma is that every once in a while, as the error message
Hi, I have an SP that I want to call correctly. I can simply do:
exec sp_autotags @PINNumber = #attributes.PIN# within a cfquery tag and it
executes fine. But when I try using cfstoredproc/procparam I get errors. I
wasn't able to decipher the documentation on the tags. Here's what I'm trying:
Oh, the error is:
[Microsoft][ODBC SQL Server Driver][SQL Server]Procedure 'qry_autotags3'
expects parameter '@PINNumber', which was not supplied.
Hi, I have an SP that I want to call correctly. I can simply do:
exec sp_autotags @PINNumber = #attributes.PIN# within a cfquery tag
and it
Try this
cfprocparam type=In cfsqltype= CF_SQL_VARCHAR dbvarname=@PINNumber
value=#arguments.PIN# null=No
Instead
Kevin Penny,
Hotgigs.com
-Original Message-
From: G L [mailto:[EMAIL PROTECTED]
Sent: Friday, May 20, 2005 9:05 AM
To: CF-Talk
Subject: CFPROCPARAM Help Needed
Hi, I
'Variable' attribute is only needed/used when you have a retun/OUT/INOUT
value that you need to reference through cfusion.
Kevin Penny,
HotGigs.com
-Original Message-
From: G L [mailto:[EMAIL PROTECTED]
Sent: Friday, May 20, 2005 9:11 AM
To: CF-Talk
Subject: CFPROCPARAM Help Needed
Oh,
Claremont, Timothy wrote:
This stems from a batch file that I run each night that copies a bunch
of database files from an application on another server to my webserver.
The dilemma is that every once in a while, as the error message implies,
the base tables have chnaged due to improvements
select t.* from test t where t.actid in
(SELECT MAX(t2.actID) FROM test t2 where t2.crID = t.crID)
ought to work...
s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://www.fusiontap.com
Nope, still the same error. You meant attributes.PIN right?
Try this
cfprocparam type=In cfsqltype= CF_SQL_VARCHAR dbvarname=@PINNumber
value=#arguments.PIN# null=No
Instead
Kevin Penny,
Hotgigs.com
-Original Message-
From: G L [mailto:[EMAIL PROTECTED]
Sent: Friday, May 20, 2005
Hi, I have an SP that I want to call correctly. I can
simply do:
exec sp_autotags @PINNumber = #attributes.PIN# within a
cfquery tag and it executes fine. But when I try using
cfstoredproc/procparam I get errors. I wasn't able to
decipher the documentation on the tags. Here's what I'm
Oh, the error is:
[Microsoft][ODBC SQL Server Driver][SQL Server]Procedure
'qry_autotags3' expects parameter '@PINNumber', which was
not supplied.
Oh nevermind re: oracle... I'm having a slow morning apparently. :)
missed that this was sql server.
s. isaac dealey 954.522.6080
new epoch :
Try this
cfprocparam type=In cfsqltype= CF_SQL_VARCHAR
dbvarname=@PINNumber value=#arguments.PIN# null=No
The DBVARNAME attribute has been deprecated since CFMX 6, and is ignored by
CF.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest
Your problem is your query.
Every time this page is called it is calling the query every time. So you
need to either push the query into session var, and pull the records out 25
at a time or re write the query to pull 25 records out at a time.
Both have their pitfalls, session if any new records
Hi, I have an SP that I want to call correctly. I can simply do:
exec sp_autotags @PINNumber = #attributes.PIN# within a
cfquery tag and it executes fine. But when I try using
cfstoredproc/procparam I get errors. I wasn't able to
decipher the documentation on the tags. Here's what I'm
There is only one parameter for the sp. Just a simple search query returning a
resultset. (MSSQL). It is declared in the proc as char(11). I'm not sure why it
works in the cfquery call without quotes. The proc must treat it as a string
regardless until the datatype is declared. Why should this
Ah yes good catch - I still do mine with dbvarname - but I have the
arguments in order -
Yes G L correct - I meant attributes - (I always use these calls in a cfc -
therefore I use arguments)
Whatever scope your variable that you need to reference is in -
Kevin
-Original Message-
Oh, I didn't mention it's CF5. I don't really understand what the dbvarname
or variable parameters mean, can anyone explain? I just need to pass a simple
string var to the proc which does a search.
Hi, I have an SP that I want to call correctly. I can simply do:
Does your stored procedure
Jeff Chastain wrote:
I have a table that looks something like this
crIDactIDdescriptionowner
1 1Test 444
1 2Test Update124
2 1Test 578
Now, what I need is a listing of all distinct
Use 'variable' only when you want to reference a value that is returned from
the query - from your sql server through an out/INOUT specificatoin (for
this case you won't need it at all)
Use dbvarname when you wish to match up the database variable with the value
you are passing in - sort of like
try cf_sql_char -- you get similar errors when you try to pass
something other than a date into a date parameter -- I would hope that
varchar would work for char as well, but I'm grasping at straws at
this point. :)
There is only one parameter for the sp. Just a simple
search query returning a
Seems obvious, but make sure you download to a drive with plenty of room.
Even if you have just enough space, I've seen issues like this since it's
not quite enough.
-Original Message-
From: Jeff [mailto:[EMAIL PROTECTED]
Sent: Friday, May 20, 2005 4:39 AM
To: CF-Talk
Subject: RE: CFMX
On 5/20/05, Chris Norloff [EMAIL PROTECTED] wrote:
It turns out it was probably an explicit garbage collection call from one of
the applications. As soon as I disabled the ability to explicitly call a GC
(just let the JVM manage its own memory) the GC dropped to once an hour on an
idle
Use md5sum: http://www.etree.org/md5com.html .
Thanks tons!
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with
I knew there was any easier way to do this.
Thanks
-- Jeff
From: S. Isaac Dealey [EMAIL PROTECTED]
Sent: Friday, May 20, 2005 9:16 AM
To: CF-Talk cf-talk@houseoffusion.com
Subject: Re: OT: SQL Query Question
select t.* from test t where t.actid in
DBVarName doesn't sound right either then, because I'm not trying to
match anything in the database. Just trying to pass a variable which
is declared in the sp. The variable I declare doesn't have to be the
same as any column name in the db.
Here's the sp:
CREATE PROCEDURE dbo.qry_autotags3
This is what I use all the time for my procs and I've never had a Problem -
as long as the inputs match up - you should be ok - and as you're only
passing in a single input - I don't see why this won't work
cfstoredproc procedure=qry_autotags3
datasource=#application.ivrdsnsearch#
As it is cf5 - you can ignore the depreciation comments -
Except that if they plan to upgrade ever, it will be easier if they
don't rely on dbvarname sooner than later... In this case it won't
matter because the sp only has one parameter, just saying. :)
s. isaac dealey 954.522.6080
new
Welcome... I'm sure Jochem's works well too -- assuming the db
supports a natural join on an aliased sub-query ... I honestly had
never seen that before, so I have no idea what the support for it is
like with various db's. But it did peak my curiosity. :)
I knew there was any easier way to do
Good point - eventually you may look at this - but I'm using cf6 and cf7
with no issues on this - it will be 'ignored' more than it would be errand.
Kevin
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Friday, May 20, 2005 10:21 AM
To: CF-Talk
Subject: RE:
Hi All,
I'm trying to use js inside an html file to include an asp file. This
is what I have so far:
script language=JavaScript type=text/javascript
// must be a fully qualified URL -- can be any type of file
(html,jsp,asp,etc)
I've noticed we have been getting a lot of these errors in our logs
recently. I've googled around a little but don't know where to start
looking. Is it more of a sql problem ? We are running MX7.
05/20 08:55:30 Information [jrpp-549] - [Microsoft][SQLServer 2000
Driver for
That depends entirely on how much you actually relied on the dbvarname
attribute. If most of your procedures have only one argument or you
nearly always provide your cfprocparam arguments in the same order
they're declared in the procedure script, you're right. On the other
hand if you have a lot
Yes - I found that by ordering them correctly - AND specifying the dbvarname
- it actually worked as a code commenter more than anything for me - as I
knew w/o having to strain through the code which value was being specified
for what param -
The @var stood out more than all the #var#'s that are
Did you try CONTAINS as well?
On 5/20/05, Ian Vaughan [EMAIL PROTECTED] wrote:
Nope even with the quotes shown in the results page I sent in the last
post, the search is returning no results ? .
What is strange though is if I remove the
and CF_CUSTOM2 IN #session.groupname#
It's admittedly very good (if not best) practice. Sounds like you're
doing the same sort of thing with your CFC methods that I used to do
with custom-tags. Convenient to be able to call them using a structure
-- the form scope for instance -- so if you just set all your form
fields to match the
DBVarName doesn't sound right either then, because I'm not
trying to
match anything in the database. Just trying to pass a
variable which
is declared in the sp. The variable I declare doesn't have
to be the
same as any column name in the db.
Yes... though that's not what dbvarname was
Hi All,
I'm trying to use js inside an html file to include an asp
file. This
is what I have so far:
script language=JavaScript type=text/javascript
// must be a fully qualified URL -- can be any
type of file
(html,jsp,asp,etc)
DBVarName doesn't sound right either then, because I'm not
trying to match anything in the database. Just trying to pass
a variable which is declared in the sp. The variable I declare
doesn't have to be the same as any column name in the db.
Yes... though that's not what dbvarname was
Seems obvious, but make sure you download to a drive with
plenty of room. Even if you have just enough space, I've
seen issues like this since it's not quite enough.
In the same vein, even if you're downloading to a partition with enough
room, if your downloading client uses your temp
DBVarName doesn't sound right either then, because I'm
not
trying to match anything in the database. Just trying
to pass
a variable which is declared in the sp. The variable I
declare
doesn't have to be the same as any column name in the
db.
Yes... though that's not what
Jeez! The /cfstoredproc tag fixed it. My Homesite + 5.5 doesn't seem
to think cfstoredproc needs a closing tag. Grr.
On 5/20/05, G L [EMAIL PROTECTED] wrote:
DBVarName doesn't sound right either then, because I'm not trying to
match anything in the database. Just trying to pass a variable which
Most probably the error occurs because no any forms are included in
the document at a stage you are trying to use their values.
Seems you are trying to use it in the very beginning in a HEAD
section while document.forms will be ready to use on page load.
TD Hi All,
TD I'm trying to use js
Yeah, I was responding to Kevin saying Use dbvarname when you wish to
match up the database variable with the value you are passing in -
sort of like a name/value pair @xyz = #url.xyz# etc.
It sounded like he was saying the dbvarname had something to do with a
column name in the db.
On 5/20/05,
Right no - they match up with your input parameters of your sproc
I saw that you didn't have the ending cfstoredproc in your example - but
just assumed -
Never assume! I figured the code snippet would work either way -
Kevin Penny, MMCP
www.hotgigs.com
-Original Message-
From: G L
You might try CONTAINS on a field you know is standard and populated
and where you know what the data looks like (to get the syntax down)
like TITLE
On 5/20/05, Raymond Camden [EMAIL PROTECTED] wrote:
Did you try CONTAINS as well?
Is that what the problem was? ... I didn't think cfstoredproc worked
without the closing tag... shows what I know. :) Don't feel too bad,
we both made essentially the same assumption.
Right no - they match up with your input parameters of
your sproc
I saw that you didn't have the ending
We are having trouble changing the details of a scheduled task in CF7
administrator.
We have some existing scheduled tasks that were migrated from CF6.1 and are
working, but when we have tried to set up a new one or amend the details of
an existing one, or even just submit on an existing one
Jeez! The /cfstoredproc tag fixed it. My Homesite + 5.5
doesn't seem
to think cfstoredproc needs a closing tag. Grr.
Well if it threw the missing parameter error, then technically it
doesn't need it... but only if your stored procedure doesn't have any
arguments... So what's happening is it's
Has anybody had an issue where debug information would not display in a
multiple instance setup of CF7.
We have one server where all the instances are not showing the debug
information.
Thanks
Kevin
~|
Logware
Thx.. I changed the script to
script language=JavaScript
src=http://192.200.1.37/Voyager50/Forms/LateCount.asp?tenant=+document
..Resident.HTENANT.value);/script
All is fine now...
Thx for your help!
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Friday, May
Hi all, i hope you're having a great Friday. I'm working on a CF6.1 website
that generates a substantial number of exceptions. In order to handle those
errors in an effective way, i'm considering turning on Robust Exception
Information. However, the production server is known to have performance
I've never heard anyone say it adds anything. This option is only
meaningful when an exception is thrown.
Now, if on the other hand you are showing all page execution info on
every page request, then *that* adds a lot of processing time, but
thats a whole different animal.
Consider implementing
Any recommendations on DB software much less expensive then Erwin?
Andy
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
I have been using a program called DeZign with pretty good success. If you
want to import an existing database model you have to buy their importing
tool as well. Both put together in cost are not a huge amount of money
though.
On 5/20/05, Andy Ousterhout [EMAIL PROTECTED] wrote:
Any
Visio
Michael T. Tangorre
-Original Message-
From: Andy Ousterhout [mailto:[EMAIL PROTECTED]
Sent: Friday, May 20, 2005 3:46 PM
To: CF-Talk
Subject: DB Design, Engineering Re-Engineering Software
Any recommendations on DB software much less expensive then Erwin?
Andy
Will Visio build all the SQL scripts needed to build the DB? If so, will it
do it for databases other than MSSQL?
On 5/20/05, Michael T. Tangorre [EMAIL PROTECTED] wrote:
Visio
Michael T. Tangorre
~|
Find
I was wondering if anyone had any experience with sessions dropping
unexpectedly on CF5.
I have an application that runs fine when I test it from several different
browsers, but once in a while when a client tries the app throws an error
that it can't find a specific session variable. This
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Leonardo Augusto CRESPO - Gmail wrote:
Hi all, i hope you're having a great Friday. I'm working on a CF6.1 website
that generates a substantial number of exceptions. In order to handle those
errors in an effective way, i'm considering turning on
Haven't gotten around to actually trying it, but DDS-Lite looks good:
http://www.dds-lite.com/
Interesting bullets from their feature list:
---
- Enhanced Entity Relationship Diagram modeling allows you to design a fully
relational database, complete with Cascading
That one sounds nice, the only bad thing about it is all of our data models
need triggers here so would have to get the more expensive one for that. Not
really a terrible thing since would want to do the views and SPs from time
to time anyway.
On 5/20/05, Dave Merrill [EMAIL PROTECTED] wrote:
Hi all, i hope you're having a great Friday. I'm working on a
CF6.1 website that generates a substantial number of exceptions.
In order to handle those errors in an effective way, i'm considering
turning on Robust Exception Information. However, the production
server is known to have
That said, I would strongly recommend that instead of
enabling this option, you handle errors and exceptions
appropriately. Showing users a verbose error message
is not appropriate. CF provides a panoply of error
handling functionality, from exception handling within
your code to the CFERROR
You should really only have robust exception
information on on a development server.
I think you might be thinking about debugging.
s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
I use dbdesigner by fabforce
Fabforce.net
Open source project ;)
Pat
-Original Message-
From: Dave Merrill [mailto:[EMAIL PROTECTED]
Sent: May 20, 2005 16:40
To: CF-Talk
Subject: RE: DB Design, Engineering Re-Engineering Software
Haven't gotten around to actually trying it, but
I am completing the integration of a payment processora and the processor
requires me to convert a string to SHA1 then to BASE64. I used a SHA1 UDF
script from Cflib.org for the conversion but in comparison to the string
created by the dotnet SHA1CryptoServiceProvider its different.
I am
You should really only have robust exception
information on on a development server.
I think you might be thinking about debugging.
Neither should be enabled on a production server.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber
I've got VISIO, imports, but won't create DDL's in any of the stand-alone
versions.
-Original Message-
From: Michael T. Tangorre
Visio
-Original Message-
From: Andy Ousterhout
Any recommendations on DB software much less expensive then Erwin?
Andy
Yeah, I would say Visio. (I personally use ER/Studio, but it is a bit
pricy, too.)
M!ke
-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Friday, May 20, 2005 2:49 PM
To: CF-Talk
Subject: RE: DB Design, Engineering Re-Engineering Software
Visio
Michael
Looks like it only works with MySQL and I use MS SQL.
-Original Message-
From: CFDEV [mailto:[EMAIL PROTECTED]
Sent: Friday, May 20, 2005 4:31 PM
To: CF-Talk
Subject: RE: DB Design, Engineering Re-Engineering Software
I use dbdesigner by fabforce
Fabforce.net
Open source project ;)
I don't see a version that I can buy solo that creates DDL. What am I
missing? I own Professional.
Andy
-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: Friday, May 20, 2005 6:31 PM
To: CF-Talk
Subject: RE: DB Design, Engineering Re-Engineering Software
Yeah,
On 5/19/05, Rob Condon [EMAIL PROTECTED] wrote:
Thanks. I don't know what's wrong in my setup but the watermark hides the
entire output on my computer! My solution is to deploy it to our staging
server which has the licensed version installed. What a pain!
What version of the Acrobat
I agree with Micha here.
Examples of business needs that *might* suggest Enterprise:
- Ability to separate code into sandboxes (e.g. in a large company with
separate coding teams that don't talk to each other)
- Integration with Oracle
- High volume email requirements
- Installed base of Java
I'm completely blanking on how to add subtotals. I'll explain clearer
below:
I have a table of itemsPurchased that includes itemID itemQty and
itemPrice.
!--- simplified ---
SELECT itemID, itemQty, itemPrice
FROM itemsPurchased
WHERE purchaserID = '#purchaserID#'
Say person A bought
Yes it's better with mysql but works also through ODBC with other DB.. I
personnaly use it as well with oracle and for a free tool, it's doing the
job..
Pat
-Original Message-
From: Andy Ousterhout [mailto:[EMAIL PROTECTED]
Sent: May 20, 2005 19:33
To: CF-Talk
Subject: RE: DB Design,
You should really only have robust exception
information on on a development server.
I think you might be thinking about debugging.
Neither should be enabled on a production server.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Robust exception information is only an issue
Use distinct and order descending by crid. In the future, I highly recommend
a unique key (PK) or at least a date/time field to decide which are the
latest records
-Original Message-
From: Jeff Chastain [mailto:[EMAIL PROTECTED]
Sent: Friday, May 20, 2005 9:59 AM
To: CF-Talk
Subject: OT:
SELECT sum(itemPrice) as TheTotal
FROM itemsPurchased
WHERE purchaserID = '#purchaserID#'
-Original Message-
From: mayo [mailto:[EMAIL PROTECTED]
Sent: Friday, May 20, 2005 9:15 PM
To: CF-Talk
Subject: adding subtotals
I'm completely blanking on how to add subtotals. I'll explain
I didnt mean to send that just yet :)
I assumed you meant adding it in a query versus CF...
This will get distinct purchaserIDs and their total dollars spent on any all
together
SELECT purchaserid, sum(itemPrice) as TheTotal
FROM itemsPurchased
group by purchaserid
This will break the
90 matches
Mail list logo
