Well, normally on different systems, but no reason it has to be;
You could have a single box with.
1) JRun
2) One or more CFMX Server instances
3) JMS server (JRun built-in or another)
A batch order entry CF app could send messages to a CF order processing
app via JMS.Both CF apps could be on
Hi
its give some error ,is it can be run in 4.coldfusion 4.5 version ?
sorry for the trouble
Thks Isaac
thanks in advance
Vishnu
Oh that's easy then. :)
cfset root = c:\
cf_filemap
directory=#root#
return=filemap
table
thead
tr
tdFilename/td
tdPath/td
/tr
/thead
tbody
cfoutput
Looks like an array would be better suited.
SESSION.strProduct[1].orderNo = xxx
SESSION.strProduct[1].qty = 2
SESSION.strProduct[2].orderNo = yyy
SESSION.strProduct[2].qty = 3
Any other reason why you'd want to use the struct?
Ade
-Original Message-
From: Critter [mailto:[EMAIL
Hello everybody,
I want to re-arrange everything dumped out by cfdump and comma separate all the elements of the cfdump structure.
cfdump var=#url#
I want to take the results returned by the above cfdump structure and comma separate each element. I want to insert all the comma separated
I've figured out how to do this.
cfset elementsList =
cfloop collection=#url# item=urlVar
cfset elementsList = ListAppend(elementsList, #urlVar#:#url[urlVar]#, ,)
/cfloop
cfoutput#elementsList#/cfoutput
Cheers
cfcoder
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
Hi
its give some error ,is it can be run in 4.coldfusion 4.5
version ?
sorry for the trouble
What's the error? I'm not aware there's anything in it that's not
CF4.5 compatible.
s. isaac dealey954.927.5117
new epoch : isn't it time for a change?
add features without fixtures with
the onTap
I was looking for a recommendation on a book that would give one a basis
or better understanding of SQL server admin/performance tuning.
I'm looking for a book that would be useful to someone with a working
knowledge of SQL server from the queries/stored procedures/DTS
package/table/db design
Hello everybody,
I want to re-arrange everything dumped out by cfdump and
comma separate all the elements of the cfdump structure.
cfdump var=#url#
I want to take the results returned by the above cfdump
structure and comma separate each element. I want to
insert all the comma separated
Where is that article?
If memory serves me... my publisher estimated the market of CF developers
at about a half a million.Whereas, Java and .NET are significantly higher.
At 05:01 AM 8/16/2004, you wrote:
Subject: # of CF users
From: Doug Hughes [EMAIL PROTECTED]
Date: Sun, 15 Aug 2004
I agree with S (what should we call you, anyhow?), but have to add my
usual bit about not trusting the query string to begin with.If
you're printing parts of it to the output, wrap it in
HTMLEditFormat().If you're writing into the DB, be sure to use
cfQueryParam and any other type/value validation
If the names are all identical except for the number, why
then is the
named notation of the structure important? It seems to
me the array
would be much easier to deal with.
session.strProduct.item1.orderno = xxx;
session.strProduct.item1.qty = 2;
session.strProduct.item2.orderno = zzz;
Shouldn't that be a left join, since you always want to include the
levels information?
Adam H
On Fri, 13 Aug 2004 16:50:25 -0500, Paul Giesenhagen
[EMAIL PROTECTED] wrote:
I tried to ask this on Experts Exchange without any luck ... maybe one of you guys may be able to help out.
I am trying
I agree with S (what should we call you, anyhow?),
I have many names... my subordinates call me Sir, my superiors call me
S.
:)
Names I've been called over the years (minus the less pleasant ones
like bastard):
Isaac
Ike
Sir Isaac
SID
Merlin (don't ask)
My sister used to call me tiger ...
Thanks for enlightening us Icke
On Mon, 16 Aug 2004 08:50:57 -0400, S. Isaac Dealey [EMAIL PROTECTED] wrote:
I agree with S (what should we call you, anyhow?),
I have many names... my subordinates call me Sir, my superiors call me
S.
:)
Names I've been called over the years (minus the
Critter,
You should probably look into using an array of structs, like so:
cfset session.strProduct = structNew() /
cfset session.strProduct.items = arrayNew(1) /
cfset session.strProduct.items[1] = structNew() /
cfset session.strProduct.items[1].orderno = xxx /
cfset
SQL Books Online...ships with SQL Server...all you need ;-)
_
From: Scott Mulholland [mailto:[EMAIL PROTECTED]
Sent: 16 August 2004 13:32
To: CF-Talk
Subject: OT: SQL Server admin/tuning
I was looking for a recommendation on a book that would give one a basis
or better understanding of SQL
Ha! Actually it's funny you spelled it that way... :) The receptionist
in the office where I work now saw ike printed and apparently hadn't
seen it before and pronounced it that way and has since (after
discovering it was a mispronunciation) been calling me ick (like the
fish disease).
Thanks
Well, the original code would fail against a value between 0 and 0.01 (like 0.001) so I'd modify it like this:
var reg = /([^0-9\.])/g;
var str = $0.01;
var myValue = parseFloat(str.replace(reg,))
alert(myValue0.01);
Also, keep in mind that this will not catch invalid decimal amounts (like
RTFM?
soundsa bit odd to me mate... :)
MD
On Mon, 16 Aug 2004 14:16:23 +0100, Robertson-Ravo, Neil (RX)
[EMAIL PROTECTED] wrote:
SQL Books Online...ships with SQL Server...all you need ;-)
_
From: Scott Mulholland [mailto:[EMAIL PROTECTED]
Sent: 16 August 2004 13:32
To: CF-Talk
A free eBook I found quite useful can be found at
http://www.realtimepublishers.com/
It's called The Definitive Guide to SQL Server Performance and
Optimisation.
It covers a lot of tuning aspects, including monitoring the server itself.
Very useful stuff.
-Original Message-
From:
Is there a CF tree menu I could download or see a link somewhere? Doesn't have to be a tree menu specifically; I need to expand a links on a page as opposed to using bookmarks.
Thanks.
Robert O.
HWW
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
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
I've done that, Peter, but it doesn't seem to help. Thanks for the try though!
I emailed our ISP and this is what they said...
I'm not sure how your web application is sending a response but it
needs to authenticate the same as your clients or you will get the relaying denied error message. The
Is there a CF tree menu I could download or see a link somewhere?
Months ago I assembled a CSS/_javascript_based tree menu. I am still not
100% happy about it, but you can grab a copy if you want:
http://www.cleaner-drive.ch/_menu_test/tree/sample.cfm
Massimo
Is there a CF tree menu I could download or see a link
somewhere? Doesn't have to be a tree menu specifically; I
need to expand a links on a page as opposed to using
bookmarks.
Thanks.
http://www.fusiontap.com/docs/?doc=advanced/htlib
There's an example of the tree widget toward the
I still have my 1st version online, haven't got a blog ready so it is
not published for the crowd on the web yet.. full xhtml compliant, css
layouted, xml based (on-demand options), completely OO and supports a
lot of methods :-)
http://www.mschopman.demon.nl/treeview/treeview.html
Micha
On Monday 16 Aug 2004 15:23 pm, Micha Schopman wrote:
http://www.mschopman.demon.nl/treeview/treeview.html
Nice...
Could you quickly add a link to add (say) 80 child nodes to a node in one go -
this is where things like blueshoes fall down, ime.
--
Tom Chiverton
Advanced ColdFusion
Yes
Micha Schopman
Software Engineer
Modern Media, Databankweg 12 M, 3821 ALAmersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
I don't have the 2nd version online, which features more methods, speed,
etc. but this 1st version should be enough for most tasks. The treeview
is crossbrowser, and xml functionality depends on the support of the
browser.
The following methods are available:
a href="" >
path from parentNode/a
I've got a tiny form to let customers enter banking information for
direct deposits.I know that many companies can match the ABA number
against a list of banks but is that list publicly available?Thanks.
--
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company -
I tried to access CFAdministrator today and got the message Function isAuthenticated is not supported in Coldfusion MX. The message is very odd in that even after upgrading to MX I was able to do configuring with Administrator. The only thing I've done since is to upgrade our Flash to Flash MX
You can buy a book and also a computer file.Go to the American Banking
Association site for more information.
Andy
-Original Message-
From: Damien McKenna [mailto:[EMAIL PROTECTED]
Sent: Monday, August 16, 2004 10:12 AM
To: CF-Talk
Subject: SOT: ABA routing numbers?
I've got a tiny form
I tried to access CFAdministrator today and got the message
Function isAuthenticated is not supported in Coldfusion MX.
The message is very odd in that even after upgrading to MX I
was able to do configuring with Administrator. The only thing
I've done since is to upgrade our Flash to
This is what I found by doing a simple Google search:
http://www.webservicex.net/WS/WSDetails.aspx?CATID=2WSID=55 (web service)
http://www.abanumbers.com/ (Commercial)
HTH.
Rey,,,
- Original Message -
From: Damien McKenna [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday,
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
I love that your office is in a place called Wookey Hole. :)
s. isaac dealey954.927.5117
new epoch : isn't it time for
Thanks, you're right.
dave
I tried to access CFAdministrator today and got the message
Function isAuthenticated is not supported in Coldfusion MX.
The message is very odd in that even after upgrading to MX I
was able to do configuring with Administrator. The only thing
I've done since
Wookey Hole iscave which is amazing, ifI remember right :)
Used to go there as a kid...
On Mon, 16 Aug 2004 11:38:05 -0400, S. Isaac Dealey [EMAIL PROTECTED] wrote:
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
I don't get the relaying message, but instead I get Unable to connect to mail server. But when I enter that mail server name into CF Administrator and check the Verify Mail Server Connection button, it says that it connects to the mail server fine.
I wonder why it can connect from CF Admin but
Does the mail server require SMTP AUTH?
If it requires a user ID and password, then your CFMail must supply it for each
email it tries to send.
==
Our Anti-spam solution works!!
http://www.clickdoug.com/mailfilter.cfm
For hosting solutions
This is a little off topic but I'm considering building our company an
intranet. Right now the biggest problem I see it will eliminate is
people emailing image files to each other. Yes, I know, they could save
them on the network but we are dealing with very novice computer users
for the most and
Perhaps knowing what your company does could help us narrow down our suggestions ;-)
Some generic stuff:
-centralized document management
-employee record maintenance
-HR reporting tools
-project management applications
-expense form submission tool
-expense request forms
-yada yada yada
Cheers
Does the mail server require SMTP AUTH?
If it requires a user ID and password, then your CFMail must supply it for each email it tries to send.
Well it shouldn't, according to the reply I got from my ISP. The other option is to have your web application send out through .xxx.xxx which
Sorry about that . LOL
The company is a gifts collectibles retail store- and there is
already a web site extranet built to maintain that end of things
although I'm sure there are things that could be added or improved to
increase efficiency.
Thank you,
Donna French
-Original
whiteboard
-Original Message-
From: Donna French [mailto:[EMAIL PROTECTED]
Sent: Monday, August 16, 2004 12:33
To: CF-Talk
Subject: OT: Intranet
This is a little off topic but I'm considering building our company an
intranet. Right now the biggest problem I see it will eliminate is
people
We had the same problem with people emailing files to each other then
either (1) no one reading the emails or (2) getting files lost or
deleted, never to found again.
We created a file sharing intranet for our internal issues and then a
separate extranet site for each of our clients.
For the
On Mon, 16 Aug 2004 11:32:47 -0500, Donna French
[EMAIL PROTECTED] wrote:
My question for all of you is what other functionality do you have built
into your intranet that I might implement here to make our company more
efficient?
Think of an Intranet as the central means of communication for
Ok, I've just done some more research, and found that with the version of ColdFusion I'm using (5), I am not able to put in a username and password to authenticate the mail server.
Therefore, I'm back to trying to make the alternate mail server work - the one my ISP said doesn't need
Greetings List members,
I have been searching and reading and find myself with this question still
unanswered. I am running a local network on a wireless DSL router. I want to
make my pc act as a server for ALL the pc's on my network. Can anyone point
me to the information I need to learn HOW to
Hi All,
Has anyone upgraded their CF servers to Win 2k3 SP2 yet? I've been tempted
to install it but I thought I'd ask to see if anyone experienced any issues?
Thanks
Gavin
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
On Mon, 16 Aug 2004 13:02:43 -0400, Kevin [EMAIL PROTECTED] wrote:
I have been searching and reading and find myself with this question still
unanswered. I am running a local network on a wireless DSL router. I want to
make my pc act as a server for ALL the pc's on my network. Can anyone
I don't believe that Windows 2003 has had a service pack at all yet, has it?
Windows XP sp2 was just released, but that can't be applied to Windows 2003
server.
Jim Davis
From: Gavin Brook [mailto:[EMAIL PROTECTED]
Sent: Monday, August 16, 2004 1:10 PM
To: CF-Talk
Subject: SOT: Win2k3 SP2 -
Win 2k3 hasn't had SP1 released yet, let alone SP2... The latest SP2 release
is for Windows XP only
Paul
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Thanks.
Just had a quick look for a release date and late 2004 is all i could
find.
-Original Message-
From: Gavin Brook [mailto:[EMAIL PROTECTED]
Sent: 16 August 2004 18:10
To: CF-Talk
Subject: SOT: Win2k3 SP2 - Any Issues?
Hi All,
Has anyone upgraded their CF servers to Win 2k3
From eWeek, 8/15/2004:
Other third-party programs that may require users to open ports manually in
order to work with SP2 include:
- Macromedia's ColdFusion MX Server Edition 6;
http://www.eweek.com/article2/0,1759,1636075,00.asp?kc=ewnws081604dtx1k5
99
Has anyone run into problems with
Hey
I have a query which returns a bit of data.
I'm trying to output the data via a table on the page
I'd like the output to look like
TerryMonroe, LA
TarahJacksonville, FL
BusinessMikeRaleigh, NC
MariaCharlotte, NC
TimCharleston, SC
Natalie Salina, KS
IndirectKayLongview, TX
the query returns
Ron
Please email me those screen shots.
Sounds like an interesting App.
TIA
Dick
On Aug 16, 2004, at 9:54 AM, Ron Eis wrote:
We had the same problem with people emailing files to each other then
either (1) no one reading the emails or (2) getting files lost or
deleted, never to found again.
Internal chat
On Aug 16, 2004, at 9:54 AM, Chris Johnston wrote:
On Mon, 16 Aug 2004 11:32:47 -0500, Donna French
[EMAIL PROTECTED] wrote:
My question for all of you is what other functionality do you have
built
into your intranet that I might implement here to make our company
more
http://mysecretbase.com/treemonger.cfm
Super simple to set up and customize.
Cheers,
--
--Matt Robertson--
MSB Designs, Inc.
mysecretbase.com
On Mon, 16 Aug 2004 09:45:54 -0400, Robert Orlini [EMAIL PROTECTED] wrote:
Is there a CF tree menu I could download or see a link somewhere? Doesn't
Other third-party programs that may require users to open
ports manually in order to work with SP2 include:
- Macromedia's ColdFusion MX Server Edition 6;
http://www.eweek.com/article2/0,1759,1636075,00.asp?kc=ewnws08
1604dtx1k599
Has anyone run into problems with this?
No, you
have u tried grouping yet?
-- Original Message --
From: Greg Morphis [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:Mon, 16 Aug 2004 12:55:02 -0500
Hey
I have a query which returns a bit of data.
I'm trying to output the data via a table on the page
No.I am not using anything, as far as I can tell, that would cause
memory to be held at all.Although some of the logic behind my pages is
fairly extensive, there is nothing that is really that complex.
CFquery, CFStoredProc, Client variables (Which I switch from session
thinking that was the
I've got this right here
table border=1
cfoutput query=qRpt group=buschannel
tr
td rowspan=#qRpt.cnt##qRpt.buschannel#/tdtd#qRpt.name#/tdtd#qRpt.loc#/td
/tr
cfoutput
tr
td#qRpt.name#/tdtd#qRpt.loc#/td
/tr
/cfoutput
/cfoutput
/table
and it kinda works.. it's duplicating the first row
The actual list is here:
http://support.microsoft.com/default.aspx?kbid=842242
Program: ColdFusion MX Server Edition 6
Vendor: Macromedia
Ports: TCP (by default, 8500)
Default exception: See the documentation
Notes: Needed to allow remote access as Web server
-jc
Dave Watts wrote:
Other
On Aug 12, 2004, at 2:05 PM, David K wrote:
Q: How do I browse datasources?
The non-Macromedia ColdFusion editors really need to add something
which Macromedia are IMHO getting complacent with.RDS, as a
technology, needs to disappear for more secure and open standards and
be replaced with
I am retrieving events for an events calendar from Now() forward.I want to output them per month, so I put in a loop that compares their month.If they're of the same month, then it outputs the info and then I want to update the current row.This doesn't seem to be working for me, among other
try
table border=1
cfoutput query=qRpt group=buschannel
tr
td#qRpt.buschannel#/td
td#qRpt.name#/td
td#qRpt.loc#/td
/tr
/cfoutput
/table
if u wanna send me the db i'll try it
-- Original Message --
From: Greg Morphis [EMAIL PROTECTED]
Reply-To:
While we're at it...
http://clearsoftware.net/client/jComponents.cfm
Has a tree control, also has an accordian (which may be more of what
you're looking for), a tab, and an all-purpose show/hide container.
Version 1.0 due out very soon (next few weeks?) with full client-side
_javascript_
anyone have any ideas? I'm stumped
On Mon, 16 Aug 2004 13:08:33 -0500, Greg Morphis [EMAIL PROTECTED] wrote:
I've got this right here
table border=1
cfoutput query=qRpt group=buschannel
tr
td rowspan=#qRpt.cnt##qRpt.buschannel#/tdtd#qRpt.name#/tdtd#qRpt.loc#/td
/tr
cfoutput
tr
http://www.eweek.com/article2/0,1759,1636075,00.asp
wow. microcrap closing off coldfusion server who would have imagined that
whats next, M$ intergration of cfm into frontpage?
damn, we havent had a M$ is buying MM lately... worries me, lol
-- Original Message
Hi Chris!
I am not sure if I have a firewall running, but assume not since I changed
that IP address in the IIS admin and was able to access my web sites from my
other PC's with NO trouble at all. :-) THANKS
You wouldn't happen to know what steps I need to take from here to make them
I installed SP2 on 8/10/2004 and have had no problems with CFMX. My server is at localhost:8500. Any other port may be problematic with SP2.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
probably need too be more specific.
im assuming that u could just usesomething like
WHERE date = date GTE #now()#
-- Original Message --
From: daniel kessler [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:Mon, 16 Aug 2004 14:24:20 -0400
I am retrieving
that yields
Business Terry Monroe, LA
Indirect Natalie Tampa, FL
On Mon, 16 Aug 2004 13:29:05 -0500, Greg Morphis [EMAIL PROTECTED] wrote:
anyone have any ideas? I'm stumped
On Mon, 16 Aug 2004 13:08:33 -0500, Greg Morphis [EMAIL PROTECTED] wrote:
I've got this right here
Dan,
The function to update a cell is QuerySetCell()
If you need to output them by month, however, why not order them by
their date and then use cfoutput's group attribute?
-joe
- Original Message -
From: daniel kessler [EMAIL PROTECTED]
Date: Mon, 16 Aug 2004 14:24:20 -0400
Subject:
are you wanting to get the next month?
try dateadd(m,1,#now()#)
or if you're using oracle
SELECT ADD_MONTHS(SYSDATE,1) FROM dual
On Mon, 16 Aug 2004 14:37:50 -0400, dave [EMAIL PROTECTED] wrote:
probably need too be more specific.
im assuming that u could just usesomething like
WHERE date =
Big T, did you get this issue resolved completely?
-Adam
On Thu, 5 Aug 2004 18:30:09 -0400, Tony Weeg [EMAIL PROTECTED] wrote:
:) thanks!
for all your help.
also, kudos to mike t.who helped as well!
later.
tw
On Thu, 5 Aug 2004 18:18:58 -0400, DURETTE, STEVEN J (AIT)
[EMAIL
Hey Greg,
Try this:
table border=1
cfoutput query=qRpt group=buschannel
tr
td rowspan=#qRpt.cnt##qRpt.buschannel#/td colspan=3
/tr
cfoutput
tr
tdnbsp;/td
td#qRpt.name#/tdtd#qRpt.loc#/td
/tr
/cfoutput
/cfoutput
/table
Also, Googling for coldfusion cfoutput group should yield some good examples.
Hey that works! thanks Joe!
On Mon, 16 Aug 2004 14:27:24 -0400, Joe Rinehart [EMAIL PROTECTED] wrote:
Hey Greg,
Try this:
table border=1
cfoutput query=qRpt group=buschannel
tr
td rowspan=#qRpt.cnt##qRpt.buschannel#/td colspan=3
/tr
cfoutput
tr
tdnbsp;/td
Hello again,
Last week, I posted regarding finding the actual length of a text string
(original question below), and, thanks to some helpful people, ended up
with the idea of instansiating the Java FontObject, which we turned into
a function, like this:
cffunction name=StringWidth output=false
well, Idon't know what a cell is, however, I've realized that I didn't explain myself very well.
I'm looking to do this type of output:
August
16th - Lunch with Mrs. Fridge
17th - Board Meeting
30th - Golf tournament
September
3rd - classes begin
etc...
The function to update a cell is
Hello
I want to delete all records from a table except one (a random one).
Is there a way to do it? I am using SQL Server
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
cfoutput query=qCal group=month
p#month#/p
cfoutput
#date# - #event#
/cfoutput
/cfoutput
make sure you're ordering by in your SQL..
order by month
On Mon, 16 Aug 2004 15:10:29 -0400, daniel kessler [EMAIL PROTECTED] wrote:
well, Idon't know what a cell is, however, I've realized that I didn't
I think you'd probably have to have a temp table and save a record to it
and then delete out the entire original table and then insert the
single row back into the table from temp.
On Mon, 16 Aug 2004 15:19:39 -0400, Qasim Rasheed
[EMAIL PROTECTED] wrote:
Hello
I want to delete all records
On Mon, 16 Aug 2004 14:35:18 -0400, Kevin [EMAIL PROTECTED] wrote:
Hi Chris!
I am not sure if I have a firewall running, but assume not since I changed
that IP address in the IIS admin and was able to access my web sites from my
other PC's with NO trouble at all. :-) THANKS
Cool, glad
I'm not familiar with what exactly your app is doing, nor the AWT
library, but app caching, yes. Might there be a way to store the string
width with the string? For instance, if it's called from a database, add
a field for width, and recalculate on insert and update, not on select.
Other than
cfoutput query=qCal group=month
p#month#/p
cfoutput
#date# - #event#
/cfoutput
/cfoutput
ah, I thought that we couldn't group cfoutputs.This is pretty neat.
Another question though.I don't have a month field, but a date field.I order by date in the query.Can I still group by month then?
And just
Greg,
Do have an example of how to create a temp table in SQL Server. I can
use stored procedure if necessary
Qasim
- Original Message -
From: Greg Morphis [EMAIL PROTECTED]
Date: Mon, 16 Aug 2004 14:32:59 -0500
Subject: Re: SQL Question
To: CF-Talk [EMAIL PROTECTED]
I think you'd
cfset newRow = #query.currentrow# +1
-- Original Message --
From: daniel kessler [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:Mon, 16 Aug 2004 15:41:08 -0400
cfoutput query=qCal group=month
p#month#/p
cfoutput
#date# - #event#
/cfoutput
/cfoutput
Another option would be, if you had an auto-generated numeric primary key, determine your range, call a random number generator, verify that the number is a valid primary key, then do a DELETE * WHERE pk != randomKey.
Just thinking out loud.
- Original Message -
From: Greg Morphis
Hi Dirk,
I think most of the slowness is in creating the objects not calculating
the width. So if you can somehow cache or reuse the objects, it is much
faster. You will notice that the following code is much faster than
calling the UDF. So what I would suggest is that if your going to be
Keep your FontMetrics object around and ready for use.Perhaps stick
them in the application scope somewhere.Then you don't have to
create font objects, to pass to system toolkits, to get metrics objects,
on every string measurement. The only thing you should have to do is ask
an existing
Following Chris's great response, I would add, search capability would be nice as well, sometimes people may just like me (half blind :),
search feature offers a way to cure that deficiency to some degree.
Also, if your company is thinking about automating FORM process (I'm sure the company has
remember that within cf tags you almost always dont need #'s
cfset newRow = myQ.currentrow + 1 works also
as far as date/month thing..
check to see if you have a to_char function in your database..
Oracle does and you can easily do (in your sql)
select to_char(date,'month') as month from tbl
just curious, cant you just create one called temp and use it constantly?
On Mon, 16 Aug 2004 14:46:48 -0500, G [EMAIL PROTECTED] wrote:
Another option would be, if you had an auto-generated numeric primary key, determine your range, call a random number generator, verify that the number is a
Brian,
Thanks for the nice suggestion but my problem is that there are
several tables and some of them doesn't have any primary key
associated with them. A brute force approach that I tried and it
didn't even worked was to get all database table name from SQL Server
metadata and then loop through
no.
we just got the queries tuned so that it doesnt cause the problem As Much
the problem with CFMX spiraling to its death upon a request to a VERY
tied up db, still is there.
:( any ideas?
tw
On Mon, 16 Aug 2004 14:51:27 -0400, Adrocknaphobia
[EMAIL PROTECTED] wrote:
Big T, did you get this
do you need the duplicate cfouput's?just wondering, for bloats cause.
tw
On Mon, 16 Aug 2004 14:02:15 -0500, Greg Morphis [EMAIL PROTECTED] wrote:
Hey that works! thanks Joe!
On Mon, 16 Aug 2004 14:27:24 -0400, Joe Rinehart [EMAIL PROTECTED] wrote:
Hey Greg,
Try this:
table
Greg,
I apologize if I am missing something or not understanding correctly
but how would I create a temp table similar to other tables if I am
not aware of datatypes and column names. Is there an efficient way
that I can copy one table schema to a temp table?
Thanks
- Original Message
This might be a ridiculous question to ask, but I thought I would anyway. On my box (hosting 3 sites), the thread count for jrun.exe hovers around 53. I've seen it go as high as 56 and as low as 48. When the box crashes, which happens not that often, the thread count goes to 80 and beyond.
So
Version 1.0 due out very soon (next few weeks?) with full client-side
_javascript_ integration, open/closed state icons for every control, and
an improved tree architecture.
*oooh*
One of these days I'll have the time to get into that accordion
thingie, and the tabs.Both look extremely cool.
1 - 100 of 184 matches
Mail list logo
