On a sturdy enough box, CF might handle the load, it depends on how complex
the code is.
MySQL *won't*. If you're really going to get that kind of traffic, don't
mess around with the small-fry, go to Sybase, Oracle, or at least
PostgreSQL.
A dual P3 is not the most important issue, and in fact,
Hi,
I'm new to CF and am using version 4.5.1 of both Studio and Server. I have a
COM object that returns a generated integer value. I can use this COM object
in any COM enabled Windows app. However, when I try to use in a cfm page I
get the following error:
An error occurred while evaluating
On Thu, 24 Aug 2000, Michael Sheldon spake thusly:
On a sturdy enough box, CF might handle the load, it depends on how complex
the code is.
MySQL *won't*. If you're really going to get that kind of traffic, don't
mess around with the small-fry, go to Sybase, Oracle, or at least
PostgreSQL.
Interesting, I had exactly the opposite experience, I also found the user
community (at the time) was very CF-like and helpful. One reason was, at
the time I dl'd the demo product, their user support forums were on Allaire
Forums - certainly not a good reason to endorse the product - just
I'm sure there's a nifty function that does exactly that for you - but without looking
in the manual you could always do this:
!--- Move the calculation over two decimal places, add .5 and truncate, then move it
back ---
cfset result = ( thisval / thatval * 100 + 0.5 ) \ 100
At 03:06 PM
I have the following as cfscript:
if (not(structKeyExists(session.cart, attributes.name)))
I would like to use it as a CFIF statement. Any ideas how to go about
constructing said cfif?
--
***
Jon Tillman
LINUX USER: #141163
ICQ: 4015362
Hi, folks
I´m making a search engine for a web site and I´m having some problems,
it would be great if someone could help me.
I have to make searches in results of searches in the web site, and I
can´t make them work.
Is it posible to index the results of the searches in the
Ok. Everyone agrees Java servers kick its butt it seems! The question is
though - by how much? How many Cold Fusion servers does it take to service
the same number of users as one of those Java servers? 2? 3? If we're
talking about numbers like that then that's not so bad considering CF costs
Now my question: should both queries be run in the mainframe.cfm file
and then the results somehow passed to the frames where they are used
(if this is even possible), or should the queries be run individually
in the separate frames? Or since the frames share the results of the
queries, do
quick question:
is there any way to check to see if a table exists without querying it, and
throwing an error if it does not? I want to either CREATE or INSERT a table
depending on whether or not it already exists
--
***
Jon Tillman
LINUX USER:
Yupif you are using SQL server the syntax is.
IF EXISTS (SELECT * FROM sysobjects WHERE name = "tablename" AND type =
"U")
BEGIN
PRINT "Table Exists!."
END
-Original Message-
From: Jon Tillman [mailto:[EMAIL PROTECTED]]
Sent: 24 August 2000 11:09
To: [EMAIL PROTECTED]
You sir, are a hero, a true hero of the revolution
On Thu, 24 Aug 2000, Andy Ewings spake thusly:
Yupif you are using SQL server the syntax is.
IF EXISTS (SELECT * FROM sysobjects WHERE name = "tablename" AND type =
"U")
BEGIN
PRINT "Table Exists!."
END
-Original
Oh no, I spoke too soon:
[Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE',
'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.
Data Source = "health-horizons"
SQL = "IF EXISTS(INSERT INTO 96961133 (productID, productQty) VALUES(54, 1);)"
On Thu, 24 Aug 2000,
Oh no, I spoke too soon:
No, it just looks like you're using the wrong query string from somewhere
else on the page, Andy was spot-on.
Nick
**
Information in this email is confidential and may be privileged.
It is intended
Thats because you are using Access..the suyntax I sent is for SQL
Server.never done it with Access
-Original Message-
From: Jon Tillman [mailto:[EMAIL PROTECTED]]
Sent: 24 August 2000 11:20
To: [EMAIL PROTECTED]
Subject: RE: checking for tables?
Oh no, I spoke too soon:
Access!
Good point!
Try
IF EXISTS(SELECT * FROM MSysObjects WHERE ParentID = (SELECT Id FROM
MSysObjects WHERE Name = 'Tables') AND Name = 'tablename')
Nick
**
Information in this email is confidential and may be privileged.
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--_=_NextPart_000_01C00DB7.5A03581E
Content-Type: text/plain;
charset="iso-8859-1"
Hi Chris
Just a thought but you may be able to use DHTML to
All,
Do any of you lot know of any custom tags that will build the [1-10][11-20]
style navigation at the bottom of a long list of results, the sort of thing
that appears a LOT on search engines?
--
Neil Middleton
Technical Director
Stez Media
Neil Middleton studied ancient Greek and Roman
On Thu, 24 Aug 2000, Andy Ewings spake thusly:
Thats because you are using Access..the suyntax I sent is for SQL
Server.never done it with Access
I wonder if it is even possible with Access
-Original Message-
From: Jon Tillman [mailto:[EMAIL PROTECTED]]
Sent: 24
On Thu, 24 Aug 2000, DeVoil, Nick spake thusly:
Access!
Good point!
Try
IF EXISTS(SELECT * FROM MSysObjects WHERE ParentID = (SELECT Id FROM
MSysObjects WHERE Name = 'Tables') AND Name = 'tablename')
I hate to be a pest, but do you happen to know how thta would work with an
INSERT INTO,
On Thu, 24 Aug 2000, Neil Middleton spake thusly:
All,
Do any of you lot know of any custom tags that will build the [1-10][11-20]
style navigation at the bottom of a long list of results, the sort of thing
that appears a LOT on search engines?
the "LAST 5" "NEXT 5" ?
go here:
On Thu, 24 Aug 2000, Andy Ewings spake thusly:
What you want to do is test to see if the table is there. If it is Insert
data into it, if not create it first and then insert into it right? What
Nick has done is to provide you with the first line of code you need. If
the test succeeds then
I'm not sure of the Access syntax but I would have thought you wanted
IF NOT EXISTS(SELECT * FROM MSysObjects
WHERE ParentID = (SELECT Id FROM MSysObjects WHERE Name =
'productID')
AND Name = '#CFTOKEN#')
CREATE TABLE Here!!
END IF
Do INSERT here
IF EXISTS( SELECT *
FROMMSysObjects
WHERE ParentID = ( SELECT Id
FROM MSysObjects
WHEREName = 'productID')
1. I have a query that uses a variable passed to it from the previous
page:
CFQUERY NAME="List" DATASOURCE="dsn" USERNAME="usr" PASSWORD="pswd"
CACHEDWITHIN="#CreateTimeSpan(0,0,0,0)#"
SELECT DISTINCT Task.Task_ID AS ID,Task.Task_Description AS WORDS
FROM Task INNER JOIN Service_Scope3 ON
I can't pinpoint why your code is not working. Here is what I found when I used CF to
access my COM object.
First, I found that I had problems trying to pass parameters to my method. Instead I
created properties on the object and set those. Then I would call the method without
any
It depends on your database to some extent.
If you're using Access the simplest solution would be to link the
emp_course table in PQR to emp_details in XYZ using the file/get external
data/link tables menu. You can write SQL statements specifying XYZ as the
datasource and reference the
Hi, all! We're working with a client that wants to offer all of their web
content in multiple languages. At this time, all of the languages they want
are single-byte, however, they will be adding some double-byte in the
future. Any recommendations or sites on how to set up the datasources to
Hi All,
I'm reading about this CFTRANSACTION tag, and I'm not really clear on what
it's used for.
The CF Web App Const. Kit book states that it "...implements transaction and
rollback processing. Any CFQUERY tags placed between CFTRANSACTION and
/CFTRANSACTION tags are automatically rolled
I'm not sure about whether CFTRANSACTION only applies to database
stuffcan someone clears this up?
What I do know is that if you have say 2 CFQuery's - one which inserts a
bunch of records and then the next updates them say, then, if the insert
succeeds but the update fails then the insert
A co-worker is experienced in Oracle but finds himself faced with the task of
working with Microsoft SQL Server. He doesn't need to learn SQL or relational
databases. He just is looking for the book, or set of books, best for
programming, design, and administration of a Microsoft SQL Server
The only book I've read that I thought was superb was "The Hitchikers guide
to VB and SQL Server". This is only really any good if he is using VB to
access SQL although it does explain the difference between methods of data
access very well (ADO, ODBC, OLEDB, RDO, etc) IF he is using CF to
In the near future I am going to have to transfer a dataset produced by an
Oracle database into SQL server (7). My web site (written in CF) uses this
database. Has anyone had any experience in doing this and if so did they
experience any problems?
Interesting, in CFTRANSACTION you have to reference the same DSN. I wonder
how Phil uses multiple DSN's between CFTRANSACTION Tags?
Neil
- Original Message -
From: "Philip Arnold - ASP" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 24, 2000 8:21 AM
Subject: RE:
I have a form page and I am dynamically generating field names from my
database like so:
cfform
cfinput name="Reference_#ReferenceID#"
Submit
/cfform
in some cases there are 10 input boxes and in otheres there are 2 onput
boxes, My question is how can I capture these fields in the
How about a hidden field with a list of the #ReferenceID#'s ? Then you
could loop that list?
Thanks,
Neil
- Original Message -
From: "Jason Glaun" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 24, 2000 8:32 AM
Subject: picking up form variables on the action page??
cfif not structKeyExists(session.cart, attributes.name
blah
/cfif
- Original Message -
From: "Jon Tillman" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 24, 2000 07:27
Subject: CFSCRIPT question
I have the following as cfscript:
if
This is another way to do it however it seems less efficient since there
could be several other fields in the form. I was assuming this is a much
larger form for my suggestion.
Neil
- Original Message -
From: "Dave Hannum" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August
Oops. Left off a )
Should be
cfif not structKeyExists(session.cart, attributes.name)
blah
/cfif
- Original Message -
From: "David E. Crawford" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 24, 2000 12:56
Subject: Re: CFSCRIPT question
cfif not
Neil,
This was simply a BASIC, FUNDAMENTAL way to showing Jason the PRINCIPAL of
dynamically grabbing the values. It was not meant for a specific
application. Nobody was talking about efficient code - (but if you are, why
loop through a bunch of values that may or may not exist? The overhead
How do you figure, what I was saying is pass the values for the number
appended to the end of the variable.
Then loop through that list and reference the list element appended to the
end of "Reference_"
Neil
- Original Message -
From: "Dave Hannum" [EMAIL PROTECTED]
To: [EMAIL
Okay, another "best practice" question, I guess...
I have inherited an application from someone. In going through the code, I
notice that this person refers to several variables by using
"Variables.(whatever)". I'm assuming "Variables" is a reserverd term? I
can't find any documentation on
OK - but what if no value was passed for that form field? You have to
decipher what fields had input and what ones have no value.
Dave
- Original Message -
From: "Neil H." [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 24, 2000 9:26 AM
Subject: Re: picking up form
Could you show some code as an example of how to do this exactly?
Thank you.
/mdeane
-Original Message-
From: Neil H. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 24, 2000 8:59 AM
To: [EMAIL PROTECTED]
Subject: Re: picking up form variables on the action page??
This is another way
html
font size=3Here one I wrote in two parts. The first one does all the
calculations to give you all the info you need to display Prev page and
Next page buttons in any format you like: (note: I replaced the lt;gt;
with [] because my mail program always messes up display of any HTML-like
Here one I wrote in two parts. The first one does all the calculations to give you all
the info you need to display Prev page and Next page buttons in any format you like:
(note: I replaced the with [] because my mail program always messes up display of
any HTML-like tags.
!---
// Module
How are you handling that in your example?
Neil
- Original Message -
From: "Dave Hannum" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 24, 2000 9:46 AM
Subject: Re: picking up form variables on the action page??
OK - but what if no value was passed for that form
How would you then check for a particular value of a key within the same
cfif? In other words I am doing something similar where I am checking for
the existence of a key but then how do I filter so I get only those whose
value is, say, a specific date?
Thanks
-Original Message-
From:
They are being very specific so that there is never any ambiguity over which variable
they are talking about if there are more than one with the same name in different
scopes (ie variables.production and URL.production). Variables comes first in the
search order so it isn't THAT necessary...
Hello all.
Is there a way to find whether the session timed out.If
the session timed out display the logon page.
Some like
cfif Not isDefined(Session)
cflocation ../logon.cfm
/cfif
but i cant get this work.
Appretiate any comments.
thanks
Joe
-
Sent using MailStart.com (
Set a param in your application.cfm called Session.Loggedin for example with
a default of "no"
When a user logs in set this variable to yes.
Then in your application.cfm also have code that says:
cfif Session.Loggedin IS "No"
cflocation url="logon.cfm"
/cfif
-Original Message-
Thanks, Chris!
You could refer to it without the scope, though, right?
Ter
Original Message Follows
From: "Olive, Christopher M Mr NMR" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED]
Subject: RE: Referring to variables
Date: Thu, 24 Aug 2000
If it's a textbox, and there's no value, then the FORM.FieldName won't be
passed. (Unless I have initialized it with a CFPARAM).
Dave
=
"What we need is a list of specific unknown problems we will encounter"
David Hannum
Web Analyst/Programmer
Ohio University
Interesting, in CFTRANSACTION you have to reference the same DSN.
I wonder how Phil uses multiple DSN's between CFTRANSACTION Tags?
Interesting, I wonder why the documentation says;
Within one transaction block, you can write queries to more than one
database; however, you must commit or
cfscript
if (NOT StructKeyExists(SESSION.car, ATTRIBUTES.name)) {
do stuff here
}
else
{
do other stuff here
}
/cfscript
The "else" is actually optional. But I figured I'd throw it in as an
example.
Sharon
-Original Message-
From: Jon Tillman [EMAIL
I am trying to write a storedproc that does an insert and then returns a
value. The problem is this, I pass in about 15 variable as Type="IN" in
cfprocparam. Then I want one type="OUT" called UserID. Anyway what do I
have to write in the Stored Proc itself to allow that to happen.
Thanks,
You almost have it, but try to see if a
session variable exists.
Example:
cfif not isdefined("session.access")
cflocation url="../login.cfm"
/cfif
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 24, 2000 10:01 AM
To: [EMAIL
I have a cf page which I schedule to execute one time at 8:00pm. It does its
work and then uses CFSCHEDULE to re-schedule itself for 10 minutes in the
future. This works great until it gets to midnight. If the new time is past
00:00, the job never runs. When I check in the morning through the
that is correct. i usually do that, as the only variable i don't scope are
VARIABLES variables (:))
however, there are some purists that scope everthing.
i'm just lazy is all.
Chris Olive,
DOEHRS Website Administrator
-Original Message-
From: Terri Stocke [mailto:[EMAIL PROTECTED]]
Are you inserting data into a table which automatically creates an ID
(IDENTITY filed)? If so what you want to do is perform the INSERT statement
in your SP and then immediately afterwards interrogate the INSERTED table.
This is a table which SQL automatically creates with exactly the same
If we're still talking cfscript:
cfscript
if (StructKeyExists(SESSION.cart, ATTRIBUTES.name)) {
myValue = SESSION.cart[ATTRIBUTES.name];
}
else
{
myValue = "not Defined";
}
/cfscript
You can refer to structures either throught dot notation:
http://www.cfm-resources.com/members/comet/
That site is devoted to making COM and CF work nicely together. It's not
too detailed yet, but it has a public forum that I'm sure will get more
traffic as time goes by and more people run into COM issues with CF.
-Original Message-
From:
Thanks Andy,
I cant do that cause i an dynamically logging the
user.
Is there a ways you could say.
isDefined(Sessiontimeout)??
or
i have to calculate the time the user spends in the app and log
them off!
--- Original Message ---
Andy Ewings [EMAIL PROTECTED] Wrote on
Sure .. you could do it with something like this:
cflock scope="SESSION" timeout="30" type="READONLY"
cfif not isdefined('Session.LoggedIn')
cflocation url="../login.cfm"
/cfif
/cflock
Todd Ashworth
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
There is also the consideration that VARIABLES-scoped variables
do not need to be CFLOCKED...
best, paul
At 09:50 AM 8/24/00 -0400, you wrote:
They are being very specific so that there is never any ambiguity over
which variable they are talking about if there are more than one with the
same
If it's a textbox, and there's no value, then the
FORM.FieldName won't be
passed. (Unless I have initialized it with a CFPARAM).
I'm sure that's not true - aren't your mistaking it with checkboxes?
If a value or string is not entered into a checkbox then the fieldname is
still passed - its
Yup...this is what I do in mine..
!--- Clear client varaible if no activity in past 30 mins ---
cfif DateDiff("n", Client.LastVisit, Now()) GTE 30
cfquery Name="DelClientVars" datasource="DSN" MAXROWS=1
DELETE FROM CDATA WHERE CFID =
Right, but I think I am missing how to set the outputparam as output in the
Stored Procedure? What is the syntax to set it as an out param?
Thanks,
Neil
- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 24, 2000 10:22 AM
Subject:
I know there has been a lot of talk about this subject
lately, but none of the threads directly answered my question.
I know that I can determine a file's size AFTER it has been
uploaded, but I would like to prevent someone from uploading
a 100MB file, and then have to delete it after it has
Create your stored proc as follws..
CREATE PROCEDURE (procedure name AS
@inputparam1datatype
@inputparam2datatype
@inputparam3datatype
..
..
@outputparamdatatype OUT
BEGIN
INSERT INTO tablename (filedlist)
Has anyone had any experience with the interactive training CD that is
available from Allaire called "SkillBuilding with ColdFusion"?
I am about ready to order it, but want some feedback on the product before I
commit.
Tim Claremont
Xerox
Just a quickie.
I have taken to coding in this way (when I think var may be undefined):
cfparam name="var" default=""
cfif var eq ""
... do something ...
/cfif
instead of:
cfif IsDefined(var)
... do something ...
/cfif
Does anyone else have trouble with IsDefined() or is it
This is a multi-part message in MIME format.
--=_NextPart_000_0015_01C00DBB.414D3C00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I am having a problem with switch statement in a cfscript block. It is =
always executing the last case,
We were having a discussion on how to measure the performance of web servers
and was wondering if anybody had come up with a valid way to do this?
For example, you can determine how good a 3D graphics card is based on
number of polygons and refresh rates at different resolutions. So in theory
it
Figured it out (taken me months!)
I need to put quotes in, which seems a bit irish to me as all other
functions (those I can think of off the top of my head) you don't put the
quotes in when putting in a variable.
Sorry to bother you!
Paul
Thanks Dave.
JM
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: 24/08/00 10:52 AM
Subject: RE: Yet another filesize question
I know there has been a lot of talk about this subject
lately, but none of the threads directly answered my
Hello All,
I hope that you can give me hand with this annoying little problem that I am
having, I need to open up a new window containing some HTML forms using
JavaScript. I can get the script to work on a HTML page standalone, but
when I embed the script in a table on my cfm template the link
That first example that uses the cfheader is exactly what i
need to happen on my site, and it doesn't work at all. I
actually copied your code (modified the query of course) to
a tee and it still doesn't do anything. I get a blank page.
Your example works flawlessly - I just don't get it.
I have the same issue and am using the same workaround, I am on CF4.5 NT 4
sp 6a IIS 4
Kevin
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 24, 2000 10:57 AM
To: Cf-Talk
Subject: IsDefined() problems
Just a quickie.
I have taken to coding in
Nope I don't have a problem with it.
Make sure the var is in quotes: ISDefined("var")
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: 24 August 2000 15:57
To: Cf-Talk
Subject: IsDefined() problems
Just a quickie.
I have taken to coding in this way (when I
my advise would be to create one variable containg all the references you
need
generate a list
cfset thelist= ""
cfform
cfinput name="Reference_#ReferenceID#"
Submit
cfset thelist = thelist reference ","
/cfform
then use cfloop list="#thelist#" index="currentreference"
It
If no form variables are passed, then form.fieldnames will not be
defined. IsDefined('form.fieldnames') = False
If a checkbox exists in a form and is not checked when the form is
processed, then the checkbox variable will not be defined.
IsDefined('form.CheckboxVariableName') = False
As
Hey Anthony
I'm using this and it's working like a charm:
script language="JavaScript"
function showDocument(act,id) {
var link;
var accept = true;
if (act == 'E' || act == 'A')
link = 'edit.cfm?ID=' + id;
{
MyWin =
Hi again,
I tried Al Musella's idea of eliminating the extra and HEAD tags. Since
three files are involved in the whole process there are three sets ... then I
put the Application.cfm back in place got the same error.
Here is the only tag currently living in my Application.cfm file (I was
If I use this?
cfset todayDate = Now()
cfset ttoday = #DateFormat(todayDate, "m/dd/yy")#
Will months with 2 digits appear with 2 digits? IE 10/10/00?
thanks,
Pete
--
Archives:
I used it when I was FIRST starting CF development. It is REALLY basic. Even
as my first true CF exposure, it was REALLY REALLY simplistic. I don't
remember how much it cost, but if you have any background in CF already,
there isn't much point in it. However, if you have never even written a
In a message dated 08/24/2000 11:04:33 AM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
Has anyone had any experience with the interactive training CD that is
available from Allaire called "SkillBuilding with ColdFusion"?
I am about ready to order it, but want some feedback on the
Try...
CFAPPLICATION NAME="marksport"
SESSIONMANAGEMENT="Yes"
SETCLIENTCOOKIES="Yes"
SESSIONTIMEOUT="#CreateTimeSpan(52,0,0,0)#"
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 24 August 2000 16:21
To: [EMAIL
Which is a better perference, using a Join or Union?
I need to link together several tables so I can build an excel spreadsheet
Thanks for the direction.
Jim Ray
--
Archives:
You need a "break" command at the end of each case
- Original Message -
From: "FWA" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 24, 2000 9:05 AM
Subject: Switch Statement in CFSCRIPT
This is a multi-part message in MIME format.
If you're a beginner, Skillbuilding is a GREAT way to get started. I bought
it right off the bat, and went through it from beginning to end in three
nights after work. By the time I was finished, I knew ColdFusion was the
thing I was looking for to get me excited about leaving my job in Test
If it's a textbox, and there's no value, then the FORM.FieldName won't be
passed. (Unless I have initialized it with a CFPARAM).
Checkboxes and Radio Buttons are the only ones not passed if they are empty
(unclicked)
An empty text/textarea will pass a blank string
Then again, it's probably
SkillBuilding is a well put together training tool. However, if you have any
amount of CF development experience, you may not benefit from it as it is
quite basic. You may also choose to visit a local CFUG, which may have
copies to lend to members.
JM
-Original Message-
From:
Glad I'm not irish, I might have been offended...
JM
-Original Message-
From: Paul Johnston
To: Cf-Talk
Sent: 24/08/00 11:01 AM
Subject: RE: IsDefined() Problem
Figured it out (taken me months!)
I need to put quotes in, which seems a bit irish to me as all other
functions (those I
I have used the SkillBuilding CD. It's very basic and good for an
introduction to the basic uses of SQL and CF in a web page. If you already
have experience in DBs and HTML I'd suggest just doing a couple practice
projects with searches and simple logic etc., which is basically what the CD
Which is a better perference, using a Join or Union?
Jim
A Join links tables horizontally and a Union links them vertically, if you
see what I mean.
You can only Join tables if they have a column in common ("foreign key").
You can only Union tables if they have identical columns.
Nick
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
They're used for different things. If you have a bunch of table with
the exact same fields in them that you need to lump together, do a
UNION. If you have different fields in the tables need to get
parts of various tables all put together (most
Are you remembering to enclose the variable in quotations marks?
cfif IsDefined("var")
...
/cfif
Marianne
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 24, 2000 10:57 AM
To: Cf-Talk
Subject: IsDefined() problems
Just a quickie.
I
http://207.208.210.117/beta/transcriptioncenter/test2.cfm
here is the code
CFHEADER NAME="Content-Disposition" value="inline;
filename=D:\Attachments\ACF116.doc"
CFCONTENT TYPE="application/unknown"this is a test
I don't know what the significance of using that cfcontent is, but I threw
it in
I'd use join and make sure you use the correct type of join(INNER, LEFT
OUTER, RIGHT OUTER)
-Original Message-
From: Ray, James A [mailto:[EMAIL PROTECTED]]
Sent: 24 August 2000 16:33
To: [EMAIL PROTECTED]
Subject: Join vs Union Perference
Which is a better perference, using a Join
1 - 100 of 228 matches
Mail list logo