problem with calendar popup on DATEFIELD

2011-08-07 Thread derek felsher

Hi folks

Sorry if this is a repeat, seems I hit the send button to fast on the prev 
post. 

I am trying to use the cfinput datefield in CF8. Everything works fine except 
when the calendar opens, the month and year do not show at the top of the 
popup. 
When I move the mouse over the area and click where they should display, then 
they appear???

Many thanks in advance 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346566
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


cfinput-datefield calendar not displaying month and year

2011-08-04 Thread derek felsher

Hi folks

I am trying to use the cfinput datefield in CF8. Everything works fine except 
when the calendar opens, the month and year do not show at the top of the 
popup. When I move the mouse over the area and click where they should display, 
then they appear???

Many thanks in advance

Derek 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346555
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Anyone know anything about this new ColdFusion conference?

2011-01-18 Thread Derek Lussier

Hi Donna,

Yeah http://OpenCFSummit.org is the real thing.  And yeah that video is pretty 
funny.

My boss and I are trying to get her management to ok sending our whole team, 
because there's pressure from other programming departments to move to Drupal 
and PHP, but we're keen to go with the Mura content management system and stick 
with cfml.

Sounds like you're probably like me: a ColdFusion contractor or gov worker in 
the Washington area, which means you are starting to feel the impact of budget 
cuts and President Obama's push to move government towards open source software.

As far as I know, this conference is biggest champion of this trend - and I'm 
going to lobby them heavily to bring the show to Washington next year.

-Derek Lussier




Ever since CFUnited closed up shop, I've been looking around for an affordable 
substitute.  I'm local in the Northern Virginia area, so I saved on lodging 
and 
travel.

I saw something on Sean Corfield's blog about this new conference in Dallas 
and, 
while I'd have to pay travel and lodging, the conference is apparently only 
$30?!?!?!


They have a pretty funny video: http://blog.opencfsummit.org/


Just wondering what folks thought about it.  The schedule seems to have a lot 
of 
substance.  And hard to argue with $30.  But then again, $30?!?!


Is is for real? 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340954
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Measuring bandwidth used per user

2010-02-03 Thread derek felsher

 I need to measure bandwidth used because this is how I
 charge. Uploading is fine to measure, but is it possible
 to measure how many times an attachment was successfully
 accessed (either opened in browser or downloaded)?

I would advise parsing the web server logs for this information for two
reasons:

1) It will be more accurate and give you exact byte counts for the files
that were accessed.

2) It will not tie up ColdFusion threads as using CFCONTENT would to serve
them up.  If you have several people downloading large files at once over
relatively slow connections there is a chance that all of the available CF
threads could be ties up and the site would appear to become unresponsive to
others.


-Justin

Cool,

Justin is this possible from client side, I do not own the  server. (Some 
sample code will save me days of homework.)

Is this also possible for measuring bandwidth from a cfmail execution.(Faced 
with same predicament).

If you could provide the code , I'll give 5points of my revenue. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330376
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Measuring bandwidth used per user

2010-02-02 Thread derek felsher

 I need to measure bandwidth used because this is how I
 charge. Uploading is fine to measure, but is it possible
 to measure how many times an attachment was successfully
 accessed (either opened in browser or downloaded)?

I would advise parsing the web server logs for this information for two
reasons:

1) It will be more accurate and give you exact byte counts for the files
that were accessed.

2) It will not tie up ColdFusion threads as using CFCONTENT would to serve
them up.  If you have several people downloading large files at once over
relatively slow connections there is a chance that all of the available CF
threads could be ties up and the site would appear to become unresponsive to
others.


-Justin

Cool,

Justin is this possible from client side, I do not own the  server. (Some 
sample code will save me days of homework.)

Is this also possible for measuring bandwidth from a cfmail execution.(Faced 
with same predicament).

If you could provide the code , I'll give 5points of my revenue. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330375
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CFExecute hanging

2007-01-31 Thread Derek Bezuidenhout
I have been trying to use cfexecute (MX7) to convert a qt mov to Flash Video 
flv, but it seems to hang as if waiting for something.  Read on...

The converter is mencoder that ships with mplayer.  It works spledidly from the 
command line or a batch file.

When I run it from a cfexecute, mencoder.exe starts up, and stops processing 
before any video is touched.  I can watch this happening in the Task Manager on 
the CF server.  

Here's the weird bit: if I End Process the jrun.exe, it doesn't terminate - CF 
stays operational - but rather things *start working*!  mencoder.exe comes 
alive and performs the conversion just fine.  My CF page dies of course.  

Same story if outputing to varible, outputfile or screen.

My theory is that CF can't handle the output from mencoder.  From the command 
line, there is no other user interaction after pressing enter.  It just works.

Any ideas?  I'm not even entirely sure this is a CF issue anymore.  

For anyone wanting to perform similar tricks converting video, look at this 
guys page:
http://jameser.blogspot.com/2006/06/tip-3-creating-flash-video-with-free.html
But use this flv player:
http://www.jeroenwijering.com/?item=Flash_Video_Player

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268237
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFExecute hanging

2007-01-31 Thread Derek Bezuidenhout
To answer my own question...

