it did work on 1 of the 4 and the only thing different i did was add space
between, I will go try others again
Thanks :)
From: Scott Barnes <[EMAIL PROTECTED]>
Sent: Tuesday, April 05, 2005 2:37 AM
To: CF-Talk
Subject: Re: cfc error
SELECT * FROM pat
SELECT * FROM patterns ORDER BY parentID DESC
Heh, hi Taco btw.
umm, be careful and remember that if you use instead of
then that DSN is now a global variable FOR That
cfc...
ie try the above and do a dump on the actual CFC afterwards :) just an FYI.
On Apr 5, 2005 2:47 P
SELECT * FROM patterns ORDER BY parentID DESC
--
Taco Fleur
Senior Web Systems Engineer
http://www.webassociates.com
-Original Message-
From: dave [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 5 April 2005 2:47 PM
To: CF-Talk
Subject: Re: cfc err
If you use var in front of any of your variables then they need to be right
after your arguments, i.e.
--
Taco Fleur
Senior Web Systems Engineer
http://www.webassociates.com
-Original Message-
From: dave [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 5 April 2005 2:40 PM
To: CF-Talk
Su
here it is
SELECT * FROM patterns ORDER BY parentID DESC
From: Jon Austin <[EMAIL PROTECTED]>
Sent: Tuesday, April 05, 2005 12:43 AM
To: CF-Talk
Subject: Re: cfc error
Are all of your statements grouped under your ?
Are all of your statements grouped under your ?
//got nuthin
On Apr 5, 2005 2:40 PM, dave <[EMAIL PROTECTED]> wrote:
> anyone know what this error means?
>
>Local variable qLF on line 18 must be grouped at the top of the function
> body.
~~~
anyone know what this error means?
Local variable qLF on line 18 must be grouped at the top of the function
body.
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.house
G'day Scott
We are looking to use XML to generate Excel and Word files using CF. Your
example is great - thanks! Do you know of any other resources that would
assist us with doing this sort of thing? Have you run into any limitations or
problems?
We have an app that uses COM generate Excel
But Mike...
It DID install for me! Really...
Nary a bug in site (except for having to recompile the Apache connector on
SuSE, but there were instructions for that).
Maybe it's a polar thing... since I'm that close to the North Pole and
you're that close to the South Pole, it could be that. Or
And all those people said it was MY fault. They implied I was
deficient in not being able to make it run. '... I've installed it
dozens of times and it worked ok for me ... " they said, the implied
criticism being that I must be somehow stupid or have pennypinched on
my hardware if i couldn't in
All,
I agree that RTF (or, possibly PDF, but that presents its own
challenges) is probably the way to go.
Rick, you're going to want to take your query, or whatever format your
source data is in and just loop over it (this could produce several
nested loops - don't be afraid to just do it) to pro
Yeppers...
http://www.macromedia.com/support/forums/
One account will get you access to all forums, the downloads section
and the store.
Very well done stuff...
J
On Apr 4, 2005 4:50 PM, Paul Vernon <[EMAIL PROTECTED]> wrote:
> Thanks for that... Do you have a URL for the forums
>
> Paul
Many thanks to all. I have it running locally. Now it's server time.
CF (and the whole server setup issue) is more intense than I thought it would
be. I'm glad I was able to set it up locally first. I don't know how much
development I'll try outside of the Forums program. I got lucky with 2.05
I would like to meet Jared myself, so its in my best interests to help him
out. Can't think of a better way.
On Apr 4, 2005 1:51 PM, Will The Game <[EMAIL PROTECTED]> wrote:
>
> Hey all,
>
> As you know, Jared R-H posts quite a bit here. He's helped me out a ton,
> and probably has helped many
Hi Jon,
I'm happy with this utility , except this little problem.
Bellow is the code:
parser = createObject("java", "com.Ostermiller.util.ExcelCSVParser") ;
fileInfo = parser.parse(fileContents) ;
noFields = arrayLen (fileInfo);
for (i = 2; i lte noFields; i = i + 1)
{
lineArray = fil
On Apr 4, 2005 12:20 PM, Mark W. Breneman <[EMAIL PROTECTED]> wrote:
> I can verify that it is CF that is doing this. In CFMX (6) you could set any
> query cell to any value. In CFMX 7 it looks that CFMX uses typed columns.
Yes, one of the changes in CFMX 7 is to make more use of query
metadata so
http://www.fusionzone.com/
http://www.infosoftglobal.com/PoS4TallyPro/index1.html
-Original Message-
From: Ali Awan [mailto:[EMAIL PROTECTED]
Sent: April 4, 2005 18:48
To: CF-Talk
Subject: Generating BarCodes in CF
I was wondering if anyone knows of any CF apps, or used CF to connect t
> When they say file system, do they mean do a manual delete
> through Windows?
Yes.
> Also, the article goes on to talk about reindexing. I had not
> thought of this concerning CF. I run an app on Novell that I
> requires reindexing every other day. Do you have to maintain
> CF/a CF databas
On Apr 4, 2005 1:30 PM, Jacob <[EMAIL PROTECTED]> wrote:
> What I read was that if you increase the heap size, you must also increase
> the perm size.
Where did you read that (because it isn't true)?
> BUT... I can reduce the perm size on a couple of servers. Maybe I do not
> need it this high.
Jochem and Emmet, thanks very much.
The article states:
Go into ColdFusion Administrator, click the Verity link (note the path to the
directories for each on your hard drive in parenthesis), and delete these two
collections:
Forums_CFForums_Messages
Forums_CFForums_Subjects
Then, go into t
Surprise that you have not heard from them. Usually pretty responsive.
-- Original Message --
From: "Bailey, Neal" <[EMAIL PROTECTED]>
Reply-To: cf-talk@houseoffusion.com
Date: Mon, 4 Apr 2005 11:12:39 -0500
>Hey guys,
>
>Anyone out there using the CFX_
Victor,
I'm using the ostermiller CSVWriter, and I am very happy with it. I'm
having trouble understanding exactly what your problem is. Can you
share some relevant code?
Jon
On Apr 4, 2005 12:58 PM, Victor Moore <[EMAIL PROTECTED]> wrote:
> Actually it's a little bit more complicated than thi
I was wondering if anyone knows of any CF apps, or used CF to connect to 3rd
party apps to generate barcodes. Specifically 2D barcodes. If you are
familiar with barcodes, you will know what that means :-)
There are some off-the-shelf cfapps that generate barcodes but not in that
format.
A
Thanks. And thanks for the reminder, guys, re: the pound signs. Sometimes when
I'm in a rush, I just slip into old habits just to meet some deadline. I'm sure
we all have moments when we look back on code we've written in the past and
groan. There are probably developers somewhere who inherited
Here you go. Never can tell when archive.org will come in handy.
You are getting one of the following error trying to post a message right
after installing Forums or when posting or deleting a message:
Error:
Error occurred in tag CFINDEX
Collection failed to open: Forums_CFForums_M
Chris Manougian wrote:
>
> The Allaire knowledgebase article that discusses how to fix this can be found
> at: http://www.allaire.com/Handlers/index.cfm?ID=1560&Method=Full
>
> Rey, the Allaire KB is no more. Do you happen to have this KB article - or
> could you set me in the right direction
Way Off Subject:
Rey, I've got a problem that you helped solve for a guy installing Allaire
Forums back in 2000. Sorry to be posting this here, but this is the only way I
could get you.
The guy you helped posted:
I have just installed Allaire Forums 2.06 (CF4.01), and although it installed
f
Thanks for that... Do you have a URL for the forums
Paul
~|
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
It doesn't have to be mapped, it can be physically beneath each site (if you
do that, be sure to NOT include your CF Admin stuff).
- Calvin
-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]
Sent: Monday, April 04, 2005 11:41 AM
To: CF-Talk
Subject: Re: Dreaded cfform.js
I've always found pound signs make it hard for me to read stuff so I find
myself organizing my code in such a way as to avoid them where reasonable.
Nice solution Rebecca.
- Calvin
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Monday, April 04, 2005 5:28 PM
To: CF-
Good to knowthanks for the heads up, Dave!
Rick
-Original Message-
From: dave [mailto:[EMAIL PROTECTED]
Sent: Monday, April 04, 2005 5:15 PM
To: CF-Talk
Subject: RE: search engines
Someone brought up serving up different content to a bot then to the viewers
as being a viable solut
> Then I just loop over the query with the data for the
> variables and build a variable with the letter text, like this:
>
>
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Was
When I use CF to create "mail merge" type form letters, I first set up my
format characters as a block of variables, like this:
Then I just loop over the query with the data for the variables and build a
variable with the letter text, like this:
After the loop, use cffile to
Someone brought up serving up different content to a bot then to the viewers as
being a viable solution but wordpress just found out the hard way thats not the
way to go.
"Google officials declined to comment on why WordPress.org pages had dropped
from the company's index, but its Webmaster
Hey all,
As you know, Jared R-H posts quite a bit here. He's helped me out a ton, and
probably has helped many of you as well. He's an exceptional CF'er, JS'er,
blogger and provides plenty of great code for us to use. As of right now Jared
will not be able to attend CFUNITED do to some unfortun
Did you try single quotes?
Try
WHERE datepart('h',statistique.date_in) = 11
CFDEV wrote:
>Thanks but it still says too few parameters :(
>
>I'm on CFMX 6.1 with a MS Accecss datasource.
>
>Pat
>
>-Original Message-
>From: Howie Hamlin [mailto:[EMAIL PROTECTED]
>Sent: April 2, 2005 19
There is NOT a file called security.exe in that directory. There IS a
security.exe a couple of subdirectories down, but the executable to launch the
application, and the sexurity.exe file are NOT in the same directory. Further,
I copied the security.exe file to the application start directory so
What I read was that if you increase the heap size, you must also increase
the perm size. This setting has worked well so far for me.
BUT... I can reduce the perm size on a couple of servers. Maybe I do not
need it this high. I will start at 256 and see what happens.
Jacob
-Original Messa
> I am using: file://g:/applications/foobar.exe
>
> There are several applications in that directory. SOME of the
> applications launch without a hitch, but when I use this
> particular FoxPro application I get the "File security.exe
> does not exist" error. Note that this is a FoxPro Error
>
> Has anyone else noticed that CFMX7 now casts a date column
> as date time in
> queries? Or is it just a Monday and I have not recovered
> from the weekend?
> When I run a query to get one record
>
> SELECTStartDate, RecordId, RecordDate
> FROM BuildsData
> where recordid = 1
>
> T
I finally went the "variable in a hidden formfield" route...
Rick
-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: Monday, April 04, 2005 3:50 PM
To: CF-Talk
Subject: Re: Anything wrong with this statement?
>>When the page is submitted back to itself, the vari
Tony,
The application where this is used needs to be keep generic and needs to be
able to accept many different types of data.
This "application" is one part of an in-house system "smartVar UDF", I wrote
to really simplify the creation of the many "CRUD" (CreateReadUpdateDelete)
pages I make. (I
Thanks Jim, but still a problem.
I am using: file://g:/applications/foobar.exe
There are several applications in that directory. SOME of the applications
launch without a hitch, but when I use this particular FoxPro application I get
the "File security.exe does not exist" error. Note that this
>>When the page is submitted back to itself, the variable is upped 1,
Ah ah! Here is what is wrong: when the page resubmit itself, the
variable Photo is lost and a new one (default = 0),
Unless you resend the variable through the URL or as an hidden field.
You could also use a session variable i
That's not a CFFILE filefield. That's an HTML form element of the type
file. It's a standard HTML problem. I think most people dislike it but
you get used to it.
John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
-Original Message-
From: Ri
really?
what kind of application? one that doesnt do it on the other side?
basically when you hand it off from cf to "the other application" it
just looks at it, and cant format it for itself?
tony
On Apr 4, 2005 3:24 PM, Mark W. Breneman <[EMAIL PROTECTED]> wrote:
>
> Hey Tony,
>
> Your sugge
Ok...I got this part figured out...now the users can click "Add Another
Photo"
and the page resubmits and adds another CFFILE filefield and caption
field...
I know this could be done more elegantly in JavaScript...but I'm no JS'er...
You know, it's too bad the CFFILE file selection dialog won't le
If at all possible you might want to look into the java CF_payflowpro tag as
a replacement. I could not get CFX_Paymentnet running on a new windows 2003
server. (That does not mean it can not be done)
If you contact me off list I can send you a copy of the CFX_Paymentnet tag,
but it is very o
Hey Tony,
Your suggestion on casting it as a varchar works well. Thanks!
This causes problems for me where I want to apply date formatting to a query
column. Yes, I know applying a date format in a query result is a
"different" way of doing it. But, I have application where it is required.
Th
This is the response on the Macromedia forums:
We have identified the issue and it occurs only when using the CFMX 6.1
updater (the bug is not in CFMX 7) and only when using the JRun connector.
We are working to get a hotfix released for the JRun connector as quickly as
we can.
Sorry about this.
Does anyone know where I can get a copy of CFX_Paymentnet? We are
running Ablecommerce 3 and want to enable real-time credit card
processing. However, this custom tag is required and it no longer
appears to be available on the VeriSign website (Verisign has not been
too helpful).
--Jeff
~~
I can verify that it is CF that is doing this. In CFMX (6) you could set any
query cell to any value. In CFMX 7 it looks that CFMX uses typed columns.
You can not use querysetcell to format a date in the mm/dd/ format, if
the query is returning a date column.
Anyone else see this?
Mark W.
Awesome, same setup here...thx for tip!
Stace
> -Original Message-
> From: Dave Carabetta [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 04, 2005 2:03 PM
> To: CF-Talk
> Subject: Re: CFMX 6.1 + JRun SP5
>
> On Apr 4, 2005 1:35 PM, Stacy Young <[EMAIL PROTECTED]>
> wrote:
> > Anyone had
i read on one of my many many many blogs that they are working on another
cf7 update which should fix a lot of these issues.
no idea if this one in particular will be or not. maybe one of the MM
insiders will have more data.
jonese
On Apr 4, 2005 2:56 PM, Paul Vernon <[EMAIL PROTECTED]>
wrot
Actually it's a little bit more complicated than this.
The com.Ostermiller.util.ExcelCSVParser utility returns a Java array
which is has a Vector type and not the coldfusion array type.
Unfortunately (and something that I cannot explain) some lines that
have empty fields are not pick up.
I need som
Like the title says, any news on this being fixed for the standalone CFMX
install on IIS 6???
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=238944b1
When can we expect to be able to apply this patch?
Paul
~|
Log
>Has anyone else noticed that CFMX7 now casts a date column as date time in
>queries? Or is it just a Monday and I have not recovered from the weekend?
I'm not positive, but I would guess that's how your database driver is
returning them, not CF. Perhaps it was a change in drivers between 6.1 an
> We have a shared file server that runs an application. All users have
> the same drive letter mapped, etc. The application is as follows:
>
> My understanding is that CFEXECUTE runs a process ON THE SERVER and
> therefore is not appropriate for what I am trying to do.
Exactly right.
> When I s
cast it as a non-date column, varchar?
then it will come to cf as a varchar and not a date.
not sure why this would be a problem either way?
tw
On Apr 4, 2005 2:21 PM, Mark W. Breneman <[EMAIL PROTECTED]> wrote:
> Has anyone else noticed that CFMX7 now casts a date column as date time in
> quer
We have a shared file server that runs an application. All users have
the same drive letter mapped, etc. The application is as follows:
G:\applications\Program.exe
I would like to place what amounts to a "shortcut" on my web page that
allows all end users to run Program.exe from that link.
My un
Has anyone else noticed that CFMX7 now casts a date column as date time in
queries? Or is it just a Monday and I have not recovered from the weekend?
When I run a query to get one record
SELECTStartDate, RecordId, RecordDate
FROM BuildsData
where recordid = 1
The query returns
On Apr 4, 2005 1:35 PM, Stacy Young <[EMAIL PROTECTED]> wrote:
> Anyone had experience upgrading Jrun For CFMX 6.1 to JRun SP5? Any
> issues?
>
We're still testing our staging environment (2-server cluster on
Solaris), but so far no issues.
One tip that could save you time: If you have to manual
S.Isaac Dealey wrote:
> That's actually a pretty complicated solution -- although if you need
> a solution that works server-side without the aid of javascript you're
> reather limited to something like that...
If you looking for a server-side only solution, it's the simplest. Mind
you, if you do
On Apr 4, 2005 6:06 AM, Jacob <[EMAIL PROTECTED]> wrote:
>
> On my machines, with 2GB RAM and dual Xeons of various speeds, I have mine
> JVM setting as follows:
>
> MAX HEAP SIZE: 1024
> MAX PERM SIZE: 512
Did you actually *need* to set max perm size that high? That's an enormous
number for t
If you are using cfmx 7 and cfform you can add " validate="submitonce" to your
submit button. (see below)
From: Jeffrey Pratte <[EMAIL PROTECTED]>
Sent: Monday, April 04, 2005 1:11 PM
To: CF-Talk
Subject: Submit Once
Gang,
I am occasionally getting
Heck, in this particular case, it could be scoping that is tripping you
up...
- Calvin
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Monday, April 04, 2005 1:13 PM
To: CF-Talk
Subject: RE: Anything wrong with this statement?
I know...but it's a lot more work to
> Jeffrey Pratte wrote:
>> Gang,
>>
>> I am occasionally getting duplicate records in my
>> database. I think it is coming from people hitting
>> “Submit” twice when the server is slow. How do you
>> guys prevent this?
>>
>> I tried some JavaScript code to disable the button, which
>> did gray-out
Keith Gaughan wrote:
> But the principle is sound and should work for you.
This also has the advantage that it ensure that the form works without
the browser needing to have JavaScript enabled.
K.
~|
Logware (www.logware.us): a
Also, you might be interested in this post on Mark Nottingham's site:
http://www.mnot.net/blog/2003/09/13/click_submit_only_once
K.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Sta
Anyone had experience upgrading Jrun For CFMX 6.1 to JRun SP5? Any
issues?
Thx,
Stace
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a projec
Many thanks, guys, that now works perfectly.
Kind regards,
CK.
~|
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 wit
> Gang,
> I am occasionally getting duplicate records in my
> database. I think it is coming from people hitting
> “Submit” twice when the server is slow. How do you
> guys prevent this?
> I tried some JavaScript code to disable the button, which
> did gray-out the button, but then did not pass t
Jeffrey Pratte wrote:
> Gang,
>
> I am occasionally getting duplicate records in my database. I think it is
> coming from people hitting “Submit” twice when the server is slow. How do
> you guys prevent this?
>
> I tried some JavaScript code to disable the button, which did gray-out the
> but
i don't know of an "easy" way. but one thing you could do is to compare the
data with what is already in the DB and if it matches then don't do the
second input.
It will really depend on the type of data being input and if there are any
unique fields you can compare to (like email address's etc
I know...but it's a lot more work to explain everything up front
than to ask specific questions...I'll get more detailed (as you'll
see I did in a later response) about the code as I have to...
I should be able to find the problem...I was just checking that
statement...
Sorry if that's kind of an
the Photos variable isn't persistent (not a session, cookie, application
or whatever variable) so it's being redefined as 0 by the cfparam with
every request to the page. My suggestion (quick and dirty) would be to
put it in a hidden form field or pass it in the url.
/t
>-Original Message
Gang,
I am occasionally getting duplicate records in my database. I think it is
coming from people hitting “Submit” twice when the server is slow. How do
you guys prevent this?
I tried some JavaScript code to disable the button, which did gray-out the
button, but then did not pass the Button
> What happens if it is passed in with a non-numeric value ...
Wouldn't happen...the variable is used only on a page which
is submitting back to itself. No other pages are utilizing it.
Its default is set to 0, the formula runs, adding 1 to the value,
and then it gets incremented up 1
> Is there a way to find out how many recordsets return by a
> stored procedure? Or is there a way to merge all the
> recordsets in a stored procedure so that it would only return
> 1 recordset?
>
> I have a stored procedure that would return an unknown number
> of recordsets depending on how
Adam Howitt wrote:
> You may want to check out Joe Celco's nested set model (no refs but google
> should find it) for a neat way to handle this type of hierarchical
> information storage. In the meantime you could keep the cursor but insert
> the resulting recordsets into a working table before
Oh hell, that's hideously simple...
CREATE PROCEDURE dbo.sp_organizations
@parent_id int
AS
DECLARE @Name varchar(500)
DECLARE @Parent int
DECLARE cur_Level CURSOR LOCAL FOR
SELECT Organization_id AS ID,
Organization_nm, Parent_organization_id
FROM Organization
WHERE Parent_organization_id =
Rick:
It's generally easier to get an answer if you are as descriptive as possible
about your issue (if an error, what error...if not, what was unexpected).
Makes it much easier to troubleshoot and offer up suggestions than just
being shown a line of code.
While there was nothing wrong with yo
Chris Kavanagh wrote:
>>> people.person_id
>>
>> hahahahahhahahhahhhaahaha.ah. sigh.
>>
>> sorry Chris, back to the topic.
>
> <:| uh?
>
> I love it when I'm funny but it's a bit disconcerting when I don't know
> why.
Kerry's just stirring the crap. It's to do with the pluralisat
> bit disconcerting
there was a massive thread recently about singular/plural table names
>i have a Session.person_id
well, if another join doesnt work for you then you could do a subselect:
WHERE
tasks.status_id = 1
AND project_id IN (select p
I'd think "importance" would be subjective as to who was looking at
it. I personally try to always do it like this:
But I got into the habbit of putting in Variables due to working with
inherited code that lacks much of any scoping. So I'd maybe come
across a page with references to Photos but
The example of flash forms or the example of XSL? I have messed with
the flash one, saw no flakeyness but honestly do not think I tried it
in something other than IE.
On Apr 4, 2005 11:34 AM, Bob Clingan <[EMAIL PROTECTED]> wrote:
> Yeah, there is one example, but
>
> 1. Its IE only
> 2. Its a l
Thanks for the replies, everyone...
I've ensured the value / variable exists by preceding it with
As to scoping it with variables., as in "variables.photos", why
is that important?
Charlie...why do I ask? Well, I'm trying to increment the value,
and so far, it's not working...something must b
Yeah, there is one example, but
1. Its IE only
2. Its a little flaky
--Bob
>I saw on a blog not too long ago that someone was working on a XSL
>file to integrate qForms which maybe could lead to an interesting
>approach to doing n-selects. If you are using the flash forms feature
>there are a
You may want to check out Joe Celco's nested set model (no refs but google
should find it) for a neat way to handle this type of hierarchical
information storage. In the meantime you could keep the cursor but insert
the resulting recordsets into a working table before returning the complete
res
>> people.person_id
> hahahahahhahahhahhhaahaha.ah. sigh.
>
> sorry Chris, back to the topic.
<:| uh?
I love it when I'm funny but it's a bit disconcerting when I don't know
why.
>> it only gets TASKS that belong to the PROJECT that the PERSON
> is cleared for
>
> Im not sure how
Rick Faircloth wrote:
> Is there anything wrong with this statement in an of itself?
>
>
wrong? it assumes a value for Photos already exists?
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket applicati
Hey guys,
Anyone out there using the CFX_gfont extension by efflare.com with
ColdFusion 7 on Window Server 2003? I been using this for the past year and
it works great, but since I have upgraded to CF7 I cant seem to get it to
create the font images anymore. Would any one have any ideas on this?
Your right, but they should be var scoped. I assumed people would realize
when I said "I like" they would understand what I meant. I assumed wrong.
:-)
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Monday, April 04, 2005 12:12 PM
To: CF-Talk
Subject: Re: Anythi
>people.person_id
hahahahahhahahhahhhaahaha.ah. sigh.
sorry Chris, back to the topic.
>it only gets TASKS that belong to the PROJECT that the PERSON
is cleared for
Im not sure how you are defining "cleared for", but it should just be a
couple more Inner Joins?
-Original Message
yes, but what you like to do (placing parens around calculations) doesn't
mean there's anything wrong with the original statement "in and of
itself"...
On Apr 4, 2005 12:07 PM, Bryan F. Hogan <[EMAIL PROTECTED]>
wrote:
>
> Yes, photos should be var scoped and I like to place parins around my
Hi,
Here is my stored procedure:
CREATE PROCEDURE dbo.sp_organizations
@parent_id int
AS
DECLARE @Name varchar(500)
DECLARE @Parent int
DECLARE cur_Level CURSOR LOCAL FOR
SELECT Organization_id AS ID, Organization_nm, Parent_organization_id
FROM Organization
WHERE Parent_organization_id = @pa
no. of course, curious as to why you ask... :)
On Apr 4, 2005 12:05 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote:
>
> Is there anything wrong with this statement in an of itself?
>
>
>
> Rick
>
>
~|
Discover CFTicket - The
I saw on a blog not too long ago that someone was working on a XSL
file to integrate qForms which maybe could lead to an interesting
approach to doing n-selects. If you are using the flash forms feature
there are a few examples floating around on the net on how to do "two
selects related" boxes, I
No, not really...I would just variable type it..
Say
You will have to ensure photos is numeric.
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: 04 April 2005 17:06
To: CF-Talk
Subject: Anything wrong with this statement?
Is there anything wrong with this stat
Yes, photos should be var scoped and I like to place parins around my calcs.
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Monday, April 04, 2005 12:06 PM
To: CF-Talk
Subject: Anything wrong with this statement?
Is there anything wrong with this statement in an
1 - 100 of 149 matches
Mail list logo
