This is one I used awhile back and gives you information on what the columns
are as well.
SELECT TNAME, CNAME, COLTYPE, WIDTH, NULLS, DEFAULTVAL, SCALE FROM COL ORDER
BY TNAME
On 7/31/06, Deanna Schneider <[EMAIL PROTECTED]> wrote:
>
> Um, why not use the data dictionary to get the columns as we
This is just a guess but try changing this:
#type#
To
#type#
On 7/28/06, Steve LaBadie <[EMAIL PROTECTED]> wrote:
>
> Yes, the entire form is visible including the drop-down box, its just
> empty of choices.
>
> Steve LaBadie, Web Manager
> East Stroudsburg University
> 200 Prospect St.
> East
Yes, I know what you were showing and it makes perfect sense for that
example. I was just trying to show other ways to avoid the function that
might be the best option for different scenarios.
On 7/25/06, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
>
> > That way will work 99% of the time, there i
n it to the sender or
> call
> our switchboard on +44 (0) 20 89107910. The opinions expressed within
> this
> communication are not necessarily those expressed by Reed Exhibitions."
> Visit our website at http://www.reedexpo.com
>
> -Original Message-
> From: Aaron Ro
That way will work 99% of the time, there is almost always a way to avoid
using Evaluate() and SetVariable(). You can also do things like
#Form["blah_#i#"]# only point that out since the prior
example might imply you would have to first do something like and then #Form[foo]#
On 7/25/06, Robertso
Any examples of where you could not see a way around it?
That is a neat trick with the ArraySum although I'd guess the number would
be all out of whack if you are doing grouped(CF not SQL) output.
On 7/25/06, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]>
wrote:
>
> Examples? Sometimes I hate us
idn't
> know before than it was well worth it.
>
> ...
> Ben Nadel
> www.bennadel.com
>
> -----Original Message-
> From: Aaron Rouse [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 20, 2006 11:38 AM
> To: CF-Talk
> Subject: Re: ColdFusio
eed up my learning
> curve, and maybe most importantly lessen mistakes and dev time by knowing
> what's available. I've already found a few tags that I somehow missed in
> the book that would have saved me a few days of work.
>
> Thanks for the responses! I'm eating t
We had programmers in our group who have been doing programming for
decades and specifically CF for at least a couple of years. They
found the classes helpful when taking but as I pointed out in another
email they just do not seem to really use any of what they learned in
the class. The WACK prob
It all depends on your level. I sat through the two CFM training
courses a year or so ago. It seemed like he was teaching helpful
information for the rest of the group in the class although I do not
see them to this day actually using any of that knowledge. Not sure
if it is because they did not
I think it can be really dependent on how your CFCs are coded and used
as to what the pros and cons are. I have used CFCUnit on some
projects that the huge pro was that it saved an enormous amount of
time then on other projects it would have taken more time to use it
over just putting the CFCs to
We used Siteminder many years ago in order to support PKI cards for sign
on. Seemed like a great idea at the time, then people no longer had to log
onto multiple sites, it just picked up your PKI card and you were in.
Actually seen provisions for PKI logins within our CFM framework but never
tried
by Hartsfield
> http://acoderslife.com
>
>
>
>
>
>
> -Original Message-
> From: Aaron Rouse [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 11, 2006 4:32 PM
> To: CF-Talk
> Subject: Custom Tag for DTHML/JS Menu
>
> Shot in the dark but can anyone point me to a
downloaded and did not make in house but they are failing to tell me or give
me the files.
--
Aaron Rouse
http://www.happyhacker.com/
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion
We looked into BD.NET to be able to maintain a beloved CFM app while the
higher ups were pushing to "no CF servers" and only .NET ones. If we did it
though, we would eventually end up just migrating things to .NET over time.
On 7/10/06, Munson, Jacob <[EMAIL PROTECTED]> wrote:
>
> > I understand
What is a good AS 3.0 book for a beginner?
On 7/6/06, Casey Dougall <[EMAIL PROTECTED]> wrote:
>
> Get out your actionscript 3.0 books boys and girls, there are some
> "wizzards" but you'll still need to have some flash skills to make
> anything
> really cool.
>
> --
> Casey Dougall
> Web Applicat
Do what I did in my example code I sent you which was a check for smaller
and then a check for the next one.
On 6/29/06, Howard Owens <[EMAIL PROTECTED]> wrote:
>
> -Original Message-
> From: Josh Nathanson [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 29, 2006 2:03 PM
> To: CF-Talk
> S
$750 if you want it with the charting or can upgrade to that later for $300
On 6/28/06, Andy Matthews <[EMAIL PROTECTED]> wrote:
>
> $499 for Flex Builder 2.
>
> andy matthews
> web developer
> certified advanced coldfusion programmer
> ICGLink, Inc.
> [EMAIL PROTECTED]
> 615.370.1530 x737
>
When we have ran into this on upgrades what we ended up doing was prefixing
the columns being outputted with the query name. Something like #Blah.URL#
On 6/27/06, Bill Woodland <[EMAIL PROTECTED]> wrote:
>
>
> Yep, that would work for select, but any updates/inserts would probably be
> a real pai
Yeah, I just figured the example given was a working(breaking) example to
show the problem.
On 6/27/06, Russ <[EMAIL PROTECTED]> wrote:
>
> As I've said, is it possible that his query is returning a column named
> URL.
> And since he's inside a cfoutput block, cf looks to the query first when
> de
True, which he does in some of his tests but code migrating from CF 4.5 more
than likely would not be doing that on the URL scope :) Regardless his
sample code works for me in two different versions of MX and only change I
did was the query I changed the datasource name and made a temp table to
re
Should this sample code be returning an error? The reason I ask is it runs
just fine for me both on 6.1 and 7. To answer the question in the subject
yes URL is a structure and typically the cause of an error like you are
describing is something like #URL# since that was
allowed in 4.5 but in 6.1
The titles are outputed unique though? I'd thought with the way that is
written you would get 10 records with the same title, rank, and asin
displayed but I am going on next to no sleep today.
Try replacing:
AddBook = ArrayAppend(BookList,Book);
With
BookList[i] = Duplicate(Book);
On 6/27/
What is the actual value of the variable you are plugging into the
cfqueryparam? As I stated the other day I do not think the value needs any
quotes at all in it when using a cfqueryparam with the list attribute. Also
as others have stated you do not need to worry about preserving single
quotes w
That is because when in a cfquery it gets escaped out, so double quotes and
why you would need to use PreseveSingleQuotes() around it. Maybe my mind is
failing me but I do not think you need to worry about any of these functions
and just do at least I'd swear that is how I have done it with Orac
I found the tabbed interface in CFFORM good for making mock ups but for what
I ended up needing it just wasn't best suited for the purpose and ended up
going the DHTML route.
On 6/23/06, Andy Matthews <[EMAIL PROTECTED]> wrote:
>
> Here we go. How to create a tabbed interface using the Flash CFFOR
It is just a matter of setting up a dblink in Oracle or if it is just
schemas in the same database then it can be as simple as just user
permissions. I seem to recall reading once a way to select data out of
another type of database from within MySQL but I might be remembering
something completely
But if you setup a filter you could have it move all cf-talk email to its
own folder in your client. Then you know all unread email in that folder is
hopefully not spam since it should only be from the list. This is what I
did when I still used Outlook or Eudora on the list and essentially what I
I am running it on a machine with I believe 2GB of RAM but maybe less than
that, I know it has a single 2ghz CPU in it. Have not noticed any
performance issues on it.
On 5/17/06, Tim Claremont <[EMAIL PROTECTED]> wrote:
>
> The machine in question is a dual 3 GHz with 3 GB of RAM. I am not happy
Out of curiosity if you do not know what it does or why someone would use it
then why ask on it? :)
I have only seen one project here that used it and they used it as part of
their security role checking/setting. They would do something like:
On 5/10/06, Wurst, Keith D. <[EMAIL PROTECTED]> w
I work in a rather big cube farm and the "hall" next to mine is full of a
bunch of diehard linux people. The company is switching to windows for
their software package due to numerous requests from the clients. That
switch is causing a lot of those guys to look for new jobs because they are
just
And why could you not run MSSQL Express on the remote server and connect to
it with CF?
On 5/9/06, joe velez <[EMAIL PROTECTED]> wrote:
>
> HAHA - Naturally moving the db would be the fastest/easiest, but in this
> case it's not a realistic solution.
>
> The db needs to be hosted remotely, and CF
I think that has a lot to do for when each database was introduced to the
market. Oracle's SQL Developer is not a bad little tool though.
On 5/9/06, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
>
>
> Yep...Oracle is highly overrated in my booksuse it all the time for
> govt
> workwould far
Admitedly it has been awhile since I have installed a Linux box, I switched
to FBSD years ago and stuck with that choice. Even with FBSD though and I
am sure it is true with most xNIX distributions is it boils down to what the
sysadmin decides to install and a lot of times someone who does not inv
When I started with web stuff we ran linux for our mail server and NT for
our CF server and this was back in 1996 or so. We stayed with Linux for
many years and eventually went to FBSD which still have one FBSD box up and
running for email/dns needs. Learned the hard way how to secure linux
boxes
What I have seen happen a lot is people switch to Linux because they hate
windows. Everything is up and running fine for them but they do not invest
the proper time to learn how to maintain the box to keep aware of security
patches. Now you have an OS with multiple services from multiple open
sou
No, cf-community is for people to piss and moan about governments from best
I can tell.
On 5/6/06, Snake <[EMAIL PROTECTED]> wrote:
>
> Isn't there a separate HOF list for people who just want to argue, troll,
> flame etc? cf-community isn't it?
> I also run one of these at [EMAIL PROTECTED]
>
> S
I'd learn something other than CF, knowing 4.5.2 well enough to me would be
good enough knowledge to pick up a later version of CFM but it helps none or
very little to learn some other language. The more tools in your box, the
better off you are.
On 5/5/06, Rick Faircloth <[EMAIL PROTECTED]> wrot
There were a few custom tags for this that worked in CF4 and above. We use
a in house built "framework" at one of the places I work and it was built on
CF4. We use it on CF4 to CF6.1 boxes and honestly it does most everything
any of our clients need done there. So I could see how someone could s
That would be the way I would do it. Here we end up having to set up
dblinks so usually make views just to shorten the syntax of the queries.
On 5/3/06, Martin Thorpe <[EMAIL PROTECTED]> wrote:
>
> Hello.
>
>
>
> I have adopted 2 systems both with their own databases with similar
> data. I have
pective...
>
> And, too, since I gather that Flex 2 can be used in conjunction
> with other languages like ASP, etc., if I use CF with it, I still
> have to keep paying the *full* price now and upgrade prices
> in the future...
>
> Rick
>
> -Original Message-
> From: Aaro
If I was in your shoes I would be learning something like Flex 2 and then
figuring out what language you want to use to serve data to/from it could be
CFM or whatever you pick.
On 5/2/06, Rick Faircloth <[EMAIL PROTECTED]> wrote:
>
> >Well then, if you're not using new functionality, why move to a
ith development.
>
>
> -Original Message-
> From: Aaron Rouse [mailto:[EMAIL PROTECTED]
> Sent: 02 May 2006 17:46
> To: CF-Talk
> Subject: Re: ASP.Net book for CF programmer
>
> I thought the licensing for the action pack did not allow people to run
> the
> software beyond e
I thought the licensing for the action pack did not allow people to run the
software beyond evaluation/demo use.
On 5/2/06, Snake <[EMAIL PROTECTED]> wrote:
>
> An SPLA make sMicrosoft products more affordable.
> And for local office/dev environment, the microsoft action pack is
> unbeatable. All
Just use google to find out who :)
On 5/2/06, Jochem van Dieten <[EMAIL PROTECTED]> wrote:
>
>
>
> That is kind of hard if you don't tell who they are...
>
> Jochem
>
>
>
>
>
~|
Message: http://www.houseoffusion.com/lists.cfm/l
MS is not free, but if you are in an environment that is going to use MS
servers then wouldn't ASP be already paid for? Or is the licensing
different for the server when used to host an intranet or internet facing
application?
On 5/1/06, Denny Valliant <[EMAIL PROTECTED]> wrote:
>
> MS isn't free
You need to do the CFOUTPUTs within the SCRIPT tags and inside those
CFOUTPUTs would be the JavaScript array creation/population. I do it a
little differently than he does it in his online examples but will email you
offlist and example set of code that you can run and see how to build things
off
; *no* discount whatsoever is certainly one way to encourage
> me to become an asp.net convert...everything's free as far
> as I know in aspland...coding is *certainly* more difficult,
> but, again, is it worth $1300 to learn?
>
> Thoughts?
>
> Rick
>
> -Original M
The original poster was asking for a good book that someone could
recommend. Since none probably exists specifically for a CF developer going
to ASP I'd imagine this list would be a great place to ask "hey I need to
learn ASP .NET and only know CFM, what resources(preferably books) have
people fou
some
code snippets so I can just search for it with gmail.
On 4/28/06, Denny Valliant <[EMAIL PROTECTED]> wrote:
>
> On 4/28/06, Aaron Rouse <[EMAIL PROTECTED]> wrote:
> >
> > Google is a great source, hell it can answer most of the questions asked
> > on
> >
Google is a great source, hell it can answer most of the questions asked on
CF-Talk and a lot of those answers end up being in places like livedocs. So
the standard reply could be go google it or RTFM. :)
On 4/28/06, Denny Valliant <[EMAIL PROTECTED]> wrote:
>
> On 4/28/06, Russ Michaels <[EMAIL
I must have had a modified version of the tag then.
Here is a link to CFAJAX, I personally did not like doing related select
tags with this because it ended up being slower than the method I had been
using.
http://www.indiankey.com/cfajax/
Here is a linkto AjaxCFC:
http://www.robgonda.com/blog/
I did this years ago with his two selects related tag and from I recall it
involved no modification to the tag. Might want to check around and see if
you have the latest version of the three selects tag or it might just boil
down to how you are calling it. Only reason I mention latest version is
pable of using google as I am.
>
> -Original Message-
> From: "Aaron Rouse" <[EMAIL PROTECTED]>
> To: CF-Talk
> Date: Thu, 27 Apr 2006 09:18:37 -0500
> Subject: Re: ASP.Net book for CF programmer
>
> > There are a lot of things online, some are helpful and
ts as
well.
On 4/27/06, Russ Michaels <[EMAIL PROTECTED]> wrote:
>
> well there are such things as that online that gives you equivilent code
> in different languages.
>
> -Original Message-
> From: "Aaron Rouse" <[EMAIL PROTECTED]>
> To: CF-Talk
&
Even being a totally different language I could see how questions might come
up along the lines of to do this in CFM you go this route but to do it in
language XYZ you need to take this route.
On 4/26/06, Russ Michaels <[EMAIL PROTECTED]> wrote:
>
> I really don't think there could be such a think
If someone ends up outgrowing Express and needing to go to the "full blown"
version of MSSQL 2005 what do they end up needing to do to move a database
from one to the other? Is it as simple as just backing up the files in
Express and restoring them onto the new server?
On 4/26/06, Robert Everland
Interesting, I do not use SQL Server a whole lot but out of the times I have
the DTS was always a bit selling point to me.
On 4/26/06, Robert Everland III <[EMAIL PROTECTED]> wrote:
>
> Actually DTS is still in there, they say that it's limited, but with what
> we're doing with DTS I haven't had a
Is DTS no longer in MSSQL 2005?
On 4/25/06, Dave Watts <[EMAIL PROTECTED]> wrote:
>
> > There are no issues that I know of between coldfusion and
> > SQLServer2005, although i certainly have great difficulty
> > deploying databases without DTS. I have been asking
> > everywhere i can find and no
Well I was not fearful enough to go back and change anything since after all
I have not experienced such slownesses :)
On 4/25/06, Munson, Jacob <[EMAIL PROTECTED]> wrote:
>
> > I do not use QoQ's much at all and threads like this make me
> > fearful of those times I did use it.
>
> I use QoQ for
, Shawn McKee <[EMAIL PROTECTED]> wrote:
>
> Integers, strings, etc. A single value for a given function.
>
> -Original Message-----
> From: Aaron Rouse [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 25, 2006 11:33 AM
> To: CF-Talk
> Subject: Re: Stored procedur
to a CFQUERY then it no longer chokes,
> it
> >is my understanding the query still takes a long time to run this way or
> >just through SQLPlus. It has been tried using ODBC and native connection
> >data sources and with connection pooling enabled. Is this typic
What do the functions return?
On 4/25/06, Shawn McKee <[EMAIL PROTECTED]> wrote:
>
> I have used lots of Oracle stored procedures using but my
> DBA
> has now written several functions that I need to use. I have never had
> any
> luck accessing these via and was wondering if it was a) not
> pos
I have been running MSSQL 2005 Express and CF7 for awhile now. I did
download the JDBC driver from MinkySoft but I think for a few days I ran it
using the older MSSQL driver.
On 4/25/06, Mark Drew <[EMAIL PROTECTED]> wrote:
>
> I presume it is if you get the right JDBC drivers from MinkySoft
>
>
Or make a query of the UUIDs and then do a join onto that within the QoQ. I
do not use QoQ's much at all and threads like this make me fearful of those
times I did use it.
On 4/25/06, Hugo Ahlenius <[EMAIL PROTECTED]> wrote:
>
> Or how
> about replacing the in statement with repeated UUID = "X" O
al for all
resrouces to just get consumed for SPs and not for cfqueries or is there
maybe something I could pass onto them to check?
--
Aaron Rouse
http://www.happyhacker.com/
~|
Message: http://www.houseoffusion.com/lists.cfm/link=
y use that
name.
On 4/21/06, Denny Valliant <[EMAIL PROTECTED]> wrote:
>
> On 4/19/06, Aaron Rouse <[EMAIL PROTECTED]> wrote:
> >
> > What do you do if you have UserID used in a table twice? Such as maybe
> if
> > you had the need to track the user who did the
Isn't there a way to password lock a PDF file where it can still be viewed
but not exported into something else? No matter what though there will
always be a way around anything done just depends on how motivated someone
is.
On 4/20/06, Adkins, Randy <[EMAIL PROTECTED]> wrote:
>
>
>
> But to answ
I think that bites more people than not in regards to optimization.
On 4/20/06, Claude Schneegans <[EMAIL PROTECTED]> wrote:
>
>
> There are many other places to look for optimization, the first being
> queries and correct indexes in the database.
>
>
~~~
What do you do if you have UserID used in a table twice? Such as maybe if
you had the need to track the user who did the original record creation and
who the last user to update the record was?
I tend to prefix these "link tables" with LKP_ and I got into the habbit
because they were tend to be
This does the same thing as his:
My guess is he was saying for the value of "variable" to not be put into foo
until the time that it was outputed instead of when set.
On 4/18/06, Bruce, Rodney S C-E LCMC HQISEC/Signal Solutions <
[EMAIL PROTECTED]> wrote:
>
> Unless I missed something, there
This is exactly why I unsubscribed from cf-community a LONG time ago.
On 4/12/06, Dave Watts <[EMAIL PROTECTED]> wrote:
>
> > Maybe I'm writing a career suicide note, but somehow I doubt
> > that.
>
> No, just a giant, useless irrelevancy. My interest in the political
> opinions
> of developers is
They do it to piss you off :)
On 4/6/06, S. Isaac Dealey <[EMAIL PROTECTED]> wrote:
>
> Why is cfform still so screwed?
>
> I generally avoid it, but I'm working on one for this small project
> because I'm already losing money on the project. It was originally set
> up with a cfgrid and the proble
erf ... in Oracle not in order
On 4/5/06, Aaron Rouse <[EMAIL PROTECTED]> wrote:
>
> In order I defined a TYPE and then wrote a function to work with that. It
> allows me to treat conditions like this as if they were in a lookup table.
> I do not know MSSQL well enough to kno
In order I defined a TYPE and then wrote a function to work with that. It
allows me to treat conditions like this as if they were in a lookup table.
I do not know MSSQL well enough to know how to write the same thing in it,
but might be an idea to consider doing.
On 4/5/06, Mike Klostermeyer <[EM
And if it throws an error it means you are on way too old of a version :)
On 4/5/06, Mike Kear <[EMAIL PROTECTED]> wrote:
>
> You can run a file containing a dump of the server struct, if you have
> permission:
>
>
>
> One of the variables is the CF Server version. Also you can check the
> serve
I believe he was wrong, unless I am just misunderstanding "multiple
queries" because I do multiple ones all the time just not with a CFQUERY
and due to the JDBC drivers from what I can tell.
On 4/4/06, Munson, Jacob <[EMAIL PROTECTED]> wrote:
>
>
> I was told by someone that develops on Oracle th
Dave, I rather assumed that would be the case, just unsure
> about how to go about finding the info (or searching for documentation
> about how to find it), but Aaron Rouse gave me the hint I was looking
> for.
>
>
> s. isaac dealey 434.293.6201
> new epoch : isn'
Wait a second, who doesn't hate more than 80% of their customers? :)
On 3/29/06, Claude Schneegans
>
> but you'll also have to hate
> more than 80% of your customers,
> and as a developer, it is not an ideal situation.
>
~|
Me
"Not now I'm multitasking"
>
> -Original Message-
> From: Aaron Rouse [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 23, 2006 9:14 AM
> To: CF-Talk
> Subject: Re: Can I use the same instance of an object for all sessions?
>
> Something like
>
> Applica
Something like
Application.cfm
Application.DAO = CreateObject("Component", "some.DAO");
SomePage.cfm
set App.DAO = Application.DAO;
App.DAO.Read(Session.SomeID);
Actually the copy into another scope happens at the bottom of the
application.cfm since it is ran for every page. The copy also is wi
I do this but with one exception, I copy it from the application scope to a
local scope then do the inserts, updates, etc. I think if you left it in
the application scope then you probably would need to do a cflock and that
would seem to lead to contribute to issues when a query might take awhile
t;
> Mark Fuqua
>
> -Original Message-
> From: Aaron Rouse [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 20, 2006 10:51 AM
> To: CF-Talk
> Subject: Re: threerelatedselects - do you can help?
>
>
> I tried replacing one of my n-selects related done with qForms,
I tried replacing one of my n-selects related done with qForms, with the
CFAJAX route and found it to be slower with the AJAX solution. I was not
pulling out 1900 records, it was a large chunk though since it was for our
entire organization hierarchy.
On 3/18/06, Adrian Lynch <[EMAIL PROTECTED]>
Yes, I thought I said that more or less just with less words/description in
at least one of my emails in this thread.
On 3/18/06, Claude Schneegans <[EMAIL PROTECTED]> wrote:
>
> >>My experience is that a
> lot of the developers at work have no idea on how to deal with cross
> tables
> or even wha
I agree completely, it is late and I probably am just doing a bad job of
making a similar point.
On 3/17/06, Charlie Griefer <[EMAIL PROTECTED]> wrote:
>
> On 3/17/06, Claude Schneegans <[EMAIL PROTECTED]> wrote:
> > >>Such as wanting to see all users who have full rights to modify that
> > prope
Yes and as I tried to point out in my other email. My experience is that a
lot of the developers at work have no idea on how to deal with cross tables
or even what one is. They end up defaulting to doing this list in a
database column and then reverting to CFM to make a search possible. I end
up
Google 'oracle merge'
Here is one result, I just glanced at it but I think it gives the idea.
http://www.dba-oracle.com/oracle_tips_rittman_merge.htm
Sorry, but I have not had to work with Access with CFM for years now and
this whole time have been referring to Oracle and probably should have sa
I can think of times needing to know all users who have permissions to do
XYZ. Such as wanting to see all users who have full rights to modify that
properties table. I used Properties and Product Segments because that is
what the page I have opened right now is doing.
I can also think of times co
Unfortunately I do not have access to the code to look at right now. I know
it actually does a MERGE and not the query I typed up earlier. My guess is
I actually just wipe out what is in there and then repopulate, that is
something I wrote and used well over a year ago so I honestly do not
recall
Because I can search on a specific value in the list. An example might be
if I had a Property record and related to it are zero to many product
segments. If I want to find all properties that have ABC product segment
and I stored my product segments as a comma seperated list in my table then
I wo
I have an SP that I use for dealing with inserts of lists. It essentially
would do something like this:
INSERT INTO LKP_CATS
(PID, CATID)
SELECT #PID# PID, CATID
FROM CATEGORIES
WHERE CATID IN (#MyCatList#)
On 3/17/06, Rick Root <[EMAIL PROTECTED]> wrote:
>
> Aaron Rouse wr
For updating them it seems like a simple merge query would work fine enough,
update if exists or it inserts if not. I have a series of custom functions
I use in the database that help me deal with the need to do things like
return a list of user permissions from a cross table. So in this case my
Yeap, I'd highly recommend against an approach like this. People at my work
do this a lot and then struggle with how to search on it since you can not
write a simple query to find all "lists" that contain "foo" I am sure there
are many other reasons not to, that is just the first one that comes t
cache the results for 24
> hours?
> It wouldn't take any shorter time, but to the user it would be much
> better.
>
> Mark
>
> -Original Message-
> From: Aaron Rouse [mailto:[EMAIL PROTECTED]
> Sent: Friday, March 17, 2006 10:08 AM
> To: CF-Talk
> Subj
If you were taking the route of a cached query then yes/no that you are
wrong. If the count() is going to change based upon the where clause then
you would have to have a single master cached query that pulled out
everything possibly needed so that you could then do QoQ on that for the
dynamic whe
The only problem with this is the query can change due to the dynamic
building of the where clause. Could do a cached query that selects
everything that could be in the where clause then do QoQ on that for dynamic
where clause needs. I'd just be a little fearful of how much would need to
be selec
I got this and since it was my test box I just uninstalled it then
redownloaded the developer version, installed that, then re-installed the
connector. I can now access the CFadmin, no idea if the connector is
working right since not had time to write something to test it.
On 3/16/06, j s <[EMAIL
Didn't Oracle release some sort of Visual Studio plugin awhile back or have
I been hitting the old crack pipe too much lately? Keep thinking it had
something to do with Oracle XE
On 3/14/06, Munson, Jacob <[EMAIL PROTECTED]> wrote:
>
> > There is no way this tool looks anything like SQL Server's
I use quite a bit of the features in my version here which is not the full
blown one that has the DBA stuff. Admitedly I probably do not even use a
1/3rd of all the features the tool has though. I find it extrememely
helpful to use for things like writing custom functions and stored
procedures.
401 - 500 of 1059 matches
Mail list logo