The problem is with mencoder using both stdout and stderr for output.  CF only 
listens on one, so mencoder can't send some of its output anywhere, and hangs.

The solution it to redirect the stderr output to stdout.

This is my line from the batch file:
mencoder %1 -o %2 -of lavf -oac mp3lame -lameopts br=32 -af 
lavcresample=22050 -srate 22050 -ovc lavc -lavcopts 
vcodec=flv:vbitrate=340:autoaspect:mbd=2:trell:v4mv -vf scale=%3:%4 -lavfopts 
i_certify_that_my_video_stream_does_not_use_b_frames  convertmov2flvoutput.txt 
21

Notice the 21 at the end?  That's the puppy...  Pipe outout2 (stderr) to 
output1 (stdout).

Hope this helps someone...

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268240
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Form Fields - storing unsaved values with a Page refresh

2006-10-18 Thread Derek
Can anyone help me with this?

I have an onChange function that refreshes my coldfusion page and puts the
new ID in the URL and then the SQL uses this ID to get certain information
from the database. But when it refreshes with the new ID I lose any changed
data in the form... any suggestions?

My code goes kinda like this

SCRIPT
function filter(ID){
 self.location.href=('index.cfm?ID=' + ID + '');
}
/script

cfquery
SELECT 
FROM
WHERE url.Id
/cfquery

form

input type=text

select onChange=filter(ID)
 option
 option
/select

/form

Let me know if you need more details. Thanks so much for your time. I dont
know where coders would be without forums.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257236
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Form Fields - storing unsaved values with a Page refresh

2006-10-18 Thread Derek
The second idea looks great. How can I make it actually submit the form the
right place when they are ready? The user has the ability to change markets
(ids) multiple times which populates submarkets based on this choice before
submitting the actual form.

Any ideas?

Thanks again for your time and help.

-Derek

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 18, 2006 1:08 PM
To: CF-Talk
Subject: RE: Form Fields - storing unsaved values with a Page refresh

A couple of ideas:

1) Use Ajax, I can't help you here, but I'm pretty sure it could be used
for this kind of thing.

2) Use the form.submit() function to submit the form, rather then
self.location.  Then your action logic will have access to all the data
currently in the form.  It could repopulate the submitted data as well as
process the ID datum.




--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
C code. C code run. Run code run. Please!
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 






~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257279
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Form Fields - storing unsaved values with a Page refresh

2006-10-18 Thread Derek
Ok, Thanks for all your help. I have it working now. Thank you. 

Have a great day

-Derek

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 18, 2006 1:08 PM
To: CF-Talk
Subject: RE: Form Fields - storing unsaved values with a Page refresh

A couple of ideas:

1) Use Ajax, I can't help you here, but I'm pretty sure it could be used
for this kind of thing.

2) Use the form.submit() function to submit the form, rather then
self.location.  Then your action logic will have access to all the data
currently in the form.  It could repopulate the submitted data as well as
process the ID datum.




--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
C code. C code run. Run code run. Please!
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 






~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257283
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Form Fields - storing unsaved values.

2006-10-17 Thread Derek Law
I have a similar issue with a bit of twist. I have an onChange function that 
refreshes my coldfusion page and puts the new ID in the URL and then the SQL 
uses this ID to get certain information from the database. But when it 
refreshes with the new ID I lose any changed data in the form... any 
suggestions?

My code goes kinda like this

SCRIPT
function filter(ID){
 self.location.href=('index.cfm?ID=' + ID + '');
}
/script

cfquery
SELECT 
FROM
WHERE url.Id
/cfquery

form

input type=text

select onChange=filter(ID)
 option
 option
/select

/form

Let me know if you need more details. Thanks so much for your time. I dont know 
where coders would be without forums.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257109
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


SQL 'Invalid Object Name' on Insert, after Create Table

2006-10-03 Thread Derek Bezuidenhout
Hey folks,
I'm having trouble with inserting into a table I've just created.

As a summary of what I'm doing:
- if the table exists, delete it
- create the table 
- read from the table to prove it's there
- insert into the table 
*splat* : Invalid object name...

I can post the full code and error if you want.

All the other forum posts around the web say things like:
- check the user permissions 
- the user in the datasource has db_owner, and for good measure 
db_datawriter, db_datareader.
- reference the table in the INSERT with the owner (ie: dbo.tablename)
- I've gone so far as to look up the owner in sysobjects
- if using JDBC driver then set selectMode=cursor 
- done

Thought it might be related to http://support.microsoft.com/kb/837970/ so I'm 
now running this on a different new fresh SQL server, with SP4 installed.  

The same error occurs on CF5 and CFMX7.

Even when I try the Insert without the Create Table it fails.  (ie: run once so 
table is created, then rem out the Create Table bit and run it again.)

All suggestions welcome...

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255156
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: SQL ''Invalid Object Name'' on Insert, after Create Table

2006-10-03 Thread Derek Bezuidenhout
Thanks for the suggestions so far.  I'll try them now.

Here's the code:

cfquery name=createTable datasource=aaa_bwdatadump
IF object_id('aaa_bwdatadump..djbtest') IS NOT NULL
BEGIN
DROP TABLE djbtest
END

CREATE TABLE dbo.djbtest (
id varchar(200)
)
/cfquery 

cfquery name=geta datasource=aaa_bwdatadump
SELECT * from djbtest
/cfquery
cfdump var=#geta#

cfquery name=getuser datasource=aaa_bwdatadump
SELECT name, xtype, uid AS [owner id], USER_NAME(uid) AS owner
FROM sysobjects
WHERE name LIKE '%djbtest%'
/cfquery
cfdump var=#getUser# 

cfquery name=InitVals datasource=aaa_bwdatadump
INSERT INTO #getuser.owner#.djbtest ('id')
VALUES ('sdfasdfafasdfasfd')
/cfquery 

-
And the error:

Error Executing Database Query.  
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 
'dbo.djbtest'.  
  
The error occurred in D:\www\cfmx\scratch\bwconvertdata\test.cfm: line 30
 
28 : 
29 : cfquery name=InitVals datasource=aaa_bwdatadump
30 : INSERT INTO #getuser.owner#.djbtest ('id')
31 :VALUES ('sdfasdfafasdfasfd')
32 : /cfquery 


 
SQLINSERT INTO dbo.djbtest ('id') VALUES ('sdfasdfafasdfasfd')  
DATASOURCE   aaa_bwdatadump 
VENDORERRORCODE   208 
SQLSTATE   42S02 
 
---
If it makes any diff, it's on CFMX 7,0,2,137072 and MS-SQL2000 (8.00.2039 
(SP4)), although I've got the same results on CF5 and MS-SQL SP3.



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255164
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: SQL ''''Invalid Object Name'''' on Insert, after Create Table

2006-10-03 Thread Derek Bezuidenhout
It had to happen.

For some reason I had 'quotes' around the col-name in the Insert.  D'oh!

Sorry to waste space...

 cfquery name=InitVals datasource=aaa_bwdatadump
 INSERT INTO #getuser.owner#.djbtest ('id')
   VALUES ('sdfasdfafasdfasfd')
 /cfquery 
 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255175
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: OT: Mail server

2005-09-21 Thread Derek Vinyard
merak is what i use..

On 9/19/05, Cedric Villat [EMAIL PROTECTED] wrote:
 What do you guys recommend as a good Windows-based mail server? Preferably 
 open-source, but paid solution will work too. I checked on sourceforge, but 
 really didn't have much luck finding a Windows server. I just need a basic 
 mail server, that allows for multiple users and webmail, at a minimum. Any 
 ideas?

 Cedric

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218809
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Internationalization

2002-03-31 Thread Derek Nalecki

Good list;
I have just one more point for Paul to consider. Sales taxes. Paul, 
you say you are a maker of a  commerce site. Consider the ability 
to put two tax codes and percentages. In many provices in 
Canada, for example, there is a federal sales tax (GST) and 
provincial sales tax (PST). That is likely to be true for many 
countries with a federal structure.

dn.


On 31 Mar 02, at 1:53, Mike Kear wrote:

I know you're thinking about technical things, but there are some common
errors you can easily make, and a huge number of American companies make
them 


(1) Not all countries have zip codes, and only a few have 5 character
numeric codes.   So don't REQUIRE a 5 numeral zip code.

(2)  Few countries use two characters to name their states/provinces, and
some don't have any such divisions at all.  So don't make your state field
a drop down list consisting of only the 50 US 2character state
abbreviations.

(3).  American 1-800 numbers don't work outside the USA.  So provide a
regular phone number if you're going to put a 1-800 number.

(4)  Only North America has phone numbers in the format (999) 999-.  The
rest of the world has  a dazzling array of formats, and not everyone has
area codes.  So don't use that stupid feature in CF to format a field as a
phone number field.  You're locking non-Canadian and non-US customers out of
that field.   Not everyone has 7 character phone numbers.  Some have 5, some
have 10, some have numbers in between.

(5)  Don't use seasons to describe time.   It's common for American
companies to talk about something being released next spring for example.
But not all countries have 4 seasons.  In the tropics they only have two
seasons (Hong Kong, South East Asia,  North of Australia, Central America
for example).   And anyway when we see this expression here in Australia,
we often think which 'spring'  is it referring to - is it ours or theirs?
Summer in these parts is December-March. And similarly don't use terms
like 1QR or Quarter 2.   The financial year in Australia begins on 1 July.
IN New Zealand it beings 1. April.   Different times in other countries.  So
does the term beginning of 2Qtr mean April, (i.e. beginning of the second
calendar quarter) or September (beginning of second financial quarter in
Australia) or June (beginning of second financial quarter in New Zealand)
etc etc around the world.  Don't be lazy, use the month names and everyone
will know what you mean.

(6) Despite the prevalence of the US Dollar, not everyone wants to deal in
that currency, and anyway, it can be very expensive to convert local
currency to US. (It costs AUD$15 to bank a US cheque in a Australian bank
account for example )   So provide for some way for your customers to pay
you in local currency.  Or make it easy for them to convert.

(7)  Remember that when you send your data across the Atlantic, or the
Pacific Oceans it might well travel 70,000 km before it arrives at the
user's browser. (35,000 up to a satellite and 35,000 down again)  So don't
put huge files in your site - big graphics etc - just because it runs fast
in your home town, doesn't mean it's going to run fast half a world away.
Will your prospective customers in Europe and Asia wait to download that
fancy flash page that you love but which does nothing at all for the
customer?

(8)  I once tried to download some software from a major international
company (who will remain nameless but recently announced a merger with
Compaq) where the registration form had a compulsory field that required a
social security number for pete's sake.   The product was a printer driver -
not a US specific piece of software, but for general release around the
world.  The moron who designed that page hadn't thought for a moment that
there might just be people in the world who didn't have US social security
numbers.   (Like for example ALL of the non-US residents!!)  I had to make
up a social security number, and tinker around with numbers until I invented
one the form liked.   I also had to invent an address because it had a 5
character compulsory zip code so I just took an address from a company's ad
in a magazine.


And this is without even touching the idea of language choices.  It's common
in Europe and Asia for sites to be built in several languages and you choose
on the home page which language you want to see.  This is costly and
duplicates effort to translate your site into other languages, but how many
other customers will you get if you do the translation?


These are just some random thoughts.  I know you were thinking about CF's
Locale setting and similar matters, but perhaps these more general thoughts
might help you too.



Cheers,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks



-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 30, 2002 1:04 AM
To: CF-Talk
Subject: Internationalization

We are makers of SiteDirector a commerce application and are getting ready
to 

RE: Multiple File Upload

2002-03-31 Thread Derek Nalecki

This is not slick, because the user has to do a browse for every file he 
wants to upload; but it works without java. If you want, you can use 
javascript dynamically change the filelist, instead of reloading the input 
page. Use divs and something like this:

function writetext(lay,txt) {
if (isIE4) {
document.all[lay].innerHTML = txt;
}
if (isNS4) { 
document[lay].document.write(txt);
document[lay].document.close();
}
if (isDOM) { 
over = document.getElementById([lay]);
range = document.createRange();
range.setStartBefore(over);
domfrag = range.createContextualFragment(txt);
while (over.hasChildNodes()) {
over.removeChild(over.lastChild);
}
over.appendChild(domfrag);
}
}

--

cfparam name=files2upload default=1
..
table...
form ... action=index.cfm...
input type=hidden name=action value=[runthisform]
trtdselect number of files/td
  tdselect name=files2upload onchange=[submit]
 option value=11/option
 .
 /select/td
/form
/tr
/table
..
table ...
form ... action=index.cfm...
input type=hidden name=action value=[uploadfiles]
CFLOOP INDEX=filecount FROM=1 TO=#files2upload#
trtd rowcount=#files2upload#
tdinput type=file name=ufilename#filecount#
/tr
/CFLOOP
input type=hidden name=filecount 
value=#files2upload#
/form
/table
..



The upload cfm:

cfloop index=cfilelocal from=1 
to=#form.filecount#
cfif Evaluate(form.ufilename#cfilelocal#) is not 
CFFILE ACTION=Upload
FILEFIELD=ufilename#cfilelocal#
DESTINATION=#varloaddirectory#
NAMECONFLICT=Overwrite
/cfif
/cfloop




On 21 Mar 02, at 13:00, James Taavon wrote:

Jumping in on this thread...

What if you did not know the number of mutiple files and wanted to make it
dynamic via select box, say 1-5? I know Javascript is the anser, but I have
never done anything like that. Do you know of anybody that has?



-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 11:27 AM
To: CF-Talk
Subject: Re: Multiple File Upload


Multiple File fields with different names and a CFFILE for each..

Dave


- Original Message -
From: Owen Leonard [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, March 21, 2002 11:08 AM
Subject: Re: Multiple File Upload


 I need to have a multiple file upload.

I've only ever heard two answers to this:

1. Some kind of custom Active-X somethingorother.
2. Multiple file input fields, followed by looping over cffile.

I'd certainly be interested if anyone has any better solutions.

-- Owen


Athens County Library Services
http://www.athenscounty.lib.oh.us





__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Defroster

2002-03-30 Thread Derek Nalecki

Hi,
yes Defroster was an application that claimed to convert Cfusion to 
ASP. I understand it did not do well on code with any degree of 
compexity; and the company that put it out went out of business 
about a year ago.

derek n.

On 27 Mar 02, at 8:48, G wrote:

My friend was asking me earlier today about an application called
Defroster. Says he thought it was a CF to ASP converter program?

Does anyone have any information on this? I'd never heard of it.

Thanks!

Brian


__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: OT SQL Server (OK 1 More ?)

2001-06-13 Thread Derek Hamilton

That means 4 bytes.  This will limit the number but more like around 30,000.
I don't remember the exact number, anyone...?

Derek
- Original Message -
From: ibtoad [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, June 13, 2001 9:32 AM
Subject: RE: OT SQL Server (OK 1 More ?)


 OK I got it. Now that I have the primary key set with datatype int, the
 length is limited to 4. Is this correct and will this limit the table to
  records?

 Thanks,
 Rich

 -Original Message-
 From: Craig Bowes [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, June 13, 2001 11:30 AM
 To: CF-Talk
 Subject: RE: OT SQL Server


 You must set a field to be identity and not null.  You can set its seed to
 any number (start autonumbering at 1000 for example.)

 -Original Message-
 From: ibtoad [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, June 13, 2001 9:37 AM
 To: CF-Talk
 Subject: OT SQL Server

 I have a simple question.  How do you set the primary key field to
 autonumber in SQL server?  I have always used Access where this is a
choice
 but don't see how to do it with SQL Server 2000.

 Thanks,
 Rich

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Mass mailing (typo corrections)

2001-06-08 Thread Derek Hamilton

I am doing a project that is pretty much the same thing right now.  The
concerns I had about cfmail was that it serializes the mail queue so only
one mail can go out at a time.  That would not work for me because I'm
sending out ten's of thousands of records.  The other issue I have is that
this is a service that we plan on selling to many of our clients so I wanted
something quick and robust.  This is not cfmail.  The last real issue I had
was deciding on what else to use if it wasn't going to be cfmail.  I didn't
want to use the aspmail stuff or the infusion products because they are so
slanted towards either asp or cf.

I chose to write the query and database login info to an xml file.  Then I
have a scheduled task that runs every couple minutes and calls a script.
This script checks a text file that is also written along with the xml file.
The text file holds the path of the xml file.  If the text file has any
entries then the script opens a network connection straight to my pickup
queue for my exchange server and then calls a COM component that I'm still
writing.  The com component parses the xml file to get the database info,
runs the query to get the email addresses then starts building smtp files
that I send to the pickup folder for Exchange.  I can also set the amount of
files to send per xml file.  This is the best that I could come up with.  I
can use this now with whatever language I want or even call it directly from
other applications.

As I said, I'm not quite done yet though!  This is kind of an extreme
example but necessary for what my company wanted to get out of the app.

Derek
- Original Message -
From: Jeff Green [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 08, 2001 3:33 PM
Subject: RE: Mass mailing (typo corrections)



 Sorry all some typos :) here it is again

 Hi all,

 Im working on a project that is going to be sending mass emails, of an opt
 in
 list (so its not Spam, its requested Spam :).  And im having concerns
about
 the reliability of cfmail.  If anyone could post any experiences with
 good/bad, fixes, workarounds, tags more reliable, basically anything that
 has to do with mass emailing.

 Personally I haven't had any troubles with fail, but I haven't really
tested
 it with mass emailing either, so any insight is appreciated.

 TIA,
 Jeff

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: setting values

2001-05-18 Thread Derek Hamilton

Hey Ken,

One good way to do this is instead of using an if...elseif...else for all 6
prices based on a,b,etc stick a little code at the top of your page to
convert a, b, etc to a price.

Like:

cfquery name=getPrice
select price
from prices
/cfquery

cfset a = 0
...etc for a = whatever

cfoutput query=getPrice
!--- stick processing here for setting the above variables to the
correct price. ---
/cfoutput

You might still have to do some ifs but you will only have to do it once
instead of again and again for every record.

I think this is the jist of what you were asking, right?  Let me know if you
need some more code!

Derek

- Original Message -
From: Ken Ketsdever [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, May 18, 2001 6:31 PM
Subject: setting values


 Friday, May 18, 2001 5:14 PM



 I have a table that is dynamically populated from a db to show the item
 number, description, price and image of products.

 Although there are several hundred items there are only about 6 prices.

 Rather than inputting the price of each item into the database, I would
 prefer to put a letter designation then set the letter to equal a price.
so
 that when prices change I only have to reset the price once per price
versus
 changing all the prices in my database.

 I am pulling out #price# from a query.

 if I use prices as a , b, c, d, ...

 can I use some sort of set function to establish prices to be displayed

 so if an item has a price code of a in the database it will display
$22.00

 if it is b then it will display $26.00

 etc...
 Or does this need to be done via a cfif statement and if so how would I do
 it


 Thank you for any help you can provide



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Dynamic form fields

2001-05-15 Thread Derek Hamilton

Cami,

I use the FORM structure that ColdFusion creates automatically when using
forms.  This is a structure that you can test to see if the appropriate
name/value pairs are there.

If you want a better explanation I can email you a copy of a presentation I
gave at my local CFUG about processing dynamic forms.

HTH,

Derek
- Original Message -
From: Cami Lawson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, May 15, 2001 1:55 PM
Subject: Dynamic form fields


 I have created a form and used names that are created dynamically based on
 the SQL.  How can I reference these forms on a processing page?
 CFSET mybox = #acct#_#abbr#

 input type=checkbox name=#mybox#

 TIA,
 cami



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



SQL Server 2000

2001-05-14 Thread Derek Hamilton

Hello!

I am in the process of planning my upgrade to SQL Server 2000 from SQL Server 7.0.  I 
was wondering if anyone has noticed anything odd or difficult in respect to ColdFusion 
(4.5 and 5.0RC)?

Any advice or even things you've noticed would be extremely helpful.

Thanks,

Derek Hamilton


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: SQL 7.0 Single User Mode

2001-05-08 Thread Derek Hamilton

I was having this problem also and someone on a newsgroup said it might have
something to do with having a maintenance plan that is trying to fix small
problems (don't remember the exact terminology used with the maintenance
plan but it's like the second or third window).  I unchecked that option and
never had the problem again.  I also heard that it is a bug that was fixed
in sp3.  Do you have that installed?  I didn't at the time but now do.

Good luck!

Derek
- Original Message -
From: Brook Davies [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, May 08, 2001 10:57 AM
Subject: SQL 7.0 Single User Mode


 Does any one know why a SQL 7.0 database would continually go into single
 user mode?

 Brook Davies
 Maracasmedia Inc.




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CF Studio and UltraDev Merging!

2001-05-03 Thread Derek Hamilton

I hope this means that either they are just bundled (agreed that the
language is a little unclear about this).  But if they are actually merging,
will we still be able to just purchase CF Studio if that is all we want?
I've used Ultradev and frankly have no use for it.

Derek

- Original Message -
From: Stephen Moretti [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, May 03, 2001 10:34 AM
Subject: RE: CF Studio and UltraDev Merging!


 I'll say what I just said on the UK CFUG dev/chat list.

 
  Read This:
  http://www.allaire.com/products/ColdFusion/productinformation/tools.cfm
 

 No where in that article does it say that it is one product.

 They are just packaged together in one box.

 Regards

 Stephen


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



OT: Search Engine

2001-04-23 Thread Derek Hamilton

I was wondering if anyone has had a good experience with any search engine software 
for the Win2000 environment.  We currently run Phantom on a MAC but that is dying a 
very quick death.  

TIA,

Derek Hamilton
Systems Developer


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Is CF still relevant?

2001-04-20 Thread Derek Hamilton

A couple thoughts...

Don't you think Neo/Java will enable CF to pull in other developers and let
those of us that know Java expand what we would typically do with CF?  Also,
don't you think that Allaire now being Macromedia will enhance it's staying
power and entice more developers to learn CF?

At our company we use CF because it is fast to develop with.  No other
language we've found has been so fast AND powerful.

Derek Hamilton
Systems Developer


- Original Message -
From: "Joseph Grossberg" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, April 20, 2001 12:27 PM
Subject: Is CF still relevant?


 Now, before you dismiss this as a troll, please let me elaborate. This
isn't
 so much an instigation or a whine as it is a call for us to take a step
back
 and reevalutate things periodically.

 Over the course of my career as a web programmer/developer, I have worked
 with a variety of sever-side languages and technologies: ColdFusion, ASP,
 JSP, PHP, Perl and Python. I like some more than others, but I'm not an
 evangelist for any; they each have their uses. And I recognize some of
CF's
 strengths: easy to learn for people who know only tag-based HTML or don't
 have significant programming experience; built-in admin tool; specialized
 editor; comes with pre-built tags and web-based administrator. There are
 also major flaws: broken/sketchy tags; no XML parsing; not OOP; relatively
 small community; etc.

 Right now, I work at a web development firm that is primarily "a CF house"
 (besides me). Our more senior programmers are looking at honing their CF
 skills, while our less experienced webmasters are trying to learn
 ColdFusion. But, I can't help but wonder whether they are wasting their
 time. Would they be better off spending their time learning ASP, Java or
 another non-CF solution? Why or why not?

 And how would we tell if and when it was time to give up CF and try
 something else, as all but the most stubborn experts in also-ran languages
 (Ada, SmallTalk), applications (Netscape, Lotus Notes) and Operating
Systems
 (Amiga) have resignedly done?

 Lastly, why do *you* still use CF? Is it because it's what you're best at,
 and you don't want to try something new (where, temporarily, you'd be a
 novice again)? Is it because your ccompany's legacy code is all in CF? Is
it
 because you genuinely think that ColdFusion is, generally speaking, the
best
 solution for web application development in 2001?

 Joe

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Is CF still relevant?

2001-04-20 Thread Derek Hamilton

I do agree with you on the bugs/fixes issue.  In fact I have been testing CF
5.0b3 recently and found out that a custom tag we wrote does not work
correctly with 5.0.  If we can't get that tag to work that will be a big
deal for us.  But I have to rely on Allaire only because of the cfx
environment and CF's processing.  (I know, it could be written as a COM
component but that wasn't my decision).

My question is, are you trying to rationalize some other decision or
something and just using CF for the mental validation?  What's up?  What are
you doing that CF doesn't excel at as much as you would like?

Derek Hamilton
Systems Developer

- Original Message -
From: "Joseph Grossberg" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, April 20, 2001 2:31 PM
Subject: Re: Is CF still relevant?


 You brought up and interesting point, and Neo will be a big boost to CF,
 IMHO, and I'll be psyched when it arrives. But if someone knows Java, why
 not just use JRun at that point? Also, Allaire doesn't seem to have a
 concrete date for CF Server 5 release, much less Neo (a.k.a. version 6).

 However, while I think that some additional stuff CF does is good (e.g.
 integration with Flash; I think the MM/Allaire merger is very
 complimentary), it seems like it's just way behind on other things. I
mean,
 even Perl programmers can use OOP and XML if they want to, but it's not
 necessary. With CF, you don't even have that option. ColdFusion just seems
 like it's always a step (or more) behind the competing technologies.

 I also don't like the fact that we're basically depending on one vendor
for
 everything except a smattering of custom tags and minor third-party
 applications. If something in Perl or Python doesn't work, someone fixes
it
 soon. If something in ASP or Java doesn't work, then MS or Sun fixes it
(or
 another company will sell it, because the market is large enough). But
since
 Allaire is solely responsible for CF Studio, CF Server, Spectra, JRun,
etc.,
 it seems like we're putting all our eggs in one basket. Like, "Oh, your
 upgrade to CF Server 4.5 broke your CFHTTP / CFFTP / CFMAIL tag? Well you
 have to downgrade to 4.0 or just wait ... until ... whenever we finally
 release 5.0 ... assuming it's fixed then."

 Like I said, I think CF has its plusses and minuses, but it just seems
less
 compelling to me by the month.

 Joe


 From: "Derek Hamilton" [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Subject: Re: Is CF still relevant?
 Date: Fri, 20 Apr 2001 13:40:36 -0700
 
 A couple thoughts...
 
 Don't you think Neo/Java will enable CF to pull in other developers and
let
 those of us that know Java expand what we would typically do with CF?
 Also,
 don't you think that Allaire now being Macromedia will enhance it's
staying
 power and entice more developers to learn CF?
 
 At our company we use CF because it is fast to develop with.  No other
 language we've found has been so fast AND powerful.
 
 Derek Hamilton
 Systems Developer
 
 
 - Original Message -
 From: "Joseph Grossberg" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Friday, April 20, 2001 12:27 PM
 Subject: Is CF still relevant?
 
 
   Now, before you dismiss this as a troll, please let me elaborate. This
 isn't
   so much an instigation or a whine as it is a call for us to take a
step
 back
   and reevalutate things periodically.
  
   Over the course of my career as a web programmer/developer, I have
 worked
   with a variety of sever-side languages and technologies: ColdFusion,
 ASP,
   JSP, PHP, Perl and Python. I like some more than others, but I'm not
an
   evangelist for any; they each have their uses. And I recognize some of
 CF's
   strengths: easy to learn for people who know only tag-based HTML or
 don't
   have significant programming experience; built-in admin tool;
 specialized
   editor; comes with pre-built tags and web-based administrator. There
are
   also major flaws: broken/sketchy tags; no XML parsing; not OOP;
 relatively
   small community; etc.
  
   Right now, I work at a web development firm that is primarily "a CF
 house"
   (besides me). Our more senior programmers are looking at honing their
CF
   skills, while our less experienced webmasters are trying to learn
   ColdFusion. But, I can't help but wonder whether they are wasting
their
   time. Would they be better off spending their time learning ASP, Java
or
   another non-CF solution? Why or why not?
  
   And how would we tell if and when it was time to give up CF and try
   something else, as all but the most stubborn experts in also-ran
 languages
   (Ada, SmallTalk), applications (Netscape, Lotus Notes) and Operating
 Systems
   (Amiga) have resignedly done?
  
   Lastly, why do *you* still use CF? Is it because it's what you're best
 at,
   and you don't want to try something new (where, temporarily, you'd be
a
  

RE: IIS extension mapping to script engine

2001-03-30 Thread Derek Havelock



IT Star
Web Design, Hosting, Database Integration and Internet Marketing
http://www.itstar.co.uk/
[EMAIL PROTECTED]

-Original Message-
From: Kevin Miller [mailto:[EMAIL PROTECTED]]
Sent: 30 March 2001 00:00
To: CF-Talk
Subject: IIS extension mapping to script engine


I wish to map all file extensions to te Cold Fusion scripting engine.  Is
there a way to do this using wildcards?  I have only been able to set this
up one extension at a time.

NT4 SP6a
CF 4.5.1 SP1
IIS 4

Thank you,

Kevin
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: limitations of Access

2001-03-29 Thread Derek Havelock

Can I possibly add a question to this string ...

Larry, you mentioned that:

we were running an auction site using Access that always was running at
least 30 concurrent
sessions at a time with 5 items in the database and did not appear to
have a major problem.

I don't see how that is possible - but am hoping that you can teach me
something here.
At the last place I worked, when more than one person accessed the same
Access file, they were simply locked out. This would frequently happen when
a salesperson tried to get into the product database to answer a customer
query, but a product manager would already be in the file. - major disputes
in the office when the customer can hear every word down the line :-)

You mention "30 concurrent sessions" by which I take it to mean that 30
users can be within the same file at the same moment in time. Surely, with a
file-based package, this is not possible? If you can indeed do this, I would
greatly appreciate any info you can give me to solve such a problem.

Kindest regards,

Derek

BTW - a leap from Access to Oracle A major leap!!
:-)

IT Star
Web Design, Hosting, Database Integration and Internet Marketing
http://www.itstar.co.uk/
[EMAIL PROTECTED]

-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: 29 March 2001 15:40
To: CF-Talk
Subject: RE: limitations of Access

I am not totally 100% sure on this, however I do know that we were running
an auction site using Access that always was running at least 30 concurrent
sessions at a time with 5 items in the database and did not appear to
have a major problem.  We did upscale the site to Oracle however just to NOT
have any possible problems.

I know this is not what you wanted to hear, but it is some proof that the
low numbers may not be totally accurate.

Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.


-Original Message-
From: Kay Smoljak [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 12:33 AM
To: CF-Talk
Subject: limitations of Access


Hi all,

I am doing a quote for a client that has an existing CF site using Access.
They are a professional organisation hosting their own server and I'm trying
to get them to steer away from Access, as I think the site has the potential
to get more hits than Access can easily handle. So far they are determined
to stick with it.

I need some ammo... I know Access is not suitable for the job they want it
to do, but I'm not sure of the facts and figures. I think someone once
before said that Access cannot handle more than 5 concurrent users but I'm
not 100% sure.

So does anyone have any concrete figures on the capabilities of Access?

Thanks,
K.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Oracle Error 936 missing expression?? Query problem?

2001-03-27 Thread Derek Havelock

What about:

WHERElive = YES and top = NO

My understanding is that with Boolean characters, you don't put in an
apostrophe

If your designations aren't Boolean, try:

WHERElive = 'YES' and top = 'NO'

Regards,

Derek

IT Star
Web Design, Hosting, Database Integration and Internet Marketing
http://www.itstar.co.uk/
[EMAIL PROTECTED]

-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: 27 March 2001 15:19
To: CF-Talk
Subject: Oracle Error 936 missing expression?? Query problem?

Hello All,

I have a simple query, for an oracle database and I keep getting an
error message. What the heck is wrong with my query!

CFQUERY NAME="GetNews" DATASOURCE="#application.DSN#" SELECT
headline, news, blurb, date_entered, newsID, live, top
 FROM news
WHERE(live = 'YES') and (WHERE top = 'NO')

ORDER by date_entered  DESC
/CFQUERY

  I've tried everything in there. It seems to be an error with syntax
  and the WHERE line.

  Any hints, clues or great answers are much appreciated!

Best regards,
 Jeff Fongemie  mailto:[EMAIL PROTECTED]

Internet Guns For Hire
(603) 356-0768
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: SQL Business Dates

2001-03-27 Thread Derek Havelock

Can you slip in

CFSET today = DateFormaNow(), )

CFIF #today# NEQ Saturday OR Sunday
Your code here ...
CFELSE
Your alternative code here ...
/CFIF

just a thought ...

Derek

IT Star
Web Design, Hosting, Database Integration and Internet Marketing
http://www.itstar.co.uk/
[EMAIL PROTECTED]

-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: 27 March 2001 20:31
To: CF-Talk
Subject: SQL Business Dates

I have a query ...
SELECT AVG(DATEDIFF(minute, dateasgn, datecomp)) AS diff
FROM tblprob
WHERE priority = 'urgent'
AND datecomp IS NOT NULL
AND status = 'closed'
AND dateasgn = '#form.startdate#'
AND dateasgn = '#form.endDate#'

but I only want the business dates (no weekends or nights; just 9AM to 5PM
Mon
to Fri)

This is in SQLServer. Any help appreciated.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Database Images

2001-03-26 Thread Derek Havelock

What I do is hold the URL of an image (rather than the image itself) in a
database - allows cross reference against db records, and provides quick
accessibility to images pertinent to a situation.

HTH,

Derek

IT Star
Web Design, Hosting, Database Integration and Internet Marketing
http://www.itstar.co.uk/
[EMAIL PROTECTED]

-Original Message-
From: lsellers [mailto:[EMAIL PROTECTED]]
Sent: 26 March 2001 19:09
To: CF-Talk
Subject: RE: Database Images

 When you store an image in the database, how do you go about
 displaying it
 on the HTML page? Right now, I am simply storing the URL in the DB to the
 image file on the hard drive, but looking to storing them in the
 actual SQL
 Server dataabase as another solution. I just wanted to find out how one
 would go about doing this and get any feedback from those who have used
 this
 technique.

The current design of most HTTP servers that seperates it from a database
makes this inefficient. If a database server were to construct a http
service/daemon that directly interfaces with it this would be more feasible.

At the moment there are few situations that warrant such an overhead
(keeping security badge ids, etc being among the few, for example.)

--min
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Link that submits form

2000-09-25 Thread Baker, Derek

Add parentheses around the whole javascript function call.
a href="javascript:(document.myform.submit());"

 -Original Message-
 From: Chapman, Katrina [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, September 25, 2000 1:47 PM
 To:   CF-Talk
 Subject:  FW: Link that submits form
 
 I tried posting this on Friday but it apparently didn't go through.  So
 here
 it is again.
 
 FORM NAME="myform"
 A HREF="javascript:document.myform.submit()"IMG SRC="text1.gif"
 WIDTH="16" HEIGHT="16" BORDER="0"/A
 /FORM
 
 
 --K
 
   -Original Message-
  From:   System Administrator  
  Sent:   Saturday, September 23, 2000 4:59 PM
  To: [EMAIL PROTECTED]
  Subject:Undeliverable: RE: Link that submits form
  
  Your message did not reach some or all of the intended recipients.
  
Subject:  RE: Link that submits form
Sent: 9/22/00 4:58 PM
  
  The following recipient(s) could not be reached:
  
[EMAIL PROTECTED] on 9/23/00 4:59 PM
  The recipient was unavailable to take delivery of 
  the message
  The MTS-ID of the original message is: c=US;a= ;p=Volt 
  Information;l=CA_EXCHANGE1-000922235809Z-79020
  MSEXCH:IMS:Volt Information 
  Sciences:Orange:CA_EXCHANGE1 3499 (000B099C) Host unreachable
  
 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.