Thanks to point me to this very interesting custom tags. BTW, I like your site and the two guides you did on variables and locking are very good.
What happened because you are not updating the site too much?
Jean-Marc
-Message d'origine-
De : Jim Davis [mailto:[EMAIL PROTECTED]
Envoy
I am getting:
Local variables must be initialized.
The variable dayList near line 7, column 5 lacks an initializer.
For this code in the constructor of a CFC when I create an instance:
6: var dayList=structNew();
7: var
Any ideas what might be up, as dayList looks fairly well initialized to me :-)
May be it is too much initialized ;-)
Do you need var in line 7 ?
Just try:
var dayList=structNew();
dayList[1]=createObject('component','com.bluefiner.ceo.tracklogDownloadTimes.day');
--
Thomas Chiverton said:
Local variables must be initialized.
The variable dayList near line 7, column 5 lacks an initializer.
For this code in the constructor of a CFC when I create an instance:
6: var dayList=structNew();
This is a structure.
7: var
Hi,
Any one aware of some custom tag or function that would detect and decode lines in messages
headers encoded like:
From: Claude =?iso-8859-1?Q?Schn=E9egans?=
--
___
See some cool custom tags here:
http://www.contentbox.com/claude/customtags/tagstore.cfm
On Tuesday 25 May 2004 11:44 am, Jochem van Dieten wrote:
This is a structure.
Changing to arrayNew() makes no difference, though I did mean array as there
are another 6 items :-)
(Claude) That was it, cheers.
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email:
CFX_POP3 can load in e-mails and parse them from POP accounts or disk. It
supports over 25 character sets so should be fine for what you need.
http://www.web-architect.co.uk/downloads.cfm
If you don't need anything so complicated and just need to parse arbitrary
strings, mail me off list and
Hi,
I am in the process of re-installing software on 5 machines in our office.
For various reasons I want to start from scratch and make sure a the windows
software is up to date.
I have instaled everything I want on one machine and and have cloned a copy
of it all onto another using Drive
Hi Kevin,
Yes the new MM products (excluding CFMX) have Product Activation which
prevents you running one copy on multiple machines if you have already
activated the softwareTry using the Transfer license tool under Help as it
would seem you have cloned the machine after you have activated the
As an Aussie, what does hootchie mean?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
From: Thomas Chiverton
I am getting:
Local variables must be initialized.
The variable dayList near line 7, column 5 lacks an
initializer. For this code in the constructor of a CFC when I
create an instance:
6: var dayList=structNew();
7: var
I have the demo version of CFMX installed. Finance has verbally approved
the purchase of a license, but it has not been approved by capital yet,
and they do not meet for another two weeks. Typical beaureaucratic
stuff.
My problem is that I need a team to start doing data entry via one of my
CF
When you log into your CF admin doesn't it tell you how many days are
remaining in Evaluation mode? After it expires it will become the Developer
edition, single IP address only.
Don't think it's as simple as reinstalling CF to get those additional days,
Jb.
-Original Message-
From:
I have created a web service (or attempted to) which is giving me an
error.Can anyone give me insight into this issue?The final service
will be more complicated, but I can't even get it to recognize my
parameters.Any help would be great!
--Jeff
Here is the error:
Web service operation
Simple solution if possible ... host the app somewhere else and let the data
entry happen there?
-Original Message-
From: Claremont, Timothy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 2:46 PM
To: CF-Talk
Subject: CF license limitations
I have the demo version of CFMX
Jeff Langevin wrote:
I have created a web service (or attempted to) which is giving me an
error.Can anyone give me insight into this issue?The final service
will be more complicated, but I can't even get it to recognize my
parameters.Any help would be great!
It looks like you are passing a
Jeff Langevin wrote:
I have created a web service (or attempted to) which is giving me an
error.Can anyone give me insight into this issue?The final service
will be more complicated, but I can't even get it to recognize my
parameters.Any help would be great!
You can only pass a struct as
I don't have access to the GUI tools here at the college.Our IT
has told
my partner here that they're insecure so off-limits.
FWIW, SQL Plus is hardly a gui. It's the standard Oracle client tool.
Just to note, I asked the University myself (instead of relying on the info from others) if
Call Macromedia and explain your situation.They may be willing to work
with you.We had a similar situation last year, and they extended the
length of the demo for us.
-Original Message-
From: Claremont, Timothy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 6:46 AM
To: CF-Talk
I have a set of radio buttons on a page where a user picks a service
category...say c24.
c24 is then passed to the results page as the variable
SelectedService.
On the results page I loop through all records in a database and show
the value of field c24 (SelectedService).
However, in my table,
whats the radio button look like?
input type=radio name=c24 value=c24
does it look like this?
that would make sense, if it does.
here is what you probably want.
input type=radio name=c24 value=1
that will show c24 as on, or 1, or whatever, just change the value=
parameter to be what you
Hmmm... that makes sense, but now I get:
Web service operation availability with parameters {rcl,05,30,2004}
could not be found.
When I used cfinvoke, I got something similar.
--Jeff
Rick Root wrote:
Jeff Langevin wrote:
I have created a web service (or attempted to) which is giving me
I don't understand. Some code maybe?
Here is the first page:
cfform action="" method=POST
cfinput type=Radio name=SelectedService value=c24Nursingbr
cfinput type=Radio name=SelectedService value=c23NPbr
cfinput type=Radio name=SelectedService value=c30HHAbr
cfinput type=Radio
I'm getting this strange error in my Production environment. Not sure what
it means. Not reproducible in DEV.
Anyone see this before?
An error occurred while evaluating the _expression_: PPRE
url.ThisIsGoodPathToGetBack = #cgi.PATH_INFO# /PRE/P/PError near
line 237, column 11.HRPCannot assign
From: daniel kessler
Just to note, I asked the University myself (instead of relying on the
info from others) if there are any tools that we can use to work with the
Oracle DBs and I was told that there's nothing that you can't do with a CF
entry that you can with those tools.It's more secure
heh.
the value is c24
you may have the wrong choice of form elements here.
whats ur intended result?Nursing?
tw
-Original Message-
From: Tim Claremont [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 10:31 AM
To: CF-Talk
Subject: Re: Variable Confusion
I don't understand. Some
hey,
one last email, thank you everyone for helping vishnu.
he now owns a fully legal, licensed copy of cfmx exam buster.
cheers.
good karma, it sure goes a long way
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
[Todays
I think you may need to prefix your variables:
qMyQuery.SelectedService
Although this is not likely. Maybe your query is retreiving the wrong
value (id instead of value). Did you try dumping the query?
-Original Message-
From: Tim Claremont [mailto:[EMAIL PROTECTED]
Sent: dinsdag
What, you mean it's returning c24 instead of nursing?Well, since
that's what you're telling it to do, that's not surprising.If you want
to return nursing you probably need to do something like this:
cfinput type=Radio name=SelectedService value=c24,nursingNursingbr
Followed by:
CFX_POP3 can load in e-mails and parse them from POP accounts or disk.
Of course, I didn't think of it, but this tag is installed on my server, this is the solution!
Thanks.
--
___
See some cool custom tags here:
That's cool
Vishnu, pay it forward!
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 10:35 AM
To: CF-Talk
Subject: sorry. cfmx exam guy.
hey,
one last email, thank you everyone for helping vishnu.
he now owns a fully legal, licensed copy of
On Monday 24 May 2004 20:04 pm, Nikhil Madani wrote:
How can I handle this gracefully and redirect the user to a default method
or another page?
Set a default error handler in the CF admin.
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
Hi,
I have just a sample _javascript_,
var xmlDoc='?xml version=1.0 encoding=iso-8859-1?cfColdfusion/cf';
var xmlHttp = new ActiveXObject(Microsoft.XMLHTTP);
xmlHttp.open(POST, index.cfm?fuseaction=agentsmith.return_wp_list, false);
xmlHttp.send(xmlDoc);
the url is targeting a circuit within a
Ok, I figured it out.
It worked once I changed:
cfargument name=facility required=Yes type=string
cfargument name=month required=Yes type=numeric
cfargument name=day required=Yes type=numeric
cfargument name=year required=Yes type=numeric
To:
cfargument name=facility type=string
cfargument
c24 really is the value I want to pass when someone chooses 'Nursing'.
I have a TABLE named c24. The query statement returns all of the data from the table named c24.
There is a FIELD in table c24 that is ALSO called c24 (poor practice).
By passing the value 'c24' when someone selects Nursing,
Is there a reason why you don't have the value of the SelectedService
as the display item?
cfinput type=Radio name=SelectedService value=NursingNursing
cfinput type=Radio name=SelectedService value=NPNP
cfinput type=Radio name=SelectedService value=HHAHHA
Thus when you insert it to the DB:
it
wow.
I was following you, until the end, and now im lost.
you have this table:
c24 (table name)
-
c24 (column name)
and when you query this you do this:
select c24 from c24
and you dump that
cfdump var=#c24#
I can see that confusing things, a bit.really bad design.
but,
ok let me get this straight:
You have a table called:C24 which contains all the
data elements for Nursing?
And within that table (C24) you have another field called C24
so in theory you have the following:
C24.C24which references the table (c24) and the field (c24)?
In your results
No, I am with you,... confusing by the Database
design of that... Maybe there is some logic
behind it, but far be it for me to try and decipher.
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 11:00 AM
To: CF-Talk
Subject: RE: Variable Confusion
I'm a bit lost, but I think that this is what you're after:
#qMyQuery[form.selectedService][qMyQuery.currentRow]#
As an alternative, you could use an alias in your query
SELECT #selectedService# AS theSelectedService
And use that in the display later:
#qMyQuery.selectedService#
Pascal
PS
This may be a simple one, but I'm a bit slow this morning...and stumped.
I have a form that is populated with a cfquery so a field looks like this:
input type=text VALUE=#findvendor.ponumber# name=vendor size=35 maxlength=30
How is this then set to another form where an update (cfquery with the
Typo below
-Original Message-
From: Pascal Peters
Sent: dinsdag 25 mei 2004 17:14
To: CF-Talk
Subject: RE: Variable Confusion
SELECT #selectedService# AS theSelectedService
And use that in the display later:
#qMyQuery.selectedService#
#qMyQuery.theSelectedService#
Is there a reason why you don't have the value of the SelectedService
as the display item?
cfinput type=Radio name=SelectedService value=NursingNursing
cfinput type=Radio name=SelectedService value=NPNP
cfinput type=Radio name=SelectedService value=HHAHHA
Thus when you insert it to the DB:
Strange one. I removed the assignment saved. Put it back and it works. Go figure.
-Frank
- Original Message -
From: Frank Mamone
To: CF-Talk
Sent: Tuesday, May 25, 2004 10:34 AM
Subject: Cannot assign result to symbol
I'm getting this strange error in my Production environment.
form.vendor (this is the name of your input)
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: dinsdag 25 mei 2004 17:12
To: CF-Talk
Subject: simple form field question
This may be a simple one, but I'm a bit slow this
morning...and stumped.
I have a
Pascal's Solution worked perfectly! Thanks a ton!
I will not inherit other people's databases
I will not inherit other people's databases
I will not inherit other people's databases
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Try changing '#trim(form.ponumber)#' to '#trim(form.vendor)#'. Watch out! without a WHERE clause your query will
change every ponumber to the form value and some poor vendor may get rich
quick ;)
-mike
Robert Orlini [EMAIL PROTECTED]
05/25/2004 11:11 AM
Please respond to cf-talk
To:CF-Talk
Can you send the query that you're using so we can see what you're doing
wrong?
John
-Original Message-
From: Tim Claremont [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 11:20 AM
To: CF-Talk
Subject: Re: Variable Confusion
Is there a reason why you don't have the value of the
Thanks Pascal.
I realized my mistake and edited the input field as:
input type=text VALUE=#findvendor.ponumber# name=form.ponumber size=35 maxlength=30
But still get an error on the next page that it cannot find the value for form.ponumber.
Robert O.
-Original Message-
From:
You don't name a form field as form.ponumber
You just name is ponumber and it will automatically be in the form
scope.
input type= name=ponumber
Will come through on the next page as #form.ponumber#
John
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent:
input type=text VALUE=#findvendor.ponumber#
name=ponumber size=35 maxlength=30
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: dinsdag 25 mei 2004 17:27
To: CF-Talk
Subject: RE: simple form field question
Thanks Pascal.
I realized my mistake and edited
Your statement should read:
name=ponumber
NOT
name=form.ponumber
Cause it will inheret the form scope.
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 11:27 AM
To: CF-Talk
Subject: RE: simple form field question
Thanks Pascal.
I
Like I said a simple problem and a simple fix. I originally had the wrong name for the field. I need new glasses.
input type=text VALUE=#findvendor.ponumber# name=vendor size=35 maxlength=30
Thanks all.
RO
-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent:
Why are you doubling your quotes?Doing that should try to escape the
quotes which then means you've got an unquoted string.
Could this be the problem?
Jim Davis
_
From: Frank Mamone [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 10:34 AM
To: CF-Talk
Subject: Cannot assign result to
Ive been (trying) to redesign the site but life keeps getting in the way.
Im actually getting close now.
The new site will look pretty much the same, but have a more advanced
CFC-based session and user management system and hopefully a few other nifty
features.
Thanks for the vote of
I'm trying to use DateDiff to determine if a call has been logged by 10:00
am on the third weekday. I can use 'd' to get the third day but I cannot
count Saturday or Sunday.
For instance, if your collection day is Tuesday and your item was not
collected, you must call before 10:00am Friday,
Use 'w' instead, it'll ignore weekend days.
Cheers,
barneyb
-Original Message-
From: Shannon Carr [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 9:28 AM
To: CF-Talk
Subject: DateDiff to determine number of weekdays past?
I'm trying to use DateDiff to determine if a call
Use w as the parameter in you datediff function.According to the documentation it is for weekdays as opposed to all days of d and ignores Saturdays and Sundays.
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
C code. C code run. Run code run. Please!
-
I posted 2 custom tags a few years ago under the Allaire Developer's Exchange: CF_DHTMLQUERY and CF_SQLWIZARD.
Now since either it changed to Macr or was rewritten in Flash I've lost my tags.
Did they clear out old tags at some point?
[Todays Threads]
[This Message]
[Subscription]
[Fast
I tried 'w' but it is returning records more than 3 days old.
I found the following earlier:
When datepart is Weekday (w), DateDiff returns the number of weeks between the two dates. If date1 falls on a Monday, DateDiff counts the number of Mondays until date2. It counts date2 but not date1.
From: Shannon Carr
I tried 'w' but it is returning records more than 3 days old.
What do you mean by returning records?
If you're using it in a Query of Query, then you can use DateDiff, but
if you're using it in a CFQUERY, then you'd be betting checking on the
database specific
How is this:
Evaluate(SELPROJECT issueID)
(issueID is a variable)
Equal to this?:
Error resolving parameter SELPROJECTFORM.IDLISTA
Here is the whole code:
cfloop index=issueID list=FORM.idListA
cfquery datasource=Tribal_Matrix name=getProject
SELECT *
FROM v_Project
WHERE Project_Nm =
I would imagine the encoded string would have to be inside CDATA tags.
You could base64 encoded and send as string...
I found this very interesting article on this topic
http://www-106.ibm.com/developerworks/xml/library/x-tippass.html
[Todays Threads]
[This Message]
[Subscription]
[Fast
Yeesh.
huh, that's exactly what I said!
That's very very unfortunate. Perhaps you should pester your DBA's to
write the trigger for you, then. ;)
yep, that'd be me : )Actually I'm a Director/Flash guy forced into a bit of CF (which I really like).Maybe I'll be able to get some DB classes
If you just want to run that command, you can use CFEXECUTE.If you want to
run it in the same JVM as CF (in page), then you're going to have to add
that JVM argument to the JVM arguments in the CF admin (so it's on CF's
JVM), and then you should be able to do it.Have you tried building a
program
Just use this instead:
form[selproject issueid]
example:
where Project_Nm = #form[selproject issueid]#
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
From: Morgan Senkal
cfloop index=issueID list=FORM.idListA
cfloop index=issueID list=#FORM.idListA#
#StructFind(FORM,Evaluate(SELPROJECT issueID))#
#form[SELFPROJECT#issueID#]#
Also
CFQUERYPARAM!!!
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User
Maybe like this (if form.idListA contains a list of numbers)
cfloop index=issueID list=#FORM.idListA# cfquery
datasource=Tribal_Matrix name=getProject SELECT * FROM v_Project
WHERE Project_Nm = #FORM[SELPROJECT issueID]#
/cfquery
/cfloop
If form.idListA contains the maximum maybe it should
WHERE Project_Nm = #StructFind(FORM,Evaluate(SELPROJECT issueID))#
WHERE Project_Nm = #FORM[SELPROJECT issueID]#
Try that.Should work better.Or should tell you issueID contains the
wrong data.
--Ben Doom
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User
The 20th is more than 3 days before the 25th and it's displaying in the if statement.
cfset call_logged = Createdate(04,05,20) !--- thursday---
cfset today = CreateDate(04,05,25) !--- tuesday ---
cfoutput
call_logged_date: #call_logged#brbr
today: #today#br
hr
!--- if it's before 3rd weekday
On May 24, 2004, at 6:06 PM, Mark Murphy wrote:
CFWDDX action="" has a bug
Thanks, Mark.I will report this issue.
Christian
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
If there is a weekend in the time span, then the dates will be five days apart, so that sounds correct to me?
Thursday 20th
Friday 21st 1st week day.
Saturday 22nd not counted.
Sunday 23rd not counted.
Monday 24th 2nd week day.
Tuesday 25th 3rd week day.
If this is not the correct result, then
Thanks I've added the following to the end of java.args
-Dorg.xml.sax.driver=org.apache.xerces.parsers.SAXParser
-Djavax.xml.parsers.DocumentBuilderFactory=org.apache.xerces.jaxp.DocumentBu
ilderFactoryImpl
-Djavax.xml.parsers.SAXParserFactory=org.apache.xerces.jaxp.SAXParserFactory
Impl
Thanks I've added the following to the end of java.args
-Dorg.xml.sax.driver=org.apache.xerces.parsers.SAXParser
-Djavax.xml.parsers.DocumentBuilderFactory=org.apache.xerces.jaxp.DocumentBu
ilderFactoryImpl
-Djavax.xml.parsers.SAXParserFactory=org.apache.xerces.jaxp.SAXParserFactory
Impl
Is this good idea?If not; is there an article I can referance for my managment?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Can CFLocation point to a file and open it in a new window? I'm using frames. Are there other options if this is not possible?
Roberto O.
HWW
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
I guess you could cflocate to a page that has a body >
type function
that would then pop open that new window?
tw
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 3:10 PM
To: CF-Talk
Subject: cflocation question
Can CFLocation point to a file
Can CFLocation point to a file and open it in a new window?
I'm using frames.
No, CFLOCATION generates an HTTP response header on your server, which
doesn't know anything about frames or windows. Whichever frame or window
contained the document with the CFLOCATION tag, that's where the new
Can't handle medium to large user loads
-Original Message-
From: David Brown [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 1:59 PM
To: CF-Talk
Subject: MS Access as a backend database
Is this good idea?If not; is there an article I can referance for my managment?
_
[Todays
I am having a bit of trouble doing a date search on form entered data.
Originally, I created a date with CreateDate and submitted it, then
searched on it with a date created the same way (usingWHERE
event_date = #show_event_date#) and all was great.
Then I was told to also collect the time.Who
From: David Brown
Is this good idea?If not; is there an article I can
referance for my managment?
Think of it this way
MS Access is a desktop application, it's designed for working on
people's desktops
If you want a server application, then use a server application
Just as a note, the
From: Robert Orlini
Can CFLocation point to a file and open it in a new window?
I'm using frames. Are there other options if this is not possible?
Simply put
ColdFusion = Server Side
Browser = Client Side
So, whatever happens with CF, it will only pass information back to a
user's browser
While I wouldn't recommend Access to anyone - this isn't exactly true. When
I use to run Death Clock, I would get 3-4.5 million hits a month. The site
ran with no problems using Access as the back end database. Now - I cached
the heck out of things - but not everything. I guess the point is - if
does it also have any of the limitations like excel does,
where 65536 is its magic number of limitations?
tony
-Original Message-
From: Philip Arnold [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 3:31 PM
To: CF-Talk
Subject: RE: MS Access as a backend database
From: David
Should be used for testing only. If you are going to use it on a
production website, the site should have very little traffic. If not, be
prepared for trouble. I could list a million and 1 horror stories where
an Access DB was the root of the problem.
Dan Phillips
CFXHosting.com
[EMAIL
Bad idea for so so many reasons.
First, not at all scalable as a DB.Need more horsepower for an Access
DB?Buy a more powerful machine.Need more power for SQL Server?
Cluster it.
Second, horrible for design maintenance.Need to make a change to an
Access database?You've got to take it
Hi David,
It depends on many factors: budget, size, infrastructure, security,
concurrent users, etc.
We've been using Access as a backend db for an internal app for 2 years
without a hitch... That is, until 2 weeks ago, after a migration meeting
(oracle) with my boss (approved :) -- when we
Also have a very small limit on concurrent access (queries)
==
Our Anti-spam solution works!!
http://www.clickdoug.com/mailfilter.cfm
For hosting solutions http://www.clickdoug.com
http://www.forta.com/cf/isp/isp.cfm?isp_id=1069
Simple, change this:
cfloop index=issueID list=FORM.idListA
to:
cfloop index=issueID list=#FORM.idListA#
You just need to identify the list coming from a variable - otherwise it's reading (FORM.idListA) as the actual listing.
HTH
-Original Message-
From: Morgan Senkal
I concur.We started out on Access and what a pain after about two
years.Moved to SQL Server.Now I get sleep... ;-)
At 12:32 PM 5/25/2004, you wrote:
Should be used for testing only. If you are going to use it on a
production website, the site should have very little traffic. If not, be
prepared
this isn't exactly true. When
I use to run Death Clock, I would get 3-4.5 million hits a month.
I will vouch this statement.
The user limit curse of Access is pure urban legend.
The PROGRAM Acces installed in a lan does have a limit, but as far as CF is concerned,
the Access program is not used
cfscript
function WeekdaysBetween(date1,date2){
var out = 0;
var tmp = ;
if(DateCompare(date1,date2) GT 0){
tmp = date1;
date1 = date2;
date2 = tmp;
}
if(DayOfWeek(date1) IS 1) date1 = DateAdd(d,-2,date1);
if(DayOfWeek(date1) IS 7) date1 = DateAdd(d,-1,date1);
if(DayOfWeek(date2) IS
You'll need to tell the database what you want to search on. There are a
number of ways to do that. What you probably want is something like this:
SELECT your columns
FROMyour table
where to_char(event_date, 'dd-mon-') = to_date('05/03/2004',
'mm/dd/')
This assumes that you're using the
From: Claude Schneegans
I will vouch this statement.
The user limit curse of Access is pure urban legend.
The PROGRAM Acces installed in a lan does have a limit, but
as far as CF is concerned, the Access program is not used nor
is installed on the server.
I should change my name to Mr
Only the ODBC driver is used on a flat .mdb file, and only
ONE user at a time accesses the database:
ColdFusion is the user. This driver is just as good as the
Oracle or SQL Server driver.
The driver is only part of the puzzle.There is a hard limit on what Access
can handle (I don't know
Anyone knows a good free mailing list script in CF to administer mailing
lists?
Thanks
Pat
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
So, instead of createDate, I went to
createDateTime.Since then, I've not been able to search on these
items with my query that uses CreateDate.It doesn't seem right to
have to include the time for searching, especially since I just want
items on a particular date or series of date.
I'm not
Has anyone worked with the Collage content management system? On paper they
say it works great with CF since it's basically hands-off with the code and
it just deploys it to the production server as opposed to being a live CMS
that builds pages at display time. That's on paper. I'm hoping someone
dan.
I do this:
select *
from yourTable
where date between '05/01/2004 00:00:00.000' and '05/01/2004 23:59:59.999'
if I want the events of a day.
and of course you can do some slick stuff to create those datetime combos
does that get what your looking for?
tw
-Original Message-
the replace works if you double all those pound signs.
replace(query.fieldname,##,,ALL)
because this can be hard to read, I often set it to a variable.
lb = ##;
replace(query.fieldname,lb,lblb,ALL)
-Original Message-
From: David Jones [mailto:[EMAIL PROTECTED]
Sent: Monday, May 24,
1 - 100 of 131 matches
Mail list logo