This would actually be more work than what I am doing now, which is 1 query
and only output the rows I want.
Your method would produce the same results, but with 1 more unneccisary trip
to the database.
If you already have all the data you need in the first query, there realy is
no need to create
OK I think I have thought of a way.
Don't do the query in CF at all.
Just pass your search criteria and the start/end rows to a stored procedure.
The SP queries all the records as usual, but then extracts only the rows you
wanted using the start/end, and returns this back to CF as the resultset.
Indeed, you could if you wanted also use SQL Server Paging in the SP to save
time and resource.
-Original Message-
From: Snake [mailto:[EMAIL PROTECTED]
Sent: 31 August 2005 09:30
To: CF-Talk
Subject: RE: Paging through records
OK I think I have thought of a way.
Don't do the query
I've just been through this.
I found that some of the threads in our forums were nearing 1000 messages, and
the query containing all this was about 1.5Mb in size.
The only snag with using a stored procedure for this is that it is very
difficult to get a RecordCount for the entire query.
The
Hi,
I've just been through this.
I found that some of the threads in our forums were nearing 1000 messages, and
the query containing all this was about 1.5Mb in size.
The only snag with using a stored procedure for this is that it is very
difficult to get a RecordCount for the entire query.
OK, managed to duplicate post and still screw it up!
The IN clause of the second query should be:
WHERE messageId IN (cfloop from=#startRow# to=#endRow#
index=i#ListGetAt(ValueList(getMessageIds.messageId), i)#/cfloop)
This is only an illustration - it's probably worth creating the ValueList
David Brown wrote:
Well, I had to do the same thing a month or so back. I needed a flash form
for our unitedway project. I could not find any way to do it in AS. That
does not mean there is not away, just after spending a few hours on it I
thought of a an easier way that would work.
I used
so if I invoke a cfc method how much of that cfc is loaded into cf's memory? is
it the whole cfc (and all other methods) or just the method I am calling?
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Yes, thats correct.
The Netconnection Debugger is what's showing me the errors.
I've tried not including it in the source, to see if that was some how do'n
something funcky. But same results with out it (application stops) just no
error reporting.
Are you using the Netconnection Debugger? Is
I just wish it has a sweet price!
Calvin
-Original Message-
From: Mike Nimer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 30, 2005 12:36 PM
To: CF-Talk
Subject: RE: What were they thinking?
snip Honestly though if you're tweaking your forms so much that these
keywords are becoming
Rey,
There's no way around that message. The major league baseball site
(www.mlb.com) has a similar issue when after login for audio they forward
your browser to a non-secure link for streamming audio. Presumably they
don't want to stream over SSL. When I listen to games I get the same message
I believe that Cflocation sends a page moved header message on redirect.
Not the same as a javascript redirect.
-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 30, 2005 7:57 PM
To: CF-Talk
Subject: RE: Odd SSL problem
Ahh so it ONLY happesn with
whoops... sorry. I got to start looking through all the messages before I
jump in... dang it!
-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 31, 2005 7:19 AM
To: CF-Talk
Subject: RE: Odd SSL problem
Rey,
There's no way around that message. The
Maybe they are just lazy and couldn't be bothered setting up a secure
stream?
-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED]
Sent: 31 August 2005 13:24
To: CF-Talk
Subject: RE: Odd SSL problem
whoops... sorry. I got to start looking through all the messages before I
OK, managed to duplicate post and still screw it up!
The IN clause of the second query should be:
WHERE messageId IN (cfloop from=#startRow#
to=#endRow#
index=i#ListGetAt(ValueList(getMessageIds.messageId),
i)#/cfloop)
This is only an illustration - it's probably worth
creating the
so if I invoke a cfc method how much of that cfc is loaded
into cf's memory? is it the whole cfc (and all other
methods) or just the method I am calling?
Whole thing...
CF doesn't know ahead of time what's being used within the method, so
it loads up the CFC as though you had instantiated it
On 8/30/05, S. Isaac Dealey [EMAIL PROTECTED] wrote:
In MS SQL and Access, there is the TOP clause to limit the
number of records, but I'm not sure if and how you can set
the first one.
SELECT BOTTOM 50 * FROM mytable
WHERE mytable_id IN
(SELECT TOP 100 mytable_id FROM mytable
yes. I was involved in setting up FRS/DFS once. IIRC, one box had
to be a DC with the other boxes as members. Or if the boxes live in a
domain, that DC could do it too. AD was involved too. Once setup it
worked fine and dandy...still working in fact after about 3 years now.
DK
On
Yes, correct.
Regards,
Howie
--- On Tuesday, August 30, 2005 5:36 PM, Russ scribed: ---
So you need to set up DFS and have a domain for that, correct?
-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 30, 2005 4:59 PM
To: CF-Talk
Subject: Re:
Resource-wise a secure stream is pretty expensive.
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 31, 2005 7:19 AM
To: CF-Talk
Subject: RE: Odd SSL problem
Maybe they are just lazy and couldn't be bothered setting up a secure
stream?
But possible - being expensive and not doing it for technological reasons
are two different beasts ;-)
-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED]
Sent: 31 August 2005 14:41
To: CF-Talk
Subject: RE: Odd SSL problem
Resource-wise a secure stream is pretty
This is a good point, but another thing to consider besides the software
is also hardware. If you have the ability to connect the machines using
gigabit ethernet cards, that could also substantially help the transfer
rates if you are going to have a lot of data moving. Just a suggestion
to keep in
Hi All,
Here is my Java class that I am using to debug JDBC PreparedStatement.
/* -DebugLevel -*/
package com.javaunderground.jdbc;
/**
* Title:
* Description:
* Copyright:Copyright (c)
* Company:
* @author
* @version 1.1
*/
public class DebugLevel {
Hi ... I'm writing a function that calls a webservice. I have the calls
to the webservice contained in a try catch block and do not understand
why I am seeing an error message.
function authenticate( url, username, password ) {
returnDoc = '';
try {
service = createObject(
No prob Mark. I appreciate the help. The code that Michael Dawson
provided worked like a charm and allowed me to redirect to the non-SSL
homepage easily.
Rey...
Mark A Kruger wrote:
whoops... sorry. I got to start looking through all the messages before I
jump in... dang it!
-Original
lets say i have:
function (arg1,arg2,arg3)
only arg1 is required.
arg1 = string
arg2 = date
arg3 = string
i want to pass in function(arg1,,arg3)
if i just skipp over arg2 but give it a placeholder, i am getting an error
about missing an argument for a named argument.
if i pass in
I know SeeFusion exists out there but this tool must be calling publically
accessible hooks within ColdFusion / JRun, anyone know what these are?
Did WebApper have some MM help on the tools creation? I ask, as we may want
to build our own tool.
This e-mail is from Reed Exhibitions (Oriel
Your method would produce the same results, but with 1 more
unneccisary trip
to the database.
What counts is not the number of trips to the database, but what
you're asking the database to do at every trip.
cfoutput query=whatever startfrom=#startfrom# maxrows=#maxrows#
This will make CF
you can use either cfinvoke to call the function directly and only
specify the cfinvokeargument for the arguments you want, or if you
want to keep using the same syntax as above, you can use named
arguments:
function(arg1=value,arg3=value)
On 8/31/05, Abraham Hertzberg III [EMAIL PROTECTED]
isn't there a way to pass the argument name into the function?
On 8/31/05, Abraham Hertzberg III [EMAIL PROTECTED] wrote:
lets say i have:
function (arg1,arg2,arg3)
only arg1 is required.
arg1 = string
arg2 = date
arg3 = string
i want to pass in function(arg1,,arg3)
if i just
After I have created a document using cfdocument I am using the following code
to open the pdf,
cfheader name=content-disposition value=attachment; filename=wibble.pdf
cfcontent type=aplication/pdf file=#expandpath('MyFilePath')#
deletefile=yes reset=no
This shows a dialogue box to the user
cfloop from=#startRow# to=#endRow#
index=i#ListGetAt(ValueList(getMessageIds.messageId), i)#/cfloop
C'mon, this is just too inefficient: you're converting column messageId
of query getMessageIds to a list in the loop!
See
Unfortunately, I would not be able to disclose the company name. My apologies.
Brian Simmons [EMAIL PROTECTED] wrote:Discover Antartica wrote:
Here are some questions that a company asked a friend of mine during an
interview. I just wanted to see if he answered them correctly.
Jochem wrote:
So
aye, just got it from jugg... thanks
On 8/31/05, Ryan Guill [EMAIL PROTECTED] wrote:
you can use either cfinvoke to call the function directly and only
specify the cfinvokeargument for the arguments you want, or if you
want to keep using the same syntax as above, you can use named
I have a need for a coldfusion application to generate a document
(possibly PDF) and then print it to a file using a printer driver
installed on the server, and then perform an operation on that file
(email, FTP, etc)
The first and last parts are easy, the printing part I'm not so sure...
Do you actually need to print it using a print driver, or just place
the file in a queue folder on the printer's RIP?
This is how I've typically handled such requests.
On 8/31/05, Rick Root [EMAIL PROTECTED] wrote:
I have a need for a coldfusion application to generate a document
(possibly
You amy also be able to leverage javax.print via the JVM. I haven't tried
it but from the docs it looks possible.
http://java.sun.com/j2se/1.4.2/docs/api/javax/print/package-summary.html
-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]
Sent: 31 August 2005 15:30
If you just need the file, why not skip the printer driver? You can
use CFDocument in CF7 to generate a PDF file, then do whatever you
want with it (CFMail it, CFFtp it, etc.).
-Joe
On 8/31/05, Rick Root [EMAIL PROTECTED] wrote:
I have a need for a coldfusion application to generate a document
David Brown wrote:
But not sure I understand how to convert this from flash to cfform flash
action script. It seems that you have to convert the query to an array (did
that with the udf they suggest) and then assign the results to a new object
in your action script something like var
Joe Rinehart wrote:
If you just need the file, why not skip the printer driver?
Because we need to generate a PCL file for a specific printer.
Rick
~|
Logware (www.logware.us): a new and convenient web-based time tracking
Try this...
-Original Message-
From: Kevin Bridges [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 31, 2005 9:55 AM
To: CF-Talk
Subject: Error Trapping for Webservice
Hi ... I'm writing a function that calls a webservice. I have the calls
to the webservice contained in a try catch
I'm submitting the contents of a flash cfform to the database via a cfc
and I want to reset the form when I get a positive result back from the
cfc. The code below shows the call to the cfc and the call to reset the
form. I know that the resetForm() gets called because I put an alert in
with
Control enter is a killer... lets try that again...
cfscript
function authenticate( url, username, password )
{
returnDoc = '';
try
{
service = createObject( webservice,
http://example.com/example.asmx?WSDL; );
xmlDoc = XmlParse(
The Netconnection Debugger can always see what's happening. Without seeing
your script, it'll be real hard to figure this out...
Cheers,
Kevin
-Original Message-
From: Doug Kronenberger [mailto:[EMAIL PROTECTED]
Sent: August 31, 2005 5:10 AM
To: CF-Talk
Subject: Re: CFC and Flash
Robertson-Ravo, Neil (RX) wrote:
You amy also be able to leverage javax.print via the JVM. I haven't tried
it but from the docs it looks possible.
http://java.sun.com/j2se/1.4.2/docs/api/javax/print/package-summary.html
I'll give this a whirl. If I can't figure it out we've got a VB
Ha ... that got it. I'll make sure and place those return lines where
they are supposed to be!
Thanks
Bobby Hartsfield wrote:
Control enter is a killer... lets try that again...
cfscript
function authenticate( url, username, password )
{
returnDoc = '';
try
{
Yup, catch needs to be the last thing here as well. Also the catch type is
Any instead of All
Glad you got it going.
-Original Message-
From: Kevin Bridges [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 31, 2005 11:11 AM
To: CF-Talk
Subject: Re: Error Trapping for Webservice
Ha ...
Kevin,
What version of CF? There use to be an error where you needed to add a
trainly slash to your flashservices/gateway call - it has to do with the
passing of the sessionid.
Ben had a blog about it - but I can't seem to find it. Anyway, try:
http://10.3.196.31/flashservices/gateway/ (note
In Oracle, there is ROWNUM...
Yeah, but that's not how you get a set out of the middle
with Oracle,
'cause if you specify a minimum value for rownum you
don't get the
expected results... well... not by itself... In oracle
you use the
MINUS clause, which is surprisingly efficient...
C'mon, this is just too inefficient: you're converting column messageId
of query getMessageIds to a list in the loop!
I did say that
Ian
~|
Logware (www.logware.us): a new and convenient web-based time tracking
Bobby,
This doesn't work for me because the values in the database are in a numeric
column and stored as 1 or 0. I need the query to return 'yes' or 'no'. The
query results are used for a CFINDEX, so the only option I can think of at this
point is to build a NEW query and transform those
Sorry I don't understand the point in your reply?
I already pointed out that this other method does exactly the same thing,
but also adding an additional query.
We know what my original example does, as that was the whole point in this
topic.
Russ
-Original Message-
From: Claude
This should do it (depending on the db)...
SELECT CASE WHEN field = 1 THEN 'YES' ELSE 'NO' END AS yesNoField
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 31, 2005 12:23 PM
To: CF-Talk
Subject: RE: Oracle SQL alternative for YesNoFormat()
Thanks y'all. I think this will work.
Dave
-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Sent: Monday, August 29, 2005 3:31 PM
To: CF-Talk
Subject: Re: SOT: Oracle SQL alternative for YesNoFormat() ?
SELECT CASE WHEN yourColumn = 1 THEN 'yes' ELSE 'no' END as
After I have created a document using cfdocument I am
using the following code to open the pdf,
cfheader name=content-disposition value=attachment;
filename=wibble.pdf
cfcontent type=aplication/pdf
file=#expandpath('MyFilePath')# deletefile=yes
reset=no
This shows a dialogue box to the
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Bobby,
This doesn't work for me because the values in the database
are in a numeric column and stored as 1 or 0. I need the
query to return 'yes' or 'no'. The query results are used
for a CFINDEX, so the only option I can think of at
select case when column_name = 0 then 'no' else 'yes' end as
column_name_yes_no_format
--Ferg
[EMAIL PROTECTED] wrote:
Bobby,
This doesn't work for me because the values in the database are in a numeric
column and stored as 1 or 0. I need the query to return 'yes' or 'no'. The
query
lets say i have:
function (arg1,arg2,arg3)
only arg1 is required.
arg1 = string
arg2 = date
arg3 = string
i want to pass in function(arg1,,arg3)
if i just skipp over arg2 but give it a placeholder, i am
getting an error
about missing an argument for a named argument.
if i pass in
Not sure where I got this or if I wrote it, but had this laying around:
CREATE OR REPLACE FUNCTION yesnoformat ( arg_integer IN NUMBER )
RETURN VARCHAR2
DETERMINISTIC
AS
var_character VARCHAR2(3);
BEGIN
IF arg_integer = 1
THEN return 'Yes';
ELSIF arg_integer = 0
THEN RETURN 'No';
ELSE
Something like
SELECT Decode(column_name,1,'Yes','No') AS column_name
FROM table
WHERE criteria
Will return 'Yes' when column_name is 1 and 'No' when column_name is
anything else
Matt Osbun
Web Developer
Health Systems, International
-Original Message-
From: Michael Tangorre
I already pointed out that this other method does exactly the same thing,
but also adding an additional query.
My point is that adding an additional query does not imply that the
overall result is less efficient, on the contrary.
One may have two small queries that are much faster than one big.
Thanks for that, at least I won't waste any more time looking :-)
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: 31 August 2005 17:29
To: CF-Talk
Subject: Re: CFContent question ...
After I have created a document using cfdocument I am
using the following
On 8/31/05, S. Isaac Dealey [EMAIL PROTECTED] wrote:
In Oracle, there is ROWNUM...
Yeah, but that's not how you get a set out of the middle
with Oracle,
'cause if you specify a minimum value for rownum you
don't get the
expected results... well... not by itself... In oracle
you
Not in this scenario.
You have to select ALL records to extract or output the ones you want.
So my original example was
1. query all the required records
2. output the ones you want
The one your saying is better
1. query all the required records
2. query a subset of those records
3. output
Welcome. :) I nearly started writing a whole bunch of stuff about how
that part is in the browser and you can only access what's exposed in
JS (which is pretty limited), browser variations, etc. etc... and then
decided it was probably best just to give a concise answer. :)
Thanks for that, at
On 8/31/05, S. Isaac Dealey [EMAIL PROTECTED] wrote:
In Oracle, there is ROWNUM...
Yeah, but that's not how you get a set out of the
middle
with Oracle,
'cause if you specify a minimum value for rownum you
don't get the
expected results... well... not by itself... In oracle
you
I have this:
cfif structKeyExists(session,'user')
cfif isDefined(session.user.displayname)
p class=toptext
Logged In:
cfoutput#session.user.displayname#/cfoutput input type=button
class=logout value=Logout onClick=location.href =
Not in this scenario.
You have to select ALL records to extract or output the
ones you want.
So my original example was
1. query all the required records
2. output the ones you want
The one your saying is better
1. query all the required records
2. query a subset of those records
3.
I searched the archives, I have searched Google and I have checked out the
original authors site,
http://projects.nateweiss.com/nwdc/workcode.htm,
but I cannot find anybody who has actually ever got the default1 default2
values working in the CF_TwoSelectsRelated tag. Basically I love this
Does anyone here have CFMX7 and ArcIMS installed? I'm trying to install it on a
Win2k server with CFMX7 (in non-J2EE mode) IIS 5. ESRI is telling me that we
have to purchase JRun 4.0 separately from Macromedia or use TomCat, that it
won't work with the version of JRun that gets instaled with
I have a template that calls a javascript function that in turn uses cfajax to
call a cfm function as below, it all works perfectly:
!--- ---
select size=1 id=jobData name=jobData class=form1
onChange=getStartDates();
option value=#jb.jobID##jb.oilcompany#/option
/select
I searched the archives, I have searched Google and I have checked out
the original authors site,
http://projects.nateweiss.com/nwdc/workcode.htm,
but I cannot find anybody who has actually ever got the default1
default2 values working in the CF_TwoSelectsRelated tag. Basically I
Thanks, definately worth a look if I can't get this script to work properly.
I searched the archives, I have searched Google and I have checked out
here?
this is not the answer you're looking for but...cfajax enables you to do
this:
http://www.indiankey.com/cfajax/
Andrew.
Stephen,
Take a look at this:
http://casacarriersantos.porta80.com.br/
click in comprar and look at the flash form at the bottom, all I
couldn´t do was to put ',00' in the grid. Is that what yoiu want to
do?
Felipe
On 8/31/05, Stephen Moretti [EMAIL PROTECTED] wrote:
David Brown wrote:
I agree with Isaac. The first query could even be:
cfquery name=TotalCount
select count(id) as TheCount
/cfquery
Wouldn't this make the first query even faster as it's not returning x records,
it's only returning ONE record and then you can reference TotalCount.TheCount
instead of
I have a template that calls a javascript function that in turn uses
cfajax to call a cfm function as below, it all works perfectly:
Problem solved! - must put head into gear before typing!
~|
Logware (www.logware.us): a new
Rebecca Wells wrote:
Does anyone here have CFMX7 and ArcIMS installed? I'm trying to
what ver of arcIMS? what kind of cf (enterprise/standard)? we normally
do arcIMS w/enterprise cf. for arcIMS 4 the install is dead easy, just
point the arcIMS classes at cfinstall/wwwroot/web-inf/classes dir
We have an Access DB where we need to re-set all passwords to match the
user's member number (this is just a temporary change). We want to hash
the new passwords.
This query works without the hashing:
cfquery name=changePassword datasource=#Application.Datasource#
UPDATE
Well I think the count() example is sort of outside of the scope of
what was being described... The specific question (as I understood it)
was whether a pair of queries could be faster for presenting a sub-set
of records in a list page -- the count() query isn't part of the task
of fetching and
The CF Underground VII will be held Saturday 10/15/05 before MAX
in Anaheim CA. If you are interested in speaking or want to suggest
a speaker please complete the survey below by Tuesday 9/6/05 5pm
http://www.cfconf.com/cf_underground7/survey.cfm
Registration is also open - don't miss the
You're trying to mix CF and SQL, which doesn't work. Check and see if
Access has an MD5 function, or perhaps an ENCRYPT function that uses
the MD5 algorithm. If so, you can do
cfquery
UPDATE members SET password = MD5(password)
/cfquery
and be done. If not, then you'll have to pull the
I think it applies because the whole discussion was about what's a 'faster' way
to do this...
My point is that the second query is getting the data to display on the page in
question (say records 51 - 100), so why does the first query need to return all
rows of the data? If the first query is
what ver of arcIMS? what kind of cf (enterprise/standard)?
ArcIMS 9.1, CFMX7 Enterprise, IIS 5.0, Win2k Server.
arcIMS 9 is a bit more convoluted requires some
manual work. i'm at home now so i can't give better details but i do
recall it was all laid out in the esri docs.
Um, yeah, in the
did you try cfinstallDir\wwwroot\WEB-INF\classes?
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message:
I think it applies because the whole discussion was about
what's a 'faster' way to do this...
My point is that the second query is getting the data to
display on the page in question (say records 51 - 100), so
why does the first query need to return all rows of the
data? If the first query
Just save the cfusion/lib/neo*.xml files and after you install the j2ee
version, copy your saved copies back into the cfusion/lib folder and
that should keep all of your settings.
---nimer
-Original Message-
From: Rebecca Wells [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 31, 2005
One technique I've found to be very effective is to cache the recordset
and page from there...I'll normally set a limit of 10,000 rows. (I base
this off record counts from summary roll-up screens) If the amount
exceeds that I fall back to leveraging rownum (Oracle) to retrieve
subsets.
-Stace
You sure the line number in the error is pointing you to this block of code?
I see nothing wrong with:
cfif structKeyExists(session,'user')
cfif isDefined(session.user.displayname)
p class=toptext
Logged In: cfoutput#session.user.displayname#/cfoutput
input type=button class=logout value=Logout
Good points. Thanks for your comments. :)
Dave
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 31, 2005 3:06 PM
To: CF-Talk
Subject: RE: Paging through records
I think it applies because the whole discussion was about
what's a 'faster' way
p.s. 10K records may sound like a lot but it's typically only cached for
a couple of mins, or until a new report is run by that user. Our systems
are pounded each day by both internal and external folks and cfmx is
rock solid using this technique.
We're in finance so many of these systems are
Good points. Thanks for your comments. :)
Welcome. That's what I'm here for. :)
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
Well I think the count() example is sort of outside of the scope of
what was being described... The specific question (as I understood
it) was whether a pair of queries could be faster for presenting a
sub-set of records in a list page -- the count() query isn't part
of the task of
d'oh!
cfquery blah blah
SELECT COUNT(*) AS TotalRecords,
*
FROM (SELECT col1,
col2,
col3,
ROWNUM AS myRownum
FROM -- tables
WHERE-- where
ORDER BY -- order by)
WHERE
myRownum between #start# and #end#
I'm back to a problem that I run into a lot. I started working at a
place that does not do a good job of cleaning up files in a websites
directory. (as well as tons of unused stored procedures and views)
I've found plenty of tools to track down database objects, even some
that check your files for
Rebecca,
You can also try the ESRI forums, for asking questions. Keep in mind
that the only thing that needs to be deployed is the servlet connector,
which is a j2ee servlet application (the main server stuff runs
separately).
I don't think it is possible to deploy it without a proper Jrun
I'm back to a problem that I run into a lot. I started
working at a
place that does not do a good job of cleaning up files in
a websites
directory. (as well as tons of unused stored procedures
and views)
I've found plenty of tools to track down database objects,
even some
that check your
You can still do it in one query, returning both the total
record count and just the window of records you are
interested in (example for oracle):
snip
you then have a single small window query with an extra
column (TotalRecords) that tells you how many rows are in
the big query (which you
I think the problem of remove file b if file a is the only file that calls
it could be solved with recursion, ie, running the process several times.
First time will remove file a, second time will remove file b. Not as
efficient, but the algorithm for calculating which files need to be deleted
is
Barney Boisvert wrote:
cfquery name=get
SELECT memberNo
FROM members
ORDER BY memberNo
/cfquery
cfloop query=get
cfquery
UPDATE members SET
password = #hash(memberNo)#
WHERE memberNo = #memberNo#
/cfquery
/cfloop
Excellent. This code did the trick. Apparently
ooo.. very good point on the href=#approot#/path/to/file.cfm but
there are some good (relative to this issue) circumstances. Everything
here is pretty simplistic in terms of server side processing. There
aren't any urls in the database, (just tons of business logic) and I
haven't seen any places
1 - 100 of 130 matches
Mail list logo
