The undisputed, World heavyweight champion of CF books - The Coldfusion web
application construction kit by Ben Forta (publised by QUE)
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
Functions have the ability to return a value but don't have to. Procedures
do not return values.
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
If this is no good you could look at making th content dynamic and building
a Remote Management System for the client to use to change the content. By
using Java Script you can even allow the users to italisise, make bold,
underline, etc.without requiring them to have any HTML knowledge.
I know someone (called Kevan who reads this list!) who had a similar problem
where, when using netscape, a form object of type file was not getting
posted with the form. Come to think of it I think none of the other form
controls were posted either. I may be getting things mixed up - Kevan -
OK guys and gals..
Do Client vars take up more server RAM than session Vars. My colleague
reckons they do wheras I reckon it's the t'other way round
A
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
Software
1400 16th St NW, # 500
Washington DC 20036
202.797.6570 (direct line)
www.figleaf.com
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 11:55 AM
To: CF-Talk
Subject: Session VS Client
OK guys and gals..
Do Client vars take up
, otherwise it stores client variables in the
registry which is less efficient that using session vars.
so in a way you're both right :)
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: 23 April 2001 16:55
To: CF-Talk
Subject: Session VS Client
OK guys and gals..
Do
in any number of different locations (registry, client cookies, ODBC
datasource).
Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23
202.797.6570 (direct line)
www.figleaf.com
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 12:11 PM
To: CF-Talk
Subject: RE: Session VS Client
Wouldn't haver thought it makes a difference. You either have to put them
in a db or the registry
Client variables are probably a better choice if you think you're going to
cluster your application on multiple servers, but on a single server,
session variables will perform much better, assuming that there's enough
emory to hold them.
Yup agreebut I think you have answered my initial
I agree, this seems to be a hazy area. I tend to use client vars even if it
isn't a clustered environment. IMO I think that the only disadvantage of
Client vars is you can't expire them as easy as you can with sesison vars,
you have to go to the DB and clear the entry. However the fact that
Have you tried running this code directly at the db?...i.e. if SQL run in
query analyser. One thing you could try is put trim statements around the
fied (or LTRIM and RTRIM if you are using SQL). i.e:
SELECT * FROM RodeoManager WHERE TRIM(CircuitID) = #TRIM(url.CircuitID)#
OR:
SELECT * FROM
Can you output the generated SQL and post it to this list. In the meantime
you could always try to build up a sql string in SQL and execute it using
EXEC(sqlstring) to see if this works. Sometimes I've found it makes a
difference
what error message are you getting? Can you post it here.
I've had problems in the past with using dynamic field names in SQL. Again
try building up an SQL string and executing it
--
Andrew Ewings
Project Manager
Thoughtbubble
(sqlstring) .. (Recent convert from Access to SQL - and still
learning the tools)
??
Thanks!
D
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
One man's magic is another man's engineering. ---Lazarus Long
-Original Message-
From: Andy Ewings [mailto
, at the end, etc. and it always chokes on the first item in
the list)
Thanks!
D
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
One man's magic is another man's engineering. ---Lazarus Long
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED
Do you mean that you want to add to what's already there?.eg. A field
called name contains Becky and you want to update it to be
BeckyJones?...if so what you need is:
UPDATE table SET fieldname = fieldname + 'NewValue'
This will only work with a chrachter field
Andy
I I reckon DAO...although that could start a war on here! Basically DAO was
written for the JET engine so goes hane in hand with Access. ADO is more of
a generic data access method - tries to be everything to every data source
(and does it well!)can't say I've done any performance testing
You wet your finger and then stick it in the air
only kidding - Here are some factors that affect cost:
Physical web space given (Mb's)
Database utilities (MS SQL, ORACLE, etc)
Email accounts
Support
CGI Bin
+ any other Server Side utilities (such as CF)
Are you passing a form filed of type file?.
What is the type of the filed that is not appearing?
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
OT ADO vs DAO
Thats how I saw it too.
As I'm new to this side of things, can you tell me, is it possible to use
both in an Access DB?
Cheers
Will
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: 26 April 2001 11:03
To: CF-Talk
Subject: RE: slightly OT ADO vs DAO
Donna
As a test try using a normal form as opposed to a coldfusion form to see if
this is what's causing the prob.
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
, but that doesn't make too much sense
to me??
Cheers
Will
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: 26 April 2001 14:41
To: CF-Talk
Subject: RE: slightly OT ADO vs DAO
Yeh I think so. My use of DAO/ADO/RDO was through VB. Just used each to
create connection and query
, to be honest, but a more experienced VBA
developer than me said the errors were due to this difference between DAO
and ADO.
I will try using ADO syntax and see if that works.
Thanks for all your input Andy
Will
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: 26
I made a post some time ago along these lines but the problem stiull remains
so I though I might try again:
I have a site sat on 2 web servers with load balancing. I have a page that
when called uses HTTP and CFFile to wirte info to a file on a shared drive
on the server using a mapped drive.
enough info in your post to go further (ie
webserver, cf version etc).
HTH
Paul
-Original Message-
From: Andy Ewings [SMTP:[EMAIL PROTECTED]]
Sent: 30 April 2001 12:18
To: CF-Talk
Subject:problem writing to a file
I made a post some time ago along these lines
Nopeanyway the code you have suggested won't work anyway as you will
have an extra OR at the end of your SQL statement.
Just one point to make. If your table that you are updating is being used
for transactions (updates, selects, inserts) on a regular basis then you
should rethink your
Get the value of the vars and run it directly in the db so you get a
meaningfull error message
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
Create a query and use the SQL view
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
--
United Kingdom
Depends what you want it to do. I'd suggest indexing your tables so you
have optimum performance and then limit the number of records returned by
the DB. I can't imagine you want to display all 40,000 recs do you?
--
Andrew
woah...touchy.that'll teach you to offer help Dylan!
Can you tell us exactly what datatypes all three fields are in the db.
What happened when you ran the query directly in Access?
--
Andrew Ewings
Project Manager
This won't work because you are including a column (name) in your select
list that is not included in an aggregate function, which you need to do if
you are grouping
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: 02 May 2001 15:31
To: CF-Talk
Use Distributed transaction control from within SQL. Don't let CF deal with
it. You need a Stored proc which calls each of the three sp's within a
distributed transaction. If either of them fails you need to trap the error
and rollback the transaction. I'd put normal transaction contrpol
Hear hear!...another advocate for VSS!Do you know if it is possible to
download a trial version? I have used it many times before but want to get a
trial version to demo to bosses at work to try to persuade them to buy it.
Can't find anywhere where I can do that.
If I were you I'd put it in an SP. I know there used to be a limit to the
length of an SP in 6.5 but as far as I'm aware this issue was addressed in 7
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
The VB function to convert to an Integer is CInt(string). Will obviously
only work if the string can be converted to an int.
However - If I remeber correctly (and it's been a while!) I thought that in
ASP you can't delare datatypes for variables.
i.e in VB you do: Private myvar as int
in
you hit the 64k limit.
You can't get a SP to simulate this type of behavior.
Mark
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 8:12 AM
To: CF-Talk
Subject: RE: Limit on SQL passed via CFQuery to SQL Server?
If I were you I'd put
Nick
Yeh I thought that sounded pretty interesting too! I'm the first person to
admint that serverlets are pretty coollightning quick if I remember
correctly. What bothers/worries me is how you can convert your cfml code
into a serverlet without losing anything in the
Not sure about Access but in SQL you have to specify the fact that it's an
outer join so instead of LEFT JOIN use LEFT OUTER JOIN.
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
technology as you
should also be able to intermix pure Java with CF in the same template.
Heard this from a Jrun seminar a few months ago...
Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com
-Original Message-
From: Andy
2 insert statements needed here
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
--
United Kingdom
http://www.thoughtbubble.co.uk/
There is another way..
You could insert the data into one of the tables and then have an insert
trigger on that table which automatically inserts the same data into the
second table. However you can only do this if every time you insert into
table 1 you want the same data to go into
what is the field type that is receiving the amount?if it's a charachter
field then you are ok. If not then you will have to remove all comma before
passing to the SQL string
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
Can you include the call to the GetSubjects query too...
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
--
United Kingdom
you should be able to do the same thing. It's not the VB that interprets
the brackets it's the SQL itself. I assume you are passing in a field list
into a SP as a param so you know what fields to update?just put brackets
around the field names.
A
P.S. shoot your DBA..before he goes
I've had problems with using money fields in the past. In fact the last
place I worked the DBA's would not allow any fileds of type money at all.
Can you get away with using an integer field?
Jusat a poinbt to note - you are removing the commas before inserting but
are you removing the $'s too?
Yep we had an identical thing where students had to select a school that
they attended in the UK from the complete list of schools (a lot!). We got
around it asking the user to enter the first three letters of there school -
we then present them with the form with a reduced list of schools
Nick has got a point that there is no guarantee of support for DAO (or RDO
come to that) but I can't see MS dropping uspport for something that ties in
so closely with a db that is so widely used
--
Andrew Ewings
Project Manager
The reason you are getting multiple records in the subquery is cos you've
removed the table aliases that Brian suggeted. Put them in and you should
be ok if the rest of your data is in the same pattern as the sample dat ayou
posted. i.e.
UPDATE mytable m
SET DATE1 = (SELECT DATE1
IF EXISTS (SELECT * FROM sysobjects WHERE name = tablename AND type =
P)
BEGIN
Table exisits!
END
ELSE
BEGIN
table doesn't exist
END
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
us on +44 (0)207 387 8890.
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: 14 May 2001 10:11
To: CF-Talk
Subject: RE: SQL 7.0 (checking for the existence of a table)
IF EXISTS (SELECT * FROM sysobjects WHERE name = tablename AND type =
P)
BEGIN
Table
First thing to note is the where clause in your select statement. I'm don't
think it's doing what you want as you have and's and or's with no brackets
seperating them. I'd suggest that in your where clause you only put
conditional
values and not links between tables. For links between tables
What are you expecting to get?
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
--
United Kingdom
http://www.thoughtbubble.co.uk/
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
--
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
I've found the ones produced by Wrox Press and Que are good. I hear
Professional SQL Server 2000 Programming by Robert Viera is quite good
although I haven't read it. There are plenty of beginning SQL server books
which are more likely to cover the basic Transact/and ANSI SQL language but
they
Post the code you tried yesterday and we'll have a look.
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
--
United Kingdom
Replace the = with IN in your where clause like so:
update ovdsave
set ovdsave.updatedate = getdate()
where ovdsave.sonum IN (SELECT ovdtemp.SONUM
FROM ovdtemp)
This is because SELECT ovdtemp.SONUM FROM ovdtemp returns more than 1
record
The CFStoredProc tag allows you to call stored procedues on the server.
Stored Procedures are essentially queries that are stored on the server (as
opposed to queries thrown at the server using cfquery). This means the
following:
1) Stored Procedures are much faster because a query plan for the
notify us on +44 (0)207 387 8890.
-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: 17 May 2001 13:04
To: CF-Talk
Subject: Re: CFSToredProcedures
Can I still pass params to it?
- Original Message -
From: Andy Ewings [EMAIL PROTECTED]
To: CF-Talk [EMAIL
Try a product called Co-Standby. I am running a site on 4 servers - 2 WEB
and 2 SQL servers. One of the SQL servers is live and the other is passive,
both sharing a disk array containing the databases. If server 1 fails then
server 2 takes over.
Don't think so..I think it only controls SQL services. I have not set
one up myself. Our ISP set the cluser up for us and just tell us what each
bit does.
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
OK I know this thread has been flogged to death as to which of the 2
performs better cfloop or cfoutput when dealing with queries but as far as I
knew no-one had come to a defenite conclusion. Thought it was worth
mentioning that in the new book Certified ColdFusion Developer Study Guide
(one of
I seem to recall someone asking on here if anyone knew of a definitive
Transact SQL reference book. I've stumbled across this one at Amazon called
The Gurtu's guide to Transact SQL by Kenneth Henderson - anyone read it?
gotten past the basics.
Bob
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 9:27 AM
To: CF-Talk
Subject: Transact SQL book
I seem to recall someone asking on here if anyone knew of a definitive
Transact SQL reference book. I've stumbled across
You could use a trigger to check and remove the record if conditions not met
although I'd say this is far from ideal..mainly because it's not sa
watertight and also the person/software inserting will be unaware that their
insert has been removed
By using WDDX
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
--
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20
I have an off topic question re java/javascript which I'm hoping someone
will be able to answer!
I have a java applet that is a slider control with 5 interval values. I
also have an image on the page. I want to change the location of this image
when the sliuder gets moved (i.e. when the
If you are using images as submit buttons and detecting whether they have
been clicked or not you need to follow the control with a .x i.e. if you
have 2 images as submit buttons with names image1 and image2 and you want to
test in your action page whether the user clicked image1 you need cfif
I'm having a mind blankarghhh. I'm trying to incremtnet the value of a
control in a form by one where part of the controls name is poassed in as a
variable. Probably best I explain with the code snippet:
function test(controlnum) {
document.forms[0].interest + interest + .value =
[mailto:[EMAIL PROTECTED]]
Sent: 24 May 2001 12:32
To: CF-Talk
Subject: RE: OT Javascript question
Andy
Does this work?
function test(controlnum) {
elt = document.forms[0][interest + interest];
elt.value = parseInt(elt.value) + 1;
}
Nick
-Original Message-
From: Andy Ewings [mailto
To: CF-Talk
Subject: RE: OT Javascript question
parseInt() is a method of the String object, so try
elt.value = elt.value.parseInt() + 1;
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: 24 May 2001 13:58
To: CF-Talk
Subject: RE: OT Javascript question
MopeI tried
Can you have dynamic variable names in CF?e.g in an action page could
you have something like -
cfset thelist =
cfloop from=1 to=3 index=id
cfset thevalue = Evaluate(form.fieldnum #id#)
cfset thelist = ListAppend(thelist, thevalue)
/cfloop
where there are form fileds
Yeh I've written plenty of VB in the past to read from the registry by using
various API functions, however never done it remotely as your
suggestingnot sure if it can be done
-Original Message-
From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]]
Sent: 25 May 2001 15:33
To: CF-Talk
I reckon that the Allaire (oops Macromedia) certification is more highly
rearded. We've got a couple of Brainbenchers here but no ACP's as yet. We
are waiting for the CF5 test to come out before we send people on it because
we've heard that any certification we get now will expire as nthe newer
Our man James Maltby is one too...
RESPECT ;-)
Still think your better off being ACP. Does the Brainbench certification
expire with new version releases? and what is the pass mark?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 30 May 2001 11:16
I agree with this - the ACP is supposed to be easier than the MCP tests by
all accounts. you only need 60% to get ACP but 80% for MCP. Bear mind that
being ACP doesn't necressarily mean that you are a top CF programmer - just
shows you know a thing or two about it. You can exam cram and pass
and conditions of engagement
a copy of which is available on request.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Andy Ewings
Sent: 30 May 2001 11:11
To: CF-Talk
Subject: RE: Brainbench
.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Andy Ewings
Sent: 30 May 2001 13:08
To: CF-Talk
Subject: RE: Brainbench certification
Really? - can you point me in the direction of this? I got
Yep - your problem is that you need to pass in a date object into the
function daysinmonth. So you need:
cfset
date1=dateformat(createdate(year(now()),month(now()),daysinmonth(now()),mm/
dd/)
-Original Message-
From: Steven Dworman [mailto:[EMAIL PROTECTED]]
Sent: 01 June 2001
what's the data type of the field objectcontent and exactly how long is your
string?
-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]]
Sent: 01 June 2001 15:40
To: CF-Talk
Subject: Re: Crazy Dynamic Update/FORM Structure question
Ok, I tried plugging the content into a test
Paul
Put this in your application.cfm:
cfif IsDefined(Cookie.CFID) AND IsDefined(Cookie.CFTOKEN)
cfset cfid_local = Cookie.CFID
cfset cftoken_local = Cookie.CFTOKEN
cfcookie name=CFID value=#cfid_local#
cfcookie name=CFTOKEN value=#cftoken_local#
/cfif
This
Just to combine my last post and Dave's -
Dave is right - you need to set the cookie with no expire time. The only
problem is that if you switch on Clientmanagement and leave the rest to CF
it writes the cookies CFID and CFTOKEN to the users browser with an expiry
time equal to that of the CF
At last!.a definitive answer.cheers for this Arden. Best book this
exam before the 14th then :-)
-Original Message-
From: Arden Weiss [mailto:[EMAIL PROTECTED]]
Sent: 05 June 2001 13:23
To: CF-Talk
Subject: FW: 4.5 certification to 5.0
FYI -- The word from our favorite vendor
Kevin
I have had an absolute nightmare with CF and dates. I wrote a complex
application which completely depended on date manipulation and the only
robust way I found to do it was as follows. I createed dates in CF by using
CreateDate to perform date validation. When I came to add it to the
If someone were able to hack into ftp though, what would it matter if
they had the username and password? They wouldn't need it if it were
set up in CF Administrator. They could just build a query right there
and run it. So it still seems to me that you would be safer hard
coding it since:
CF doesn't deal with variables in this way. If you do CFSET a =
DateFormat(now(),dd) then a is neither a string, number or date. CF
decides what type the variable is once you combine it with an operand For
example if you tried to do a mathematical function on it (say add it to
another number)
Big debate on this but the official word is ithe 4.5 exam expires on the
14th July. If yopu take, and pass beofre then you will automatically be
grandfathered up to 5.0
-Original Message-
From: Chang Liu [mailto:[EMAIL PROTECTED]]
Sent: 07 June 2001 17:16
To: CF-Talk
Subject: certified
If you've onlyu got 500,000 recs between the three the machine you have
should suffice unless you are running all sorts of other stuff on it. we
have a machine here that is a P500 but we are running it as a file server,
mail server, web server, and SQL server.
The main cause of the speed
Just have one table with all of the pages in which inclues the following
fields:
id - Unique ID for entry
parentid - ID of parent page (this value is 0 for category pages)
That way you have a heirachical data structure within 1 table. Querying the
table becomes a bit trickier but still ont
Probably because the distrib_id field is of type integer. Try removing the
quotes around it in the where clause so you've got:
WHERE distrib_id = #distrib_id#
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
Try putting hashes around dos and using = rather than LTE. You also have a
bracket missing around your ABS function like so:
CFQUERY name="getkundeinfo" datasource="abx2" dbtype="ODBC"
select distinct forsikring.*,kunde.*
from forsikring, kunde
where kunde.kundenr =
Are you using SQL server? If so cut and paste the SQL into query Analyser
and run it replacing the variabls with their values. First find out exactly
what values are being passed to the query. I'm not sure you need to use
CreateODBCDatetry doing it just passing in 2 strings containing
Create a query directly in Access using the values for the variables (make
sure yo know exactly what they are by outputting them to the screen with
lines of debug code in your cfm). If you get the result directly in Access
(which I doubt) then you know it is something between CF and Access,
Not sure if you can do it in Access in one statement. I think I would
insert into USERS and a intermediary table and then insert iton Wages based
on the content of the intermediary table. If you could use SQL ~Server then
it would be easier. You could create an SP which inserts into USERS and
Probably because the AOL browser has session level cookies swiched off.
What you should do to overcome this is create a variable in your
application.cfm that is the CFID andd CFTOken appended together if cookies
are switched off. Then append this variable to every hyperlink/form
Now Now Paul, no need to be condecending!.just cos you've risen to the
dizzy heights of talking at a CFUG!.which reminds me...I'll see you
there later!...make sure you tell em everything we taught you at TB!
--
Andrew
SELECT Player, SUM(Points)
FROMtblone
GROUP BY Player
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
--
United Kingdom
I agree.sounds like the Client variable is expiring. Yo need to store
it in a ccokie on the users pc (providing they accept cookies) or store it
in a db on the server and pull this info when they log in.
--
Andrew Ewings
Interesting! When I started to develop SP's a few years ago I was told to
make the maximum size of my varchar variables 255 but never new why! The
company I worked for didn't use ColdFusion so I assume this is due to the
ODBC restriction you are talking of. I am confused though because if you
1 - 100 of 540 matches
Mail list logo
