Now it seem that the functionality of the two queries is close enough
that you could do something like this (option #1):
SELECT id, name
FROM my_table
WHERE col =
ORDER BY name, id
If that works for your situation, that's what I'd do, I think. Unless
the name field is friggin' huge (which I
I would think because sometimes you would need to pass in not only the field
names to select but also some criteria as to how it is grabbed. Such as
something that needs to go into the FROM or WHERE portions of the query. For
the example Russ gave you would need to pass in the name of the
column(c
Why not just pass the fields you want to return data as an argument.
>I like the 1st way, as it allows you to have 1 query that returns different
>things based on the arguments (which are set to optional).
>
>If you really don't want to return more data then needed, you can do this
>
>
>
>
>
>
I like the 1st way, as it allows you to have 1 query that returns different
things based on the arguments (which are set to optional).
If you really don't want to return more data then needed, you can do this
SELECT centerId , center
FROM Repaircenters
W
Humm...3 clicks to get from Home page to someplace where I can see what they
are marketing. Pages very slow on a DSL line. Clickling on an item opens
up additional window, which I HATE. AND THEY HAVE THE UNMITIGATED GALL TO
CHARGE ME, SVELTE MOI, AN EXTRA $15 BUCKS FOR HAVING A 35 INCH WAIST ON
I did something similar to the 1st then with the exception of I did not do a
check to see if the argument existed. I had two arguments one being "ID"
and the other "LEVEL" Both required but with a default set to the "LEVEL"
So I would then do a check to see if Arguments.LEVEL NEQ "whatever the
de
Mmm, the design, ye...
On 12/19/05, Jennifer Gavin-Wear <[EMAIL PROTECTED]> wrote:
> I expect people go back time after time to drool over the amazing design? ;)
>
>
> -Original Message-
> From: dave [mailto:[EMAIL PROTECTED]
> Sent: 17 December 2005 09:01
> To: CF-Talk
> Subje
That'll be the problem Dave. It's a while back now but I'm pretty sure I
used windows authentication, not mixed-mode. Can you change that setting
without having to reinstall SQLServer?
Cheers
Mike Kear
Windsor, NSW, Australia
Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebwork
Using the third style, the first SQL is looking for a single piece of data
(an int) while the second SQL is looking for 2 (and int and a varchar). The
first is also using a param where the second doesn't have one. I just don't
like returning more data than is needed.
Select centerid
from
Just recently I did the first option and it was more from the stand point of
I did not see any value to having a separate function for each need like
this. Seems like there is not a huge difference between the 1st and 3rd,
both use a CFIF to decide how the output of the function is going to be.
On
This is more of a style question than anything else. Lets say you have a CFC
that will be doing all the work for an application. There is need for two
different queries. The first gets an ID based on a passed value. The second
uses the same table but returns the id as well as a name and does not
I expect people go back time after time to drool over the amazing design? ;)
-Original Message-
From: dave [mailto:[EMAIL PROTECTED]
Sent: 17 December 2005 09:01
To: CF-Talk
Subject: another new big cf site :)
this chic forbidden from myspace (like most famous person on myspace)
launche
it sounds like an install bug i had a long way back .. are you on mx 6.1?
I ended up re-installing a few time and applying the patches and it finally
went away.
Also, I could be way out, but are your site directories nested as I think
this could cause that prob?
Jenny
-Original Message
I just informed dave the disruptured of this situation. He should be arriving
soon!
:)
Will
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on
Ade .. don't answer that :P lol
-Original Message-
From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED]
Sent: 18 December 2005 17:37
To: CF-Talk
Subject: RE: XML Problem
Oh duh .. why didn't i spot that ..
Thanks Chris :-)
-Original Message-
From: Chris Gottshall [mailto:[EMAIL
Oh duh .. why didn't i spot that ..
Thanks Chris :-)
-Original Message-
From: Chris Gottshall [mailto:[EMAIL PROTECTED]
Sent: 18 December 2005 16:24
To: CF-Talk
Subject: Re: XML Problem
Jennifer,
You should try printing the XmlText of the node.
Ex: xmlcontent.shop.stock.item[i].stockco
> I have to pull some data from a foxpro DB on a local network
> server and then import it into a sql server db for CF access.
> has anyone had experience with something like this and could
> give a pointer on what a good approach would be - mainly
> interested in what a good mechanism for gett
> No, becuase when I set up SQLServer, and installed CFMX7
> something went wrong and i can't connect to it using CF's
> native drivers. Instead i have to set up a ODBC datasource
> and connect to that.
Can you provide more detail about the something which went wrong? I think
you'd be much bett
Jennifer,
You should try printing the XmlText of the node.
Ex: xmlcontent.shop.stock.item[i].stockcode.XmlText
Stopping at .stockcode returns a reference to the XmlNode, hence the error.
But the .stockcode.XmlText contains the value you are looking for.
-Chris
>Hi, I'm learning xml to use i
Hi Ade,
Have tried this and no luck:
URLToPull = "#application.siteurl#stock/stock.xml";
XMLContent = trim(cfhttp.filecontent);
XMLContent = XMLParse(XMLContent);
#tostring(xmlcontent.shop.shopname)#
I'm really confused because I can read an rss feed with no problems using:
#X
Look at using ToString().
Ade
-Original Message-
From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED]
Sent: 18 December 2005 15:00
To: CF-Talk
Subject: XML Problem
Hi, I'm learning xml to use it within a cart application and have come
unstuck.
The xml file I've created looks fine. I ca
Hi, I'm learning xml to use it within a cart application and have come
unstuck.
The xml file I've created looks fine. I can read it and get a count of
stock items.
But all of the contents I return look like
[EMAIL PROTECTED]
Can anyone see where I'm going wrong please?
Thanks, Jenny
URLToPul
22 matches
Mail list logo