Create a batch file and use cfexecute.
-Mark
-Original Message-
From: Phill B [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 26, 2004 10:36 AM
To: CF-Talk
Subject: Use CF to delete directory and files in it?
I'm trying to find a way to delete a directory with files in it.
cfdirectory
You can use cfcontent to serve the file - it does not even need to be inside the
web root.
-Mark
-Original Message-
From: CFDEV [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 25, 2004 10:29 AM
To: CF-Talk
Subject: get file
Hi,
I have files on our server and I want people (once
I think your service is not being handed the request. I would run the connectors. It looks like an encrypted file being
served by IIS (instead of being processed first by CF) - sort of like seeing the source code on an unecrypted file.
-mark
-Original Message-
From: Jeff Small
Jeff,
I'm speaking of the little batch files buried in the /cfusionmx/ directory that
remove and re-add the necessary connectors for the jvm.If you are running CF
the process is to remove the extension mappings in the IIS admin for the
application.
As for your problem - hmmm did you recently
Dave,
I suggested that earlier - but he says that other .cfm files on the same
configured sites run correctly. wouldn't that indicate that the connector was
correctly installed?
-Mark
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Monday, August 23, 2004 11:40 AM
Richard,
Write your script - then use the cf admin scheduled tasks to make it run each
morning. If you don't have access to admin but cfschedule is enabled you can use
that tag to create a reoccuring task.
-mark
-Original Message-
From: Richard Crawford [mailto:[EMAIL PROTECTED]
Sent:
You are correct - the iif file is pretty much a comma delimited ascii file. The
answer you need is actually in the quickbooks help files - here's an excerpt.
-Mark
---
You may also want to refer to the Reference Guide to Import Files
Note: These
Jeff,
And what was the solution prey tell - or did I miss that?
-Mark
-Original Message-
From: Jeff Small [mailto:[EMAIL PROTECTED]
Sent: Monday, August 23, 2004 3:56 PM
To: CF-Talk
Subject: SOLUTION: Re: Okay, go here to see what I'm talking about...(cfserver
not r unning correctly)
You are not modifying it for path so fileexists( ) should crap out - unless BD does relative paths... does it? Also -
what's with the evaluate( ) function? Seems superflous to me.
-mk
-Original Message-
From: Ken Ferguson [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 19, 2004 9:31 AM
Matt,
Yes but... fileexists requires the fule path (i.e. e:\wwwroot\index.cfm - not just index.cfm) so I would definitley
expect the cfif to return FALSE - or am I missing something?
-mark
-Original Message-
From: Matt Liotta [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 19, 2004
full path not fule
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 19, 2004 10:12 AM
To: CF-Talk
Subject: RE: BlueDragon cfinclude issues
Matt,
Yes but... fileexists requires the fule path (i.e. e:\wwwroot\index.cfm - not just index.cfm) so
Adam,
I'm with you on the plugins.I had the same experience with foresite coupons in Able commerce.
As for CF Webstore - Mary Jo. has a great product - inexpensive with lots of features and easy to work with. More
features for the buck than 300.00 really deserves when it comes down to it. If you
Try something like this:
CFQUERY name=get_tasks datasource=taskomatic
SELECTt .taskID,
t .taskname,
t .status,
t .project,
p .projectsID,
p .projectname,
p .client ,
c.clientName
FROM taskst JOINprojectsp
ONt.project = p.projectsID
JOIN clients c
ON p.client= c.clientID
/CFQUERY
Yes - nice package.It lacks several of the tools from CF webstore, but there are some things I really like about it.
-Mark
-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 19, 2004 3:06 PM
To: CF-Talk
Subject: RE: My First Shopping Cart
For high
Adam,
Sorry - no way I agree with that.I'd say about 2 to 4 % of users ever look at the URL at all - let alone grasp the
difference between a document and a string of variables. I would say that the difference is not only superflous but a
red herring only noticed by developers.
-mk
Has anyone here every implemented S/MIME for server side email?I have a customer who considers it important.
-mk
Mark A. Kruger, MCSE, CFG
www.cfwebtools.com
www.necfug.com
http://blog.mxconsulting.com
...what the web can be!
[Todays Threads]
[This Message]
[Subscription]
[Fast
Folks,
What's the best way to go about supporting S/MIME email from a CF server.I can't seem to find any tags that
specifically support S/MIME. Anyone?
-Mark
Mark A. Kruger, MCSE, CFG
www.cfwebtools.com
www.necfug.com
http://blog.mxconsulting.com
...what the web can be!
[Todays Threads
This works pretty well - but on some RDBMS's you can get a buffer overrun on your IN () list if it grows very large.
I've had that happen at 10,000 or so. Actually, it is more likely when using Cfqueryparam because the array allocated
for the bind may have a maximum value. If you pass in an actual
Matt,
I'd say your guess that your install has something to do with it is a red herring.Something has changed the way it
handles idle time suspension or power or somehting.Also, when you say cannot access the network from the server -
what do you mean? Do you mean you can't ping an IP address...
Hey - try this. create a folder on a remote RDS server called help that is inside your web root.Then, using cf
studio or homesite, right-click on a file with a long name (longer than 9 characters) and choose copy to - then try to
copy that file to the help folder on the remote machine. Does anyone
did someone say golf??? perk
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 20, 2004 10:18 AM
To: CF-Talk
Subject: Re: merge data from two queries
NEVERMIND, im an idiot.
queryname.columnName[1]
DU!!!
must be all that freakin' golf over the
Tony,
this is a join - not a union. A union query matches 2 different tables or recordsets with the same type in each
matching column.
select col1, col2, col3 from table1
union
select a1, a2, a3 from table2
-- If col1 is an int and a1 is a char, this will fail.They can be named differently
Ken,
that's not Hal Helms is it?
-mk
-Original Message-
From: Ken Ferguson [mailto:[EMAIL PROTECTED]
Sent: Friday, July 16, 2004 1:45 PM
To: CF-Talk
Subject: RE: RAD (was RE: Best choice for ColdFusion Studio IDE...)
I know you're half-kidding here, but you're not too far off of what
Um I name my directories blah.com all the time without issue.Can you give an example?How is it that you think
this?
-Mark
-Original Message-
From: Damien McKenna [mailto:[EMAIL PROTECTED]
Sent: Friday, July 09, 2004 4:05 PM
To: CF-Talk
Subject: OT: IIS considers blah.com directories
A couple of things come to mind. First, if you are using Access and under a heavy load you need to move to a different
db. Sorry - but there's just not a lot you can do about it. The sequence driver just hangs under a heavy load.Second,
if you are using JDBC drivers (for MS SQL for example), make
Phil,
Try db.username.tablename.If the user is an aliased dbo (ms sql) use db.dbo.tablename.
-Mark
-Original Message-
From: Phill B [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 06, 2004 10:54 AM
To: CF-Talk
Subject: Query multiple databases
I need to write a join that calls to tables
Greg,
I don't believe that is correct. The purpose of the single quotes is to identify character data. cfqueryparam makes them
unnecessary by specifying the data type in advance.In this case using a datatype binding (cfqueryparam) means the
single quotes would be superflous.the driver creates a
Dan,
I would check the following. Is it an exact type match? For example, is the field a text field and you are using
varchar?I would check to make sure that the field is nullable - since you are using the null attribute.And I would
try other types if you can.
-Mark
-Original Message-
hehe... happens to me all the time.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, July 05, 2004 10:06 AM
To: CF-Talk
Subject: RE: Havent seen this error before...(Resolved)
Too early the morning after with not enough coffee:) Turns out that I was not
the cfqueryparam. Specifying the
cfsqltype should take care of that for you right?
Greg
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]
Sent: Monday, July 05, 2004 10:44 AM
To: CF-Talk
Subject: RE: Havent seen this error before...
Greg,
I don't believe
Greg,
no - it would not.What he's (probably) doing is staying away from a data truncation error - where the database
chockes on a string that is too long for the field size definition.In this case perhaps his field definition has a
size of 100 - doing a left(string,100) makes sure that the string
Mike,
Hey ... if your right that has to be a bug right? It must be because of the nested function.I use trim( ) all the
time without issues.Your saying that trim( ) combined with Len( ) causes the inner function ref to be passed instead
of the return value from both calls?
-Mark
-Original
Indeed, we adjust that value automatically when setting up a new installation. The default value (64mg I believe) is
simply too low to support a busy application or multiple sites.
-Mark
-Original Message-
From: Steven Erat [mailto:[EMAIL PROTECTED]
Sent: Monday, June 28, 2004 3:56 PM
Ian,
I would add that the current anti-popup climate has brought on a host of new pop-up blocking tools. If in your
onUnload function you are calling another page, I suspect a popup blocker would take issue with that - no?
-Mark
-Original Message-
From: Ian Skinner [mailto:[EMAIL
Asim,
I've been using ghostwire and I like it - easy to builddynamic menus.
http://www.ghostwire.com/
-Mark
-Original Message-
From: Asim Manzur [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 23, 2004 10:14 AM
To: CF-Talk
Subject: Macromedia Style nav bar
Hi,
I am looking for some
A lot depends on what datasources you are talking about - but any resource on JDBC and connection pooling will give you
good information. The underlying service is not CF specific. The current version of CF uses drivers from datadirect.
Just about everything about the connection is configurable
First,
make sure the query gives you what you want. Because you have no parenthasise this query is going to give you ALL
records from the tables:
tblbillingaddr, tblterm
That's because the WHERE clause reads Give me everything WHERE
where tblmasterclients.clientname = tblbillingaddr.Client
Frank,
You should be looking for code that waits for a response from a third party process. Culprits are (typically) db
access, ftp, ldap, pop, file access (cffile), cfhttp etc.All of these services must connect to a service or process
outside the CF engine - cf awaits their response... sometimes
What does the variable server.Coldfusion.expiration mean? I'm examining a users current host.
-mark
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
I'd say bad or mismatched memory is at fault.
-mk
-Original Message-
From: Jack Dalaa [mailto:[EMAIL PROTECTED]
Sent: Monday, June 14, 2004 4:50 PM
To: CF-Talk
Subject: Re: Argh! Ram upgrade killed CF!
jvm.config is just default stuff:
# Arguments to VM
java.args=-server -Xmx1024m
hints?
-Mark
Mark A. Kruger, MCSE, CFG
www.cfwebtools.com
www.necfug.com
http://blog.mxconsulting.com
...what the web can be!
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
: Character encoding - CFMX and SQL
you have to create the columns in MS SQL as nVarchar so that they can
cope with international chraracters...
Regards
On Fri, 11 Jun 2004 08:22:31 -0500, Mark A. Kruger - CFG
[EMAIL PROTECTED] wrote:
Folks,
I have an international customer who was running on Access
Paul,
THAT is the answer I'm looking for -thanks!
-Mark
-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED]
Sent: Friday, June 11, 2004 9:28 AM
To: CF-Talk
Subject: Re: Character encoding - CFMX and SQL
language specific characters (Italian) it changes the characters to
Is there anything IN your servers/lib directory - and how did you figure out that this was the problem??
-Mark
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Friday, June 11, 2004 11:18 AM
To: CF-Talk
Subject: someone has to know this... MACROMEDIANS, anyone...cfdump
A. Kruger, MCSE, CFG
www.cfwebtools.com
www.necfug.com
http://blog.mxconsulting.com
...what the web can be!
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
;
var aDate = date.split(/);
if(aDate[2].length==2) aDate[2] = (eval(aDate[2])30)?19:20
+ aDate[2];
alert(aDate[2]+-+aDate[0]+-+aDate[1]);
if(eval(aDate[1])daysInMonth(eval(aDate[2]),eval(aDate[0])))
return false;
return true;
}
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL
-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]
Sent: vrijdag 11 juni 2004 18:41
To: CF-Talk
Subject: OT: Regular expressions in JS (or in general) for dates
Regex gurus,
I have a string and I want to ensure that the date format is:
xx/xx/ or x/x/ or x/x/xx (you get the idea
Sorry,
I was trying to send that to the guy who needed it.
-Mark
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]
Sent: Friday, June 11, 2004 1:13 PM
To: CF-Talk
Subject: Function for days and years...
This function makes sure that the days match the correct
uh what?
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Friday, June 11, 2004 1:49 PM
To: CF-Talk
Subject: Re: Message Board
Calvin Ward wrote:
Idon't agree with the need for free anything, especially something
someone crafted.
That's an awfully irrational
more deserving my charity. I'm more interested
early retirement (hehe).
-Mark
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Friday, June 11, 2004 2:01 PM
To: CF-Talk
Subject: Re: Message Board
Mark A. Kruger - CFG wrote:
uh what?
Is not the java programming
Rick,
yeah - me neither (dropping it)... plus I get so dang pompous when I'm arguing - it's not a side of me I like g.
-mk
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Friday, June 11, 2004 2:41 PM
To: CF-Talk
Subject: Re: Message Board
Mark A. Kruger - CFG wrote
didn't want to confuse the issue.
Cheers,
barneyb
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 01, 2004 5:43 AM
To: CF-Talk
Subject: RE: CFQUERY - MySQL Chicken and Egg
Not exactly true that you have to use the native interface
Not exactly true that you have to use the native interface for all rdbms's.In MsSQL (and other rdbms's)if you have
the proper permissions you can create multiple databases and use them from a single datasource. The reason it's not
often done is that you must know something about the physical
John,
Your syntax would output like this:
where 15 IN (sharedGroupIds)
If I'm reading your right this is backwards - it should be column INvalues or sharedGroupIds IN (15)
Unfortunatley the IN clause is not going to work for you with a column of values because it uses equals against each
PS
the CAST convert functions won't help here. The problem is in trying to treat a list of values in a single character
column as if they were separate entities. SQL doesn't do lists like that.
-mark
-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May
Barney,
I'd love that error handling code.I'll give you a plug on my blog.
-mark
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 04, 2004 5:48 PM
To: CF-Talk
Subject: RE: Database error messages
Whoops, no attachements on cf-talk.That must be
Yes - but all the developers must have a subscription - right?
-mk
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 05, 2004 8:21 AM
To: CF-Talk
Subject: RE: ColdFusion Developer Edition
Ok I know there is a ColdFusion Developer edition, but here
is
://www.pubforum.net/postsp4.htm
Be careful when you run it - there is probably a reason it's only available from tech support g.
Mark A. Kruger, MCSE, CFG
www.cfwebtools.com
www.necfug.com
http://blog.mxconsulting.com
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 20
Does anyone remember how to figure out what version of MDAC is installed on their server?
Mark A. Kruger, MCSE, CFG
www.cfwebtools.com
www.necfug.com
http://blog.mxconsulting.com
...what the web can be!
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Dave,
awesome - that's what I was looking for - thanks!
-mark
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 21, 2004 3:29 PM
To: CF-Talk
Subject: RE: determining the correct version of MDAC
Does anyone remember how to figure out what version of
Bryan,
Reboot and hit f8 - then choose last known good configuration from the screen - you may need to do this once or twice.
-Mark
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Friday, April 16, 2004 2:01 PM
To: CF-Talk
Subject: Re: Latest Windows Updates
I
I use the DTS package designer wizard in SQL to create a DTS script for this.If you must drop the tables each night
then the procedure is:
drop tables
create tables (no indexes or constraints)
copy data in
-AT this step can do many things including clean up the data, merge the data etc.
Run
Dave,
That's not what I'm finding.If you have a robots.txt file that says:
disallow /search.cfm
It will not index the search.cfm file from the root of the server. But I cannot find anywhere where you can put in
something like this:
disallow http://www.someothersite.com
You see what I mean?
P.S. Actually he had NO caching and that is our first step - and it has been quite successful.
-Mark
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Sunday, April 04, 2004 5:23 PM
To: CF-Talk
Subject: RE: user agent checking and spidering...
Sequelink (the access
and spidering...
Mark A. Kruger - CFG wrote:
Dave,
That's not what I'm finding.If you have a robots.txt file that says:
disallow /search.cfm
It will not index the search.cfm file from the root of the server. But
I cannot find anywhere where you can put in
something like this:
disallow http
will be appreciated - thanks!
-Mark
Mark A. Kruger, MCSE, CFG
www.cfwebtools.com
www.necfug.com
http://blog.mxconsulting.com
...what the web can be!
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
but will also cost you.
Let me know if you want my database.
Jim Davis
_
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]
Sent: Sunday, April 04, 2004 2:06 PM
To: CF-Talk
Subject: user agent checking and spidering...
Cf talkers,
I have a client with many many similar sites on a single server
make sure and delete all the jsp files. What is probably happening is that CF (i.e. Jrun) is being tasked by IIS to
serve the JSP pages, but you have the wrong version to do it (like CF professional).Also, go into the site properties
and make sure that CF is NOT tasked with serving JSP pages
a user to go to marySmith.blah.com - both tricks are
great for sales CRM tools, real estate sites and the like - any place where you want a use to have a personal website
but it actually connected to a larger group or site.
-mark
Mark A. Kruger, MCSE, CFG
www.cfwebtools.com
www.necfug.com
http
If you are using IIS check out a thread from earlier today
http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid=31591forumid=4
Mark A. Kruger, MCSE, CFG
www.cfwebtools.com
www.necfug.com
http://blog.mxconsulting.com
...what the web can be!
-Original Message-
From
Gabriel,
The web server already has to parse the header, determine if the file exists and point to the file (or 404 handler) -
yes I would imagine that there is a bit more overhead than if the file/folder existed in the first place - but I have
several sites doing this and similar things, some of
Deos anyone know of any software similar to:
http://www.webscribble.com/products/webaffiliate/requirements.shtml
That's runs on IIS and (possibly) CF?
Mark A. Kruger, MCSE, CFG
www.cfwebtools.com
www.necfug.com
http://blog.mxconsulting.com
...what the web can be!
[Todays Threads
: Mark A. Kruger - CFG [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, March 31, 2004 6:38 AM
Subject: RE: IIS Custom Error Pages in CF?
Yes you can.
1) Go into IIS properties for your site and choose the custom errors
tab.
2) Select the 404 error and choose edit.
3) change
You know... I love this idea - very cool I had not thought of that.
-Mark
Mark A. Kruger, MCSE, CFG
www.cfwebtools.com
www.necfug.com
http://blog.mxconsulting.com
...what the web can be!
-Original Message-
From: Nick de Voil [mailto:[EMAIL PROTECTED]
Sent: Monday, March 29, 2004 8
That is sneaky...
-Original Message-
From: Brook Davies [mailto:[EMAIL PROTECTED]
Sent: Monday, March 29, 2004 12:11 PM
To: CF-Talk
Subject: OT: Sneaky Virus
I just got this sneaky ass virus. The link in the email looked like a URL
and it had my domain in it so I thought I would click on
I believe this was a bug were the page length for compile can't be more than 64 k.If I remember correctly it was fixed
in 6.1 when the compiler was moved to direct to bytecode instead of creating intermediate source files and then
compiling it. I could be way off... but are you on 6.1?
or you have control over the environment. But if you are on a shared server be careful because everyone can
include from your directory now using the root mapping. savy?
Mark A. Kruger, MCSE, CFG
www.cfwebtools.com
www.necfug.com
http://blog.mxconsulting.com
...what the web can be!
-Original
Did I misunderstand this - I think he IS asking why he can't use cfinclude exaclty like he uses img... why img
src="" works and why cfinclude template=/images/blah.cfm doesn't... right? I don't think he's
asking how to use the image tag, I think he's asking how to get at the root using cfinclude -
CTED]
Sent: Thursday, March 25, 2004 1:56 PM
To: CF-Talk
Subject: Re: Okay, bear with me, I'm not even sure what I'm asking...
- Original Message -----
From: Mark A. Kruger - CFG [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, March 25, 2004 2:36 PM
Subject: RE: Okay, bear wi
yes... just download the trial and install the client tools only. they do not expire.
-Original Message-
From: Jeremy [mailto:[EMAIL PROTECTED]
Sent: Monday, March 22, 2004 8:54 AM
To: CF-Talk
Subject: RE: sql server
Is that a free download.
-Original Message-
From: Adkins, Randy
.
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]
Sent: Friday, March 12, 2004 2:51 PM
To: CF-Talk
Subject: RE: Quick SQL Question...
The 2 are mutually exclusive.One is the group of all the stuff on
this
day, but the other (the actual date) is not merely a date
this helps you.
Mark A. Kruger, MCSE, CFG
www.cfwebtools.com
www.necfug.com
http://blog.mxconsulting.com
...what the web can be!
-Original Message-
From: Reed Powell [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 14, 2004 3:00 PM
To: CF-Talk
Subject: HTTPS: what factors disable it?
Once again
Wow... that's a hefty updater.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
,creationdate) + '-' + datepart(year,creationdate) AS
datelabel
group by datepart(dw,creationdate)
order by datelabel
or something similar.The DateName( ) function would work as well - maybe
better. It usally takes some work to get it exactly right.
-Mark
Mark A. Kruger, MCSE, CFG
www.cfwebtools.com
How about:
WHERE(name LIKE '%Open%'or name LIKE '%Engineering%') AND name NOT LIKE
('%closed%')
Personally, this is probably not the best way to handle status.I always
have a status field - either an int or a small character field and use a
constraint
('open','closed','pending') and always be
.
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 09, 2004 10:12 AM
To: CF-Talk
Subject: RE: SQL Help
How about:
WHERE(name LIKE '%Open%'or name LIKE '%Engineering%') AND name NOT LIKE
('%closed%')
Personally, this is probably not the best way
David,
Yes but this may OR may not return them in the order you are looking for.
However, there IS an easy way to use the UNION operator this way (for
ordering). You need to stop using the asterisk (stop it! bad programmer!!).
Try this:
--
SELECTcol1,
.
-
Hugo AhleniusE-Mail: [EMAIL PROTECTED]
Project Officer Phone:+46 8 230460
UNEP GRID-ArendalFax:+46 8 230441
Stockholm OfficeMobile:+46 733 467111
WWW: http://www.grida.no
-
Original Message
From: Mark A. Kruger - CFG [EMAIL
Did you check all your database settings to ensure they are the same (clobs and blobs and select method etc)?Have you
tried creating a datasource on the test server that points to the live server then running your proc to see if it works?
-mk
-Original Message-
From: Adrocknaphobia
Nick,
I've found cf flush to be useful when you are serving up long tabular report data.If you are going to output several
hundred rows, cfflush can help a lot.One approach I've used that works great for intranet sites where the browser is a
known item is a combination of a status bar,
Stored procedures are not cached queries - they are compiled execution plans. The thing that makes the difference is the
databinding. SQL knows what type a variable is prior to execution of the query. So it does not have to check in the
system tables to see what type it should be using.For
basically
cfquery datasource=blah
insert into clntnote (thisdate,subject,note,type,compid)
values ('#form.thisdate#','#form.subject#','#form.note#','#form.type#',#form.compid#)
/cfquery
You will need to debug it of course.
-Mark
-Original Message-
From: Steven Sharko [mailto:[EMAIL
Steven,
You need single quotes around all char data... as in '#form.subject#'. You will need to correctly format the date as
well. Try using #createodbcdate(form.thisdate)#for that item.Also - as has been suggested a couple of times - using
CFQUERYPARAM would be a good idea - faster, and safer -
Steven,
I would add one more thing. Rather than beat your head agains the wall in CF, get a quick book - the teach yourself SQL
in24 hours would do nicely - and use the query analyzer or some other raw tool where you can pass in queries and
view results. Take a half a day and learn SELECT ,
Steven,
yes... if you use createodbcdatetime() or createodbcdate() to massage the variable thisdate into something that
looks like {ts '2004-02-25 09:49:00'}Then you must REMOVE the single quotes around that one... also, is the column
name really thisdate?Remember the name of the column and the
about it.If any of you have any interest let me know and I will
get you in contact with her.
Mark A. Kruger, MCSE, CFG
www.cfwebtools.com
www.necfug.com
http://mxc.blogspot.com
...what the web can be!
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Yes but Query of queries DOES support the union key word.
-Mark
-Original Message-
From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED]
Sent: Monday, February 23, 2004 2:01 PM
To: CF-Talk
Subject: Re: SOT: SQL question
As listed in the original post, my ISP is using MySQL 3.23 (which
A)did you restart both IIS and the Cold fusion?
B)Can you resolve HTMLpages in the appropriate directories
C) Did you (or did you consider) rerunning the remove/add connector script?
-Mark
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 22, 2004
Ian,
one guess:
cfquery name=recordset_search datasource=#MM_Universe_Connection_DSN#
username=#MM_Universe_Connection_USERNAME#
password=#MM_Universe_Connection_PASSWORD#
Put quotes around the username and password and datasource:
cfquery name=recordset_search
Ryan,
Yeah - your function is using a var to set your service.The responder is out of scope. get rid of the var.
-mark
-Original Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 06, 2004 4:28 PM
To: CF-Talk
Subject: Re: flash remoting help: UPDATED
Ok, lets
1 - 100 of 975 matches
Mail list logo