If I have this string:
'1231/04'
And I pass it to "IsDate( )"
It returns True.
IsDate(var) = TRUE
If I pass it to DateFromat( ) it returns:
01-Apr-31
Can someone explain to me if this is expected behavior or if it's unusual?
-Mark
[Todays Threads]
[This Message]
[Subscription]
[Fast
On Tuesday 02 Dec 2003 02:08 am, Barney Boisvert wrote:
> took upwards of 45 seconds on a reasonably beefy machine (dual P-III 666).
I wouldn't call that 'reasonably beefy' these days.
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Li
No, I just tried it and I couldn't get it to work.
But you can use between
select count(idField)
from yourtable
where type = 'checktype'
and (startDateField between 'startdate' and 'enddate'
OR endDateField between 'startdate and 'enddate')
Of course change all of the 'variables' to ei
Is there a way, though, to have the user push a button on a page which you initiate the DTS transaction? The project's end users want to be able to initiate a data dump at any time, rather than at a regular interval.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User
I didn't say anything about read speed. I agree, verity is quite fast for
that. The updates, however, are slow like a dog. I don't think anyone can
argue that one. If you've got a collection using verity that doesn't change
a whole lot, then verity is great (and free, if the collection is small
the same way you would take over their machine and log in and delete all the
files on their machine :)
no can do...but you can force their browser to download it, well force to
the point that they have to click on save/open, but that's about all.
...tony
tony weeg
senior web applications archite
Sorry to leave...
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
I know how to output data to an excel spreadsheet but how to make it save the excel file to their local machine? C:\... saves it server side as well..
Any help would be appreciated, thanks.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Hi Scott,
Would you mind sending me the domain name offlist of the site that is working with SES and 6.1 that may help me get a resolution to the problem, I can have them copy the config. If that is ok
Mike
- Original Message -
From: Scott Brady
To: CF-Talk
Sent: Tuesday, Dece
not going to work in sql server 2000, not from what I can see in the
docs
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: Candace Cottrell [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02,
title="Titlee" query="qryActive" body="What do you want to search on"
custom1="Whatever else you what to return" custom2="One more return variable">
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 8:57 AM
To: CF-Talk
Subject: CF V
As far as we know here at Macromedia, Verity (specifically the file filters, see the Verity log files in the collection) does not work on any Red Hat release higher than 7.2. Behaviors include successful indexing with nothing in the index or strange crashes when doing a search.
We do recommend th
Did it work?
- Original Message -
From: Hassan Arteaga Rodriguez
To: CF-Talk
Sent: Tuesday, December 02, 2003 4:51 PM
Subject: RE: [cftalk] About CFChart..
I created it..the same problem!!
__
MSc. Hassan Arteaga Rodríguez
Microsoft Certified System Engineer.
DIGI- G
Hello everybody,
I need some help with the cfldap tag. I am quering the
Active Directory, I have a user
and I want to check if this user is a member of a
group. Here is my code
action="">
name="adQuery"
server="ldapServer"
start="cn=Media Support,ou=Miscellaneous,ou=task
groups,ou=groups,ou=sup
Allan:
D:\WEB_Data is my root dir for web sites...then i have GraphData.cfm in
D:\WEB_Data\CFIDE\GraphData.cfm
It's correct?
Allan: If I put this code in my cf page
showxgridlines="no" showygridlines="no" showborder="yes" fontbold="no"
fontitalic="no" show3d="yes" rotated="no" sortx
Oh wow... I didnt know about that... I'm using MSSQL 2000...
I'll try it out when I get back from my meeting. :)
Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org
[EMAIL PROTECTED]
>>> [EMAIL
Candace,
If I were you, I would store your dates and times in the db as a datetime
field. Then it will become much easier to do the where statement.
If you just want to find out if there is an overlap then you could use.
select count(identityField) as overlap
from yourTable
where shiftTy
Original Message:
> From: "Mickael" <[EMAIL PROTECTED]>
> I am presently hosting many site with CrystalTech in a shared hosting environment, and they are having a lot of troubles getting SES with fusebox apps to work on 6.1. Is there anyone that has this working with their ISP or work for an ISP
I'm not really sure Jim...
Id have to see the code in its entirety. What I was hinting towards was the
fact that you can just use some temp variables that get set and reset on
each iteration of the loop...
Also... in your cfsets, you only need #s when you have "".
Email me off list, ill be
Candace Cottrell said:
>
> 1 - Do you mean natively or the way I have the db set up?
Natively, OVERLAPS is a SQL predicate:
('2003-12-01', '2003-12-31') OVERLAPS ('2003-12-16', '2004-01-15')
Jochem
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Ok
This is what I did
Getroommate1.Nam_Lname eq NameInfo.Nam_HOTROOMMATELNAME1 and
GetRoommate1.Nam_EmployeeCode eq NameInfo.Nam_HOTROOMMATETCODE1>
Will that work or should I change it to the len thing.
--
Jim Louis
Best Meetings, Inc.
Ph
Hmmm, I made that modification a long time ago. :-)
==
Stop spam on your domain, use our gateway!
http://www.clickdoug.com/mailfilter.cfm
For hosting solutions http://www.clickdoug.com
Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and PHP
Hey Jochem :)
1 - Do you mean natively or the way I have the db set up? If it's the latter, I don't have any constraints for overlaps in the db design. Each "shift" or date range is its own record. The id is an identity field.
Candace K. Cottrell, Web Developer
The Children's Medical Center
One
Anyone out there have CF code that updates a Verity collection. I would like to run it manually occasionally and have it update all my collections.
When I go through the Admin it takes too long and it seems that it I have to delete the collection and then re-instate it in order for it to display
C:\Inetpub\wwwroot\CFIDE\GraphData.cfm
Then restart cfmx service then try.
Allan
- Original Message -
From: Hassan Arteaga Rodriguez
To: CF-Talk
Sent: Tuesday, December 02, 2003 4:51 PM
Subject: RE: [cftalk] About CFChart..
I created it..the same problem!!
__
MSc. Has
Ryan,
Worked like a charm. Thanks and thanks to the others for the input as well.
Robert O.
-Original Message-
From: Hagan, Ryan Mr (Contractor ACI) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 9:51 AM
To: CF-Talk
Subject: RE: Create date problem
Try this:
Mid(datet
Hi Doug,
Here is what I just posted from a another list member
There is a known issue with CFMX6.1 on J2EE configuration which means you need to manually edit the web.xml.
Issue number is 52942:
http://www.macromedia.com/support/coldfusion/releasenotes/mx/mx61_known_problems.html#generalserver
I
Candace Cottrell said:
>
> Start_Month 12
> Start_Day 1
> Start_Year 2003
> Start_Time 8
>
> End_Month 12
> End_Day 15
> End_Year 2003
> End_Time 8
> I know I need to pull a query that brings back the records that
> would be overlapped. And if that recordset is empty, proceed with
> the insert. Ot
I created it..the same problem!!
__
MSc. Hassan Arteaga Rodríguez
Microsoft Certified System Engineer.
DIGI- Grupo de Desarrollo
COPEXTEL, S.A.
-Original Message-
From: Allan Cliff [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 08:47 AM
To: CF-Talk
Subject: Re: [cftalk] About
Where is GraphData.cfm file? I don't have it. GraphData .cfm is a CF
built in file?
I used CF 5.0 and i never had problems with that.
thanks
__
MSc. Hassan Arteaga Rodríguez
Microsoft Certified System Engineer.
DIGI- Grupo de Desarrollo
COPEXTEL, S.A.
-Original Message-
From: Allan
Robert,
On 12/2/2003 at 09:32, you wrote:
RO> I'm trying to convert this date/time info from the filed
RO> #datetime#: 20031201 03:38 PM into something CF can display
RO> correctly. I'm using CreateDate for "20031201". How do I also get
RO> the time "03:38 PM" separated? In other words I would li
Thanks to the great help from our host, Michael, I've got a working function
to parse a long string into an array of sub strings of an arbitrary length.
I'm posting my solution here both to wrap up the thread incase anybody else
ever needs to do something like this, as well as for further review on
Try this:
Mid(datetime, 7, 2) )>
#DateFormat( myDate, "mm/dd/" )# #TimeFormat( myTime, "hh:mm:ss tt"
)#
Take a look at the docs for ParseDateTime(). It's a pretty useful function.
http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/functions-pt250.h
tm#1110355
htm#1110355>
Hello list ;)
I have a db table in which I store Start and End Dates called
ONCALL_SHIFTS. These are ranges.
For example
Start_Month 12
Start_Day 1
Start_Year 2003
Start_Time 8
End_Month 12
End_Day 15
End_Year 2003
End_Time 8
There are also two shift types: Backup and Primary
So
Hello Michael;
OK I understand. As for me, I don't have problems with setting "tweaks" as you
call them, provided they do not compromise security or runtimes for other shared
clients. In fact, I have even given a very trusted client direct access to CF
Administrator to make limited changes (mos
> Performance issues?? In a context that vague any solution on earth
> could be deemed to have "performance" issues. But for a free text
> search over a 10,000 record collection for the average CF app you'd be
> hard pushed to make Verity break sweat.
>
Your the one who made the assumption that s
Sorry not empy put a comment in there
- Original Message -
From: Hassan Arteaga Rodriguez
To: CF-Talk
Sent: Tuesday, December 02, 2003 4:15 PM
Subject: [cftalk] About CFChart..
Hi all:
I'm trying to make a simple chart just to test cfchart tag. But i had
many problems
You need to make a GraphData.cfm file in the cfide directory.
Just make it an empty file with that EXACT name
Allan
- Original Message -
From: Hassan Arteaga Rodriguez
To: CF-Talk
Sent: Tuesday, December 02, 2003 4:15 PM
Subject: [cftalk] About CFChart..
Hi all:
I'm tryi
TimeFormat(YourDate, "hh:mm:ss")
in hh:mm:ss u can use more masks.
regards
__
MSc. Hassan Arteaga Rodríguez
Microsoft Certified System Engineer.
DIGI- Grupo de Desarrollo
COPEXTEL, S.A.
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003
This was sent to me by a person on the list that cannot post at this time
Hi Mike
There is a known issue with CFMX6.1 on J2EE configuration which means you need to manually edit the web.xml.
Issue number is 52942:
http://www.macromedia.com/support/coldfusion/releasenotes/mx/mx61_known_problems.ht
I'm trying to convert this date/time info from the filed #datetime#: 20031201 03:38 PM into something CF can display correctly.
I'm using CreateDate for "20031201". How do I also get the time "03:38 PM" separated?
In other words I would like to have the #DateFormat((Datetime), "mmm-dd-")# displ
Since the condition in your queries is not always the same (ie coming from
the index of the loop) it might be safest to create some variables that you
can set and clear on each iteration of the loop, then before you use them in
your output, check the length...
cfparam a bunch of variables to use
>
> It would appear that potentially the issue I'm having is with enumerated
> types.
>
OK It turns out I may have inadvertently lied
~hides face in shame~
It turns out that a complex data type with two dates in it didn't like
being replaced with null and required appropriately formatt
Code
From = "46"
To = "1811"
step = "1">
#recordID#
select *
From tblNam
where Nam_ID=#recordid#
SELECT *
FROM tblNam
WHERE Nam_BadgeName = '#NameInfo.Nam_HOTROOMMATEFNAME1#' and
Nam_Lname = '#NameInfo.Nam_HOTROOMMATELNAME1
Hi all:
I'm trying to make a simple chart just to test cfchart tag. But i had
many problems with that.
Now when i take out the name in cfchart apear in the browser an symbol
as a missing image.
When i look at the HTML code i have this:
.
.
.
Normal html hearder
.
.
some map with the name Ima
Doug,
It is quite simple, an ISP in a shared environment has access to the admin and IIS settings, to get SES to work their is a minor tweak that needs to be done if there are troubles getting this to run. The app runs fine on my machine with is an out of the box install, and no special configura
Explain how your ISP can be having trouble running apps? All they are required
to do is to provide the environment, with the responsibility of the app being on
the programmer. The server set up should be in accordance with existing best
practices.
I would think, in general terms, that if your pr
Jim,
What does your loop look like? Also, what do the where clauses in your 8
queries look like?
Could you post some code?
Mike
-Original Message-
From: Jim Louis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 8:45 AM
To: CF-Talk
Subject: reseting querys values in a l
Hello All,
I am presently hosting many site with CrystalTech in a shared hosting environment, and they are having a lot of troubles getting SES with fusebox apps to work on 6.1. Is there anyone that has this working with their ISP or work for an ISP that can do it. I am looking to move my custom
Hello,
I am running a loop and in it I have eight querys the are conditional
and I was wondering if there is a way to reset them to null after each
loop. What is happening is that I pick the first record it runs fine
then I pick the second record and if one of the querys is not processed
bec
If find that whatever your ordering on or grouping by or filtering on
always need to be present in the SELECT clause as well when using QoQ
(which aint the case when dealing with a database version of SQL
-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: 02 Decemb
Try this...
SELECT
UPPER(IsDirectory) AS dirName,
Name
FROM
RootFiles
ORDER BY
dirName DESC,
Name
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 7:38 AM
To: CF-Talk
Subject: re: Query of a query - sort order not co
Hi,
I'm doing a query on a query but it won't sort properly.
With the "upper" it gives an error saying lower(IsDirectory) is not a column that can be sorted on.
Why?
If I remove the "upper" to just
ORDER BY IsDirectory DESC, Name
the code will run but the sorting order is not correct.
SELE
Danielle,
As previously stated, DTS should work for you. I actually just did this
yesterday so if you need assistance, feel free to contact me off list and I
would be glad to help. I did not run into any issues and we are no longer
taxing our CF server with fetching the records from the SQL box
Dave, thanks for your answer to my last web services query.
It would appear that potentially the issue I'm having is with enumerated
types.
This is the definition in the wsdl :
and this is the parameter in the method I'm trying to
On Monday 01 Dec 2003 23:16 pm, Bill Doerrfeld wrote:
> Top 20 Contributors by Number of Posts
Eek - where have I gone :-)
Guess it shows I'm doing a lot of Delphi and PL/SQL these days...
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinge
Your best bet (I think) would be to use the SQL server Data
Transformation Service. This will allow you to export tables/views etc
to access quite easily. Just go into SQL Ent Manager and export the
required tables to Access, and if you need to regularly dump the data
out, you can save the export p
Hi Kelly,
I have used www.opensta.org in the past. It's open source, fast, easy to use and very stable. Make sure you read the getting started guide though.
Adam.
-Original Message-
From: Kelly Tetterton [mailto:[EMAIL PROTECTED]
Sent: 01 December 2003 21:47
To: CF-Talk
Subject: OT: loa
You can't make sure of that, it is 100% up to the browser (and any
proxies inbetween).
You can, though, set meta tags and and html headers (cfheader) to tell
the browser that the document should not be cached.
/Hugo
-
Hugo Ahlenius
101 - 159 of 159 matches
Mail list logo