From: Alexander Sherwood [mailto:[EMAIL PROTECTED]
Absolutely nothing. I've always been amazed at the lengthy
threads that result from a defense or criticism of parts of
the different frameworks. I've seen threads where people
swear by FuseDocs and others where FuseDocs are call a huge
From: Rob [mailto:[EMAIL PROTECTED]
Subject: Re: OT: How do I print out a directory listing in XP
http://www.rohanclan.com/library/printdirlist.cfm
[EMAIL PROTECTED]
wrote:
I need to print out a directory listing for a disk I am sending to a
printer.
Can someone tell me how to do this?
Nevermind. Regedit did it.
Michael T. Tangorre
-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 04, 2004 10:37 AM
To: CF-Talk
Subject: RE: OT: How do I print out a directory listing in XP
From: Rob [mailto:[EMAIL PROTECTED
I fixed it by installing Linux.
Bah! Lets not get carried away!
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183361
From: Kwang Suh [mailto:[EMAIL PROTECTED]
If people really want it, I'm going to write a very long,
detailed tutorial on using Mach-II sometime in December. I
wasn't too satified with the amount and quality of
documentation out there.
Kwang, MANY people would be interested in it; me
http://www.rohanclan.com/library/printdirlist.cfm
Very Cool!
~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
SELECT *
FROM Clients
WHERE Client_IntakeDate BETWEEN '10/1/2004' AND '10/31/2004'
WHERE
Client_IntakeDate = '10/1/2004'
AND
Client_IntakeDate = '10/31/2004'
I don't use access so I am not sure which operators are available... But
give the above a shot.
Mike
From: Robert Orlini [mailto:[EMAIL PROTECTED]
I know this is an easy one, but can't find the right code.
How do I have CF alternate color for each row of a table?
Anyone have the code please?
cfif queryName.CurrentRow MOD 2 EQ 0
Red
cfelse
Blue
/cfif
Mike
From: Bob Clingan [mailto:[EMAIL PROTECTED]
I'm curious who is using Mach-II...
Documentation and examples seems to be very minimal.
There is a MACH-II list over at topica that is pretty active. Also,
check out Sean Corfield's blog (www.corfield.org) as he is VERY involved
with it.
Mike
From: Donna French [mailto:[EMAIL PROTECTED]
No, it doesn't work Mike, had already tried that too.
How about...
WHERE
Client_IntakeDate =
cfqueryparam cfsqltype=CF_SQL_DATE null=No
value=CreateODBCDate('10/01/2004')
AND
Client_IntakeDate =
From: Chad McCue [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 02, 2004 1:57 PM
Subject: Re: Session Management
I am looking for a tag or script that will allow a user to
continue their session when it has expired due to their lack
of using the site. I have looked at cfdev.com and
Looks like the people at MAX are having too much fun to care about the
rest of us staring at our empty inboxes... in particular the CF-TALK
folder. :-)
~|
Protect your mail server with built in anti-virus protection. It's
From: Guy McDowell [mailto:[EMAIL PROTECTED]
SQL 2000 and the field datatype is nvarchar set to 300 chars.
Insert Statement:
INSERT INTO tblMyTable (txtField)
VALUES ('#frmTxtField#')
'#frmTxtField#' comes from a textarea form element.
Sometimes I get a truncate data error from the
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
CAST(pl.txtDescription AS nvarchar) AS txtDescription
snipped from books-on-line
nvarchar(n)
Variable-length Unicode character data of n characters. n must be a
value from 1 through 4,000. Storage size, in bytes, is two times the
number of
Anyone heard from Dan Switzer lately?
~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38
Message:
I have a form that has a series of radio buttons, so that
users can choose a timeperiod. If the user picks 'Range',
they can then also choose 'one week, two weeks, one month,
etc.' to specify the range.
What I'm wondering... is whether there is a way I can write
something in
223073026
that value should validate in this right... (CMFX 6.1 WIN2KSERVER)
cfqueryparam value=#ipAddressNumber# cfsqltype=CF_SQL_INTEGER
Trim(ipAddressNumber)
~|
This list and all House of Fusion resources hosted by
223073026
that value should validate in this right... (CMFX 6.1 WIN2KSERVER)
cfqueryparam value=#ipAddressNumber# cfsqltype=CF_SQL_INTEGER
Also, make sure you that your DB Column is INT and not BIGINT or
TINYINT.
Or, if it is.. Use the corresponding CF SQL type
Mike
Tango? Someone call me?
Michael T. Tangorre
-Original Message-
From: Mark Drew [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 27, 2004 9:08 AM
To: CF-Talk
Subject: Re: the best way?
Tango?
On Wed, 27 Oct 2004 14:11:57 +0100, [EMAIL PROTECTED]
[EMAIL PROTECTED]
From: Rodger [mailto:[EMAIL PROTECTED]
This brings up another question:
Is there a way to install my copy of MS SQL Server onto my XP
machine to be used for dev?
When I try, it only allows me to install the client stuff
(Enterprise Manager and Query Analyzer).
You need to get a copy of
From: Cornillon, Matthieu (Consultant)
.
can't prove. Does anyone recognize this kind of behavior at
all? Any ideas where I might look for a solution?
What version of CF are you running.
Michael T. Tangorre
~|
From: Bert Dawson [mailto:[EMAIL PROTECTED]
In a custom tag you could use cfexit, but since you're in a
cfinclude you'll need to put everything in a cfelse:
cfif records IS 0
some code...
cfelse
more code
/cfif
Read here:
Best practice is to scope all variables Then its not an issue.
Michael T. Tangorre
-Original Message-
From: George Abraham [mailto:[EMAIL PROTECTED]
Sent: Friday, October 22, 2004 10:41 AM
To: CF-Talk
Subject: parameters and query values
Right,
So who exactly wins out in
Our internal application users have been requesting some pretty
complicated reports... anywhere from 20-75 data fields organized 25 ways
from sunday, etc. What they really desire is to pick any field from any
page in the application and generate a custom report, etc. and have the
ability to save
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Cache the crunched report data and the presentation
separate... got an app now that I would love to change the
fact that I cached the HTML page generated (mixing the data
with the presentation)
The app is in FB4, so the data is
From: Douglas Knudsen [mailto:[EMAIL PROTECTED]
I usually ask them if its cost effective to build so many
reports or a huge reporting tool when there are other
products out there, crystal, business logic, etc. In my
company we usually build a couple canned reports then give
the user a
From: G [mailto:[EMAIL PROTECTED]
Lemme know if you got any questions about reporting services
MT, i've been immersed in it for months now...for better and worse :)
Will do! Thanks for the offer :-)
Mike
~|
Sams Teach
It does seem low but when you take into consideration it's a quick 2
month gig.. In and out... If you are good and need to $$$ you can knock
it off and move on.
Michael T. Tangorre
-Original Message-
From: dave [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 21, 2004 2:52 PM
ColdFusion server side processing is kicking in due to the _required
on the field name.
Rename your field to something else would be the easiest solution...
Until MM ensures that only hidden form fields are considered for server
side form validation.
Michael T. Tangorre
-Original
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Which would be impossible, since the hiddenness of a form
variable is only client-side, not server-side, so there's no
way for CF to know whether a field was hidden or not, unless
it somehow preprocessed the form before it was sent to the
From: Andrew Dixon [mailto:[EMAIL PROTECTED]
I'm just starting a major project for a government client and
the first job is to design the database. Is there any
recongnised convention on the naming of database fields. In
the past I have always named them [table_name_field_name] for
From: Robertson-Ravo, Neil (RX)
Again, its all personal choice. I usually steer well clear
of underscores as a rule as it can be hard to distinguish
between multiple underscores..
Out of the following, I find option 1 to be the easiest to read.
APPLICATION_USER
APPLICATION-USER
From: Robertson-Ravo, Neil (RX)
but when you have DBs with hundreds of tables, this can add up.
Erm...that statement isn't true.
How so? You mean to tell me that this:
tblA
tblB
tblC
tblD
tblE
Is faster than:
A
B
C
D
E
?
From: Robertson-Ravo, Neil (RX)
Well it will probably be negligible, but are you planning to
name your tables A,B,C,D,E etc...?
You will be in the same boat of any naming convention unless
you only want tables names A,B,C or, AA, BB, CC or even AAA,
BBB,CCC etc... ;-)
A better example
What is wrong with application_user? I prefer to keep
everything in lowercase so I can easily distinguish SQL
keywords from identifiers.
Good point. If I weren't so tied to the color coding of the database
IDEs I use, then this would be my choice as well; but since the color
coding
We have 5 internal applications that send out emails to the users when
different things happen inside the applications. Everything was working
fine for weeks then this morning I see that in the mail log, there are
hundreds of entries like this one:
Invalid Addresses; nested exception is:
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
The error says the mail server does not allow relaying. Allow
relaying on the mail server and you will be fine.
Jochem
Right. However, why would it work for weeks then all of a sudden start
tossing this error? Must be the network guys are
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Yeah, you just can't trust them :-)
Jochem
Looks like the new guy was putzing around again!!!
Thanks for the info everyone.
Mike
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and
From: cf coder [mailto:[EMAIL PROTECTED]
Hello everybody,
I'm hoping someone can help me. I am working on this
exception handling code. I have written a custom error
handler that displays a custom error message when a
coldfusion error occurs and sends an email to the
administrator. I
From: cf coder [mailto:[EMAIL PROTECTED]
cfcatch.details returns nothing. Does it depend on the type
of exception I select?
It is cfcatch.detail
Check this page for more in depth info...
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-a10.htm#wp33
95038
Michael T. Tangorre
From: Phillip Perry [mailto:[EMAIL PROTECTED]
cfquery name=check_email datasource=#mydbname#
SELECT newsletter_id, email_address
FROM newsletter
/cfquery
cfif 'email_address' EQ !--- I have tried IS also ---
#form.email_address#
Your email address is already in our system.
cfelse
Finally, I'll never forgive the Java designers for having
droped pointers.
Gee, this was the best innovation in computer science since
the punched card!
WHAT?!!
What is your rationale behind this?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
LOL.
WHAT?!!
Michael T. Tangorre
-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 06, 2004 4:26 PM
To: CF-Talk
Subject: Re: Coldfusion and C++
WHAT?!!
POINTERS!!! ;-))
--
___
REUSE
From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED]
Subject: Slightly OT: Name top 5 CF developers you know one way or
another
1. cf-community
2. cf-community
3. cf-community
4. cf-community
5. cf-community
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User
From: Donna French [mailto:[EMAIL PROTECTED]
Is there an easy way to go about handling table rows/columns
colors as I am doing my page design/layout?
Double them up:color=##FF when inside a cfoutput.
I go with using external stylesheets to avoid all that double pound
here, single pound
What are some of the methods people use to ensure that a form is not
being submitted outside the site in question. I know you can check the
CGI.HTTP_REFERER but not all servers/proxy servers set this...
Ideas?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User
From: Paul Vernon [mailto:[EMAIL PROTECTED]
set a session var on each page that sets specifically the
page you are on.
when the form is submitted, check against that session var...
What happens if I save the HTML. Rework it, and drag that icon onto the
open browser window that holds the
Anyone see whats wrong with the following stored procedure call, I keep getting the following error when trying to return an integer (last ID)...
Invalid datafor CFSQLTYPE CF_SQL_INTEGER.
CF Stored Proc Call
cfstoredproc
procedure=INSERT_COMMUNITY_BUSINESS
I want to put all of the session info that I would normally
put into application.cfm using fusebox.
Info such as cfapplication name=, and cfcookie name=.
Do I put it into the fbx_Settings.cfm file?
I am currently using fusebox 3.
If you are just starting the project, I would switch to FB4
From: Donna French [mailto:[EMAIL PROTECTED]
Okay, I am probably wanting too much - but is there a way to
set the tab order on a CF page like in VB.NET? I have a form
with lots of text fields and need to set the order.
textarea tabindex=1 name=fe1/textarea
textarea tabindex=2
From: Phill B [mailto:[EMAIL PROTECTED]
If a query doesn't fail, I want to make some thing else
happen. What would be a good way to do this?
Do you mean if a query does fail?
cftry
query
cfcatch type=Any | Database |...
... Something to do if it fails
/cfcatch
/cftry
Continue
The major benefit of using cfquery to call is that you can cache the
results. There are no cachedwithin or cachedafter attributes in
cfstoredproc (which I think MM should address!!!). The only way to cache
the results is to put them into a shared scope or use QoQ... Which is a
waste.. Just use
I am interested in getting some feedback from people on the following:
Once you have gotten your requirements for a new application and the
modeling/architecture process ensues, what tools do you use to link
requirements to screens, processes, etc? I have been evaluating Adalon
as a tool to
From: Matt Robertson [mailto:[EMAIL PROTECTED]
How would I go about getting rid of evaluate() in this loop?
I'm having a brainlock.must have gotten up too early today.
cfloop
list=#form.FieldNames#
index=TheFormField
cfscript
if (len(Evaluate(TheFormField))) {
a yahoo group for the
gateway as he does for qForms?
Dan
- Original Message -
From: Tangorre, Michael [EMAIL PROTECTED]
Date: Tue, 21 Sep 2004 17:31:37 -0400
Subject: OT: JS Gateway Question
To: CF-Talk [EMAIL PROTECTED]
I am still in search of a solution to a problem I had a few weeks
From: Noah Mudge [mailto:[EMAIL PROTECTED]
I am looking for a decent cf editor to use on my Linux
workstation.Any ideas?
When on linux I strictly use PICO!
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
From: Ray Champagne [mailto:[EMAIL PROTECTED]
Is there a way to detect if the client browser has _javascript_
turned on using CF?In other words, when the client makes a
cfm page request, is there some kind of CGI variable that is
passed through?I can clarify more if need be
Try
From: dave [mailto:[EMAIL PROTECTED]
as we go through this all the time on here (hosting
recommends) and i have always recommended hostmysite.com as u
all know and i'd assume they'd step up and help u guys out
the best they can.
I have a reseller account and could get anyone signed up
From: Dan O'Keefe [mailto:[EMAIL PROTECTED]
Hi Mike,
Did you check with Dan Switzer? Does he have a yahoo group
for the gateway as he does for qForms?
Hi Dan,
I inquired about the gateway email list and Dan S. said to use the
qForms emal list for JS Gateway questions... which I have done
From: Ciliotta, Mario [mailto:[EMAIL PROTECTED]
I know that there is #error.querystring#, but is
there anyway to get the query string if there is no error.
#CGI['QUERY_STRING']#
Michael T. Tangorre
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
From: Dave Carabetta [mailto:[EMAIL PROTECTED]
That won't work. CGI.query_string is for returning anything
passed via the URL.
I know... I misread what he was asking for.
Michael T. Tangorre
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
From: Asim Manzur [mailto:[EMAIL PROTECTED]
I have form with TextAreaand _javascript_, which doesn't
allow user to hit enter key and |.
The below code is working fine, but if user cut/paster from
word or notepad then textbox accept the enter key and pipe.
Can someone advise anyway to
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Anyone have experience with hostmysite.com ... particularly
the Ultra Developer plan (SQL server)?
I have a reseller account with HostMySite and my initial account is the
Ultra Developer. Their support is awesome (24/7 phone and live chat).
Their
I am still in search of a solution to a problem I had a few weeks back.
This is OT for the CF list, but I am hoping someone here has used the JS
Gateway from www.pengoworks.com.
I have a form with a bunch of select boxes on it that I use qForms to
populate, etc (from a DB.. use ColdFusion to
From: Damien McKenna [mailto:[EMAIL PROTECTED]
Does anyone have an ETA on the release of Fusebox 4.1?
Supposedly sometime this week according to the people I talked to at the
conference this past weekend. I can't wait. I thought maybe they would
have given it to us at the conference... They
From: Nathan Strutz [mailto:[EMAIL PROTECTED]
Any word on what's new in 4.1? I'm very interested, though
I'm not a full-fledged fuseboxer.
instatiate
invoke
Content variables with include
Fusebox.init.cfm (global fuseaction)
Core file error templates
New classes section of the fusebox.xml
Does anyone recall the fix from MM for the left nav bar in the CFADMIN
when accessing it over HTTPS?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
From: Dave Carabetta [mailto:[EMAIL PROTECTED]
http://www.macromedia.com/support/coldfusion/ts/documents/navs
erver_blank.htm
FYI, you can keep track of all hotfixes here:
http://www.macromedia.com/support/coldfusion/ts/documents/tn17883.htm
Thank you.
I thought this might have been
I have been using the JS Gateway that Dan Switzer has up on his
pengoworks website and have run into an issue I haven't been able to
solve.
If anyone is using or has used it, contact me off list and I will
describe the issue in detail. It might be pretty simple, but I am
spinning my wheels here.
From: Asim Manzur
Did anyone recently visit
http://www.cfcertification.com/
What the hell is wrong with you? You could at the VERY MINIMUM, let
people know the link was not work safe. Why would you post that crap
here?
Some people.
-MT
[Todays Threads]
[This Message]
[Subscription]
I would recommend that you use your own graphics for the
buttons. I usually use my own graphics button in place of the
browse button.
How exactly do you do that
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Given the following:
SELECT
R.TEAMING_AGREEMENT_ID,
R.ROUTE_GROUP_ID,
B.BUSINESS_NAME,
T.OPPORTUNITY_ID,
D.DOCUMENT_NAME,
D.DOCUMENT_EXTENSION
FROM
TEAMING_AGREEMENT_ROUTING R
INNER JOIN TEAMING_AGREEMENT T
ON (R.TEAMING_AGREEMENT_ID = T.TEAMING_AGREEMENT_ID)
INNER JOIN
I think I solved it Join the document table in twice and in the join
clause added the condition
SELECT
R.TEAMING_AGREEMENT_ID,
R.ROUTE_GROUP_ID,
B.BUSINESS_NAME,
T.OPPORTUNITY_ID,
D.DOCUMENT_NAME AS TEAMING_AGREEMENT_DOCUMENT,
D.DOCUMENT_EXTENSION AS
I am getting an error when linking to a page with the following query
/index.cfm?fuseaction=nonsitepage.displayitemid=1577preview=true
Invalid data '' for CFSQLTYPE 'CF_SQL_INTEGER'.
I would do a couple things:
1.) cfparam all your variables so you know they exist. Only use them if
their
Does it exist in both the form and url scopes? What do you have the FB
core files set to in terms of form or URL precendence?
Michael T. Tangorre
yes, but how do I get around the problem that the variable is
there in the url but is not being traced through to attributes.itemid
[Todays
From: Tony Weeg [mailto:[EMAIL PROTECTED]
anyone?
good/bad/scam?
It's a good site. I find many answers to questions there! I get all my
CF questions answered here, but for other things like C# that site comes
in very handy.
Michael T. Tangorre
[Todays Threads]
[This Message]
What are you guys paying for? Everytime I click on a link from google to
experts exchange, I just scroll way down and see the answers... They
must get a lot of suckers who click the sign-up button in the middle
of the screen above the answers. The only time you have to pay is to ask
a question...
Check the CFC I just emailed you.
Michael T. Tangorre
From: Tony Weeg [mailto:[EMAIL PROTECTED]
just want to auth. against ad and if ok, go through to dir on
my cfmx server.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
I am new to the idea of using CURSORs in SQL Server but would like some
input.
>From an efficiency standpoint, which is a better choice?
select query + cfloop + insert query
or
stored procedure using a cursor to do row by row inserts
The select query will never return more than 12
From: Steve Kahn [mailto:[EMAIL PROTECTED]
Unfortunately I had installed XP Service Pack 2 and my
Coldfusion server stopped working. So I un-installed the XP
SP2, and the CFMX. Then reinstalled CFMX and I am still
running into some function issues, any suggestions?
Did you install
I have been using qForms from www.pengoworks.com for awhile now. It is a
great, cross browser API for this type of stuff.
You don't have to use query results with it per se, but you create
structures (JS) to relate elements, etc. Gimme a hollar off list if you
need a hand with it.
Michael T.
http://www.hyperdictionary.com/dictionary/Progressive+JPEG
Not too common in my experiences yet. We also ran into this issue awhile
back.
Michael T. Tangorre
I'm allow the upload JPG and GIF files to our server through
a web page using cffile.In the accept, I had
I like the T-SQL book from O'Reilly... And then I like to read all the
Books OnLine for SQL server and the MSDN website!
Michael T. Tangorre
From: George Abraham [mailto:[EMAIL PROTECTED]
While we are on the rant about technical book authors,
anybody have any suggestions for books on SQL?
Is there anyway using ColdFusion to check if a person has access to a
specific folder on the webserver.
Our security model is strucutred around ActiveDirectory so the users
network ID, email, alias, etc is all available, and I am wondering if
there is a way to say...
if user has permissions to
Nope, jail time. :-)
Michael T. Tangorre
-Original Message-
From: Asim Manzur [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 09, 2004 1:00 PM
To: CF-Talk
Subject: Re: BlackStone Beta 1
sorry.
Could admin please delete this post. please please please.
Did you
ValueList() would work better for you here.
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/funca117.htm#wp11
14236
Mike
I'm using a query and loop to fill a body onLoad statement
for a _javascript_ image preload.
So far I've got:
body query=allphotos
startrow=1
Good catch Pascal. Personally I am not a fan of cluttering up tags with
nested cftags inside them, so I'd go with the QuotedValueList() over the
conditional logic in the body tag.Just a preference thing.
Michael T. Tangorre
It would be QuotedValueList and this would only work if the
query was
Is there anyway to get cfmail to not include the white space to the left
of what is between the tags?
For instance, we have some cfmail tags that are indented 2 or 3 tabs in
and this results in the content of the email being that way too.
Just curious...
Mike
[Todays Threads]
[This
Is there anyway to get cfmail to not include the white space to the
left of what is between the tags?
No. (Unless you start messing with cfsavecontent.)
That sucks. :-)
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
But, if the end user can't accept html emails (i know this is
a very small percentage of people these days), then that won't work.
Luckily, I work on our Corp Intrnaet apps where HTML email is a standard
and must be enabled for company mail communications internally so I'm in
luck :-)
Mike
I have emails going out with a link in them that points to a page that
serves the documents via cfheader/cfcontent.
When the link is clicked the standard open/save/cancel box appears. When
I click open, the window closes and the document opens. If I click
cancel, same thing. If I click save and
Just wanted to let you know I'm leaving on time today, but will probably
stay a little later tomorrow (til 7ish).
The final thing left to do for the NDA stuff is to upload the executed
doc, which will be done in the AM tomorrow.
You asked that the output be sorted by DATE ISSUED. That is no
What is the best way to pass a list of strings into a stored proc for
use with an IN operator.
For example...
variables['strBusinessRecipientList'] = mike,time,john,chuck,joe;
cfprocparam
cfsqltype=CF_SQL_VARCHAR
value=#variables['strBusinessRecipientList']#
null=No
Inside the
Dave,
What about a user defined function to take in a list of strings.. i.e.
mike,tom,bob,herb and then the function would loop over the names and
add the quotes and build a new string tor eturn and use in the IN
clause. Doyou forsee problems with that approach?
Mike
What is the best way to
I wrote the function below for SQL2K in hopes of solving the issue of
passing lists to stored procedures to use within IN operators. If you
pass a string such asmike,tony,bob,dave,tim,tom into the function
below, it will return 'mike','tony','bob','dave','tim','tom'. However,
trying to use it in
I wrote the function below for SQL2K in hopes of solving the
issue of passing lists to stored procedures to use within IN
operators. If you pass a string such as
mike,tony,bob,dave,tim,tom into the function below, it will
return 'mike','tony','bob','dave','tim','tom'. However,
trying to
What is the best way to pass a list of strings into a
stored proc for
use with an IN operator.
cfquery
EXEC procname (cfqueryparam ... list=true) /cfquery
Jochem
Yes of course. :-)But I was trying to figure out it is was possible to
use the cfstoredproc tag
Since I can get it to
That authors code is from sqlteam.com which is where I got the ideas for
the function I posted. The executed sql previously posted is going to
work fine I think...
Mike
SQL Server but default has no idea how to handle lists or
arrays so you need to find another way of doing it ...
What is everyone's take on the correct date format in the U.S.?
A bunch of us here at work got into a nice argument during lunch about
it :-)Seems like everyone thinks their way is the official way.
-MM-DD
YY-MM-DD
MM-DD-
MM-DD-YY
/MM/DD
YY/MM/DD
MM/DD/
MM/DD/YY
Any
This is for data rather than display, but the ISO standard
for date/time is 8601
(http://www.iso.ch/iso/en/prods-services/popstds/datesandtime.html)
which says that the format is like this :
*-MM-DDThh:mm:ss for a date/time
Yeah, that is the link that I used to backup my opinion of
101 - 200 of 911 matches
Mail list logo