Full Product at Estimated Retail Price
http://www.microsoft.com/sql/productinfo/pricing.htm
SQL Server 2000Enterprise EditionStandard EditionDeveloper Edition
Processor Licensing $19,999 US per processor$4,999 US per processor
SQL Server Processor Licensing Clarification
http://www.microsof
Thanks a lot both of you. I actually do have THE BOOK by Forta, I guess my
brain is just fried tonight that I didn't figure both of those out on my
own! :-)
I'm going to sleep now!
Thanks again,
Britta
- Original Message -
From: "Stephen Kellogg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMA
Try using one of the following in your query statements:
1.
Where tableField1 = '#form.variable#'
2.
Where tableField1 LIKE '#form.variable#%'
The % is a "wild card" so bu would return anything that started with bu, ie
bulb, bulbous but not xbulb
3.
Get one of Uncle Ben's (or someone's) books ;-
To do an exact match you would just do in a query Where
something='#something#' to do a partial match you would do where something =
'#something#%' putting the % where you would like the partical match to
look, in this case anything before it would be the search criteria. So you
could put bu in an
There are two things that I'm trying to figure out how to do: an Exact
Search - if I put in a search for "bulb" it would return only "bulb" not
"bulbous".
Secondly, I've got a client who wants a search which will search only
beginning of word: For instance a search for, "bu" would return "bulbo
I've got a client who is concerned that the adserver we are using seems to
be random in its service of ads. He'll sit there and continually refresh his
browser and gets upset when one ad comes up 3 times in a row, then another
comes up once, and then the original comes up another 5 times in a row.
Freddy,
No, the part that follows IN isn't the problem, it's that the PermissionID
column being used to compare against the "<> 1" is a string. SQL 2000 is
basically telling me that I can't compare a string with an integer. I've
worked around it by making the right side of the equation a string
I stayed with SQL7. It does all I need.
best, paul
At 08:59 PM 3/2/01 -0500, you wrote:
>I still haven't gotten an answer from anyone though. Is there anyone
>else out there hosting websites, other than their own, and using SQL
>2000 as the database? If so, how are you licensed? I guess with t
Couldn't you use Permissions.PermissionID IN " '4','5' "
Tim Fields wrote:
> I have a client that has an existing SQL Server database which includes a
> table used as part of a permissions framework. The problem is that whoever
> created the table was clever enough to create a column for permiss
On 3/2/01, Jim McAtee penned:
>Hell, if they can't figure it out themselves, why lose sleep over it? Fire
>up the server and get on with your life.
I guess that's the next step. Somehow I figure their roving "License
Cops" probably do understand it though. :)
I still haven't gotten an answer f
I have a client that has an existing SQL Server database which includes a
table used as part of a permissions framework. The problem is that whoever
created the table was clever enough to create a column for permissions id's
as a varchar rather than creating a join table. So I may a situation wher
Richard,
I don't know the answer to your question, but Verity can index xml file
types so you could expose a collection to CFSEARCH.
Regards,
Marc Garrett
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fu
HEY,Got it working, and it was something
small and dumb which I am not saying.
But thank you for your help.
Michael
TIme for many beer's and dinner
Once again THANK YOU
Later , I hear MOLSON calling my name.
Michael
"Robert Long" <[EMAIL PROTECTED]>
here is a function I wrote to check integers, I've modified it to fit your
needs:
function checkField(str){
var isValidNum = true;
// check if is blank
if( str.length == 0 )
isValidNum = false;
// check if is integer
for( i
Hell, if they can't figure it out themselves, why lose sleep over it? Fire
up the server and get on with your life.
Jim
- Original Message -
From: "Bud" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 02, 2001 2:59 PM
Subject: RE: M$ licensing has me at wits e
sweet. thanks.
-Original Message-
From: Chris Montgomery [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 12:42 PM
To: CF-Talk
Subject: RE: M$ licensing has me at wits end
A colleague in our CFUG told me about the MSDN Business Connection program.
After being accepted into that p
Yes... If you have the correct data and url, you should see the xml code
display by calling the page directly. Usually you must call a template or
post variable to a template for it to return xml to you
-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Frid
> http://www.cybercash.com/company/press/releases/2001/01mar02networ
> k1restruct
> > ure.html
>
> Didn't Cybercash bu ICVerify some time ago as well? Alot of
> eCommerce businesses
> use that.
Yep, Cybercash bought ICVerify a year ago or so, then promptly stopped
support of it. At that time, we
> I have a question about using cfcache with fusebox. If I have
> an action like
>
>
>
>
>
>
> I want to use cfcache on Display_Schedule.cfm. The link would
> be listed as index.cfm?action=ShowSchedule. If that is the case
> then the query would run. Or would you put the cfcache tag in
>
Just a note: The Intranet/Hosting Toolkit as of 3.12 is now freeware.
http://www.intrafoundation.com/intranethostingtoolkit.html.
(Got tired of fooling with it. :)
--min
~~
Structure your ColdFusion code with Fusebox. Get the official book at
This list is the best. Of course, after seeing the answer, I'm realizing
how obvious that was. Thanks for your help and patience!
-Original Message-
From: Robert Long [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 10:30 AM
To: CF-Talk
Subject: RE: CFMail - Sending a link in an
> A previous message mentioned locking session variables when
> you read or write them. Why? I thought session variables were
> unique to the client.
They are. That doesn't mean that they can't be accessed concurrently by that
(multithreaded, frames-capable, back-button-enabled) client.
Dave W
Well, I have no idea what you are trying to accomplish ...but why not
take a swing in the dark ;-)
If your using SQL Server look into the "dateDiff" function. Say you have
two dates @date1 = '01/01/2001 01:00' and @date2 = '01/02/2001 02:00'.
dateDiff("hh", @date1, @date2) would return 25 becau
Has anyone integrated the UPS XML Shipping data into a CF application or
anyone have any tips on where to start?
I have read through most of the UPS docs, but I seem to be missing some
basic knowledge. I really should pick up a book, but until I go grab one, I
still want to play around with this.
I apologize -- one line is off.
In the VALUES part of your SQL, I inadvertently put #ThisID# in twice. The second one
should be changed back to #Place#. Sorry!
-Andy
> -Original Message-
> From: Andrew Tyrone [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 5:16 PM
> To: CF
A previous message mentioned locking session variables when you read or
write them. Why? I thought session variables were unique to the client.
Joby Bednar
Director of Internet Design
iNEOgroup.com
http://www.ineogroup.com
Fusing your Dreams and the Web, Together as One
[EMAIL PROTECTED]
Cell:
Jay,
Try out the following:
INSERT INTO ResultsManager (RodeoID, EventID, ContestantID, Place,
TimeTaken, Points, AdjPoints, MoneyEar
- Original Message -
From: "Howie Hamlin" <[EMAIL PROTECTED]>
Sent: Friday, March 02, 2001 10:05 PM
> FYI:
>
> http://www.cybercash.com/company/press/releases/2001/01mar02network1restruct
> ure.html
Didn't Cybercash bu ICVerify some time ago as well? Alot of eCommerce businesses
use tha
In your code it looked like the IF's were nested incorrectly. If you
query where username=X and password=Y ..the result set you get back is
guaranteed to have a username of X and a password of Y ...so their is no
need to check in your IF conditions.
Your code could be written more compactly like
FYI:
http://www.cybercash.com/company/press/releases/2001/01mar02network1restruct
ure.html
Regards,
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server
Get your free copy
Thanks for all the responses. I'll keep you posted. I guess as soon
as the gal at Microsoft can figure out how their licensing works
she'll let me know. For now though, according to the retailer that
supposedly sells Microsoft Commercial Internet Services licensed
products, they've never sold
A colleague in our CFUG told me about the MSDN Business Connection program.
After being accepted into that program (it's free to join), they offer
members a special Universal Sub annual price of $599 + tax. But this isn't
well publicized at the MSDN Business Connections site unless you log in
(aft
Are you trying to use a customtag or set up some application
management? I wondered why you would name your cfapplication
something like "custom tag name".
-Original Message-
From: Michael [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 12:59 PM
To: CF-Talk
Subject: Re: How turn o
A repost of my findings follows:
Regarding Licensing of SQL Server 2000, the Standard Edition of SQL Server
2000 (Part Number 228-00782) at a M$ retail cost of $665.00 is available
only via the Open License Program which says you must by at least five
products -- but the M$ sales guys said eve
I have a question about using cfcache with fusebox. If I have an action like
I want to use cfcache on Display_Schedule.cfm. The link would be listed as
index.cfm?action=ShowSchedule. If that is the case then the query would run.
Or would you put the cfcache tag in both templates?
Or is t
Jeanne, it looks like you don't have and "(" ")" around your second if case.
i think that will fix your problem.
else if (ctrl.value > 1) {
alert("Please enter a valid fleet size.");
david
-Original Message-
From: Jeanne Sarfaty Glazer [mailto:[EMAIL PROTECTE
I don't really know Javascript, but that's a really cute name! Jeanne heh
-Original Message-
From: Jeanne Sarfaty Glazer [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 1:10 PM
To: CF-Talk
Subject: (yet another) Javascript Question
Hi Folks,
If there's a more appropriate place t
Tried everything you said, and even asked another developer, and they said
it looked right to them also, but they didnt really have that much
experience in custom tags, so they didnt want me to base there words as
being something set in stone, if you know what I mean.
"Robert Long" <[EMAIL PROT
Hi Folks,
If there's a more appropriate place to ask this question, please let me know
- this list is so incredibly high volume,I'd hate to be erroneously
contributing to it when I should send my question elsewhere.
With that said:
I'm doing Javascript validation and having trouble getting the
ok here's MS pricing for MSDN with universal at $2,499. how can i get it for
$599? sorry if i missed the previous post.
http://msdn.microsoft.com/subscriptions/prodinfo/pricing.asp
--dylan
-Original Message-
From: Chris Montgomery [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001
You can get it for $599. I posted about that the other day.
Chris Montgomery [EMAIL PROTECTED]
Web Development & Consulting http://www.astutia.com
Allaire Consulting Partner
210-490-3249/888-745-7603Fax 210-490-4692
AIM: astutiaweb; ICQ: 7381282; Firetalk: Ag78
> -Origin
That's basically my point. I don't know if my dentist had a 4.0 gpa
or a 3.0. But he has the same certificate as the other guy.
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 11:37 AM
To: CF-Talk
Subject: RE: Allaire Cert Question
> > > Is t
I will give this a try
"Robert Long" <[EMAIL PROTECTED]> wrote in message
B1A5B5B556DBD31190F800508B55FD6C99FB5F@EXCHANGE01">news:B1A5B5B556DBD31190F800508B55FD6C99FB5F@EXCHANGE01...
> Michael,
> How do you know it's not on?
> If you set in the application.cfm
> and set other parame
We will be using Netscape 4.74
"DeVoil, Nick" wrote:
>
> The only issue is cross-browser compatibility, particularly if
> you have to support Netscape 4.
>
> Nick
>
> -Original Message-
> From: James Taavon [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 5:04 PM
> To: CF-Talk
> Anybody having issues with CF and DHTML? I am considering it for a new
> app that we will be developing. Purpose being to get around using frames
> since we can't.
CF=Server Side
DHTML=Client Side
Since CF sends text or images (depending on CFContent) to the browser, it
doesn't care what infor
Thanks to all who responded. Kevin and Bryan suggested using
sum(queryColumn) as xxx. However, I wanted to use this as an opportunity to
explore arrays, which I had not previously felt the need to use.
I found what I needed in ValueList and ListToArray. Three lines gives me
the desired results:
> Besides, the Allaire certification test just tests how well you can answer
> questions about CF. It doesn't test your aptitude for developing CF
> applications, that's for sure.
Also it's a test of what they want to hear, not real world
There are several questions where there are 2 or 3 real a
> > > Is there a difference (that can be seen by a third party)
> > > between an Allaire Certified Developer that passed the
> > > test and one that _aced_ the test?
> >
> > > Not that I have seen.
>
> I would think there is about as much difference as a
> doctor who simply passed and one who
The only issue is cross-browser compatibility, particularly if
you have to support Netscape 4.
Nick
-Original Message-
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 5:04 PM
To: CF-Talk
Subject: OT: DHTML
Anybody having issues with CF and DHTML? I am conside
> Anybody having issues with CF and DHTML? I am considering it
> for a new app that we will be developing. Purpose being to get
> around using frames since we can't.
We've used DHTML extensively, with no trouble. CF works with any client-side
browser technology.
Dave Watts, CTO, Fig Leaf Softw
> Anyone have any tutorials or explainations on how to do this
effectively???
>
There is a live example here.. depends on what you are trying to
accomplish...
http://cfhub.com/advanced/cfhttp/query.cfm
~~
Structure your ColdFusion code with Fu
Have you considered a "handler" page. Works like a frame; all your pages
feed into the main "handler"
We've had great success with it!
Alex
- Original Message -
From: "James Taavon" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 02, 2001 12:04 PM
Subject: OT:
Anybody having issues with CF and DHTML? I am considering it for a new
app that we will be developing. Purpose being to get around using frames
since we can't.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fu
> > To the best of my knowledge, you can't do this. What you can
> > do to get the same effect, though, is to execute a string
> > containing your SQL statement ...
> > ...
> > Of course, this isn't an optimal solution.
>
> Thanks! That's almost exactly what I was looking for. I'll
> try it to
Michael,
How do you know it's not on?
If you set in the application.cfm
and set other parameters such as clientmanagement="yes" and
sessionmanagement="yes"
then it should be turned on. You need to set some variables to know for
sure,
for example. In the application.cfm put
Then in the ind
Is it possible to use the new XML output in SQL Server 2000 in ColdFusion
with thing like this:
SELECT * FROM authors FOR XML auto
#something#
where "something" is the name of the "field" SQL server returns the XML in.
There's always just one field, and you can obviously ge
Can anyone who has been to several ColdFusion seminars recommend a
good one? I'm looking at "Best Practices with ColdFusion and Fusebox",
is this a good one? I tried searching the archives to see what
people were saying about it, but all I could find is Hal's
signature. >:|
Also considering cf_w
Stand back I have the power of certification at my
fingertips
Regards
Stew
(back from vacation)
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.co
I think Melissa nailed it. You need to supply some kind of address
in the link tag. Since the email client is not a browser, it needs
specific directions to the page you are linking to. So using
http://intranet/usercalldisplay.cfm or something like that will help
it find it's way to the page.
Hop
i.e. most of the people running such sites are not properly licensed because
Microsoft requires you go on a course and sit an exam to be Microsoft
Licensing Professional Certified.
ROFLMAO
^_^
*ahem*
sorry..returning you to regularly scheduled serious stuff now..
hee hee
-Gel
www.carigamer.com
I would think there is about as much difference as a
doctor who simply passed and one who _aced_ everything. :)
The use of a doctor for my example is a bit extreme, but
you get my point. hehe
-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01
Thanks for the help everyone, it worked perfect!
-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 5:05 PM
To: CF-Talk
Subject: RE: select records from table 1, that are not in table 2 ?
try this, but be prepared for a slow query if the rows
I don't think this possible in CF. The closest thing to it is using WDDX.
Check out http://www.wddx.org
-Original Message-
From: Richard L Smith [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 7:58 AM
To: CF-Talk
Subject: Using XML as datsource in CF
Hello,
Has anyone used C
Thanks! That's almost exactly what I was looking for. I'll try it today.
Why would it not be an optimal solution? Is it slower or can that function
only be used in certain situations?
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 5:38 PM
Occupational Therapist
-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 4:21 PM
To: CF-Talk
Subject: RE: What does OT mean?
OFF TOPIC! :)
> -Original Message-
> From: Paul Ihrig [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, March 01
It might be possible to do this via SQL with
SQL Server 2000 using the OPENXML function?
Nick
-Original Message-
From: Richard L Smith [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 12:58 PM
To: CF-Talk
Subject: Using XML as datsource in CF
Hello,
Has anyone used CFQUERY with
Not in Custom Tags. They run in their own space. Request, Session and
Application variables are passed through, but any other variables that you
pass as parameters must be referenced as Attributes.variable. Conversely if
you want to send something back to the calling template, you must user
Call
Try putting in the entire address without the href tag. For example:
http://www.yoursite.com/UserCallDisplay.cfm
If I understand the other responses to your question correctly, when Outlook sees the
http:// it will create a
link.
Melissa
"Gieseman, Athelene" wrote:
> OK, let me try to post
Possibly
At 08:23 PM 3/1/2001 -0800, you wrote:
>Is there a difference (that can be seen by a third party) between an Allaire
>Certified Developer that passed the test and one that _aced_ the test?
>
> jj
~~
Structure your ColdFusion code with
MSDN doesn't include commercial licensing, which is what he was looking for.
and universal is only $2,500.
-Original Message-
From: Martin Sutton [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 7:21 AM
To: CF-Talk
Subject: RE: M$ licensing has me at wits end
Go for MSDN, you ge
I neglected to mention that obviously it wouldn't solve your commercial
problems but it might save you money in the long term. Sorry I cannot say
more.
-
LEGAL DISCLAIMER --
This message and any attachments
Go for MSDN, you get all Microsoft software for in house use. I think its
$15k / year. Thats worth a look because you get all versions and all
updates of all their software.
I think thats right, my company is on MSDN and we get everything
---
I have started and stopped the services, the machine and nothing works. I
downloaded it off the developers exchange a few days ago, and tried it on
and off for several days.
I have followed the instructions on how to install the CFX_File tag, and as
far as I can tell, I have nothing in the setup
cfx_QueryColumns
http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347299-2830-11D4-AA
9700508B94F380&method=Full
That link was posted previously to a similar question... I haven't used it
and am not sure if it will help.
Stephen
-Original Message-
From: Boskovic, Ante [mailto:[
I submitted this again because im not sure that it went through the first time.
I'm back with another question ( imagine that :)
First i would like to say thanks to everyone that has helped me so far a lot of things
have worked great!
what i have is a form that has 6 selection box's (all multip
Besides form and url variables, what other variables could I pass them within
each browser instance? I want each browser instance has separate values of
the variables. For instance, there are browser A and browser B. A has
variables x=1 y=2 z=3. B has variables x=11 y=12 z=13. I want x, y, an
AAARRRGGGHH!
OK, so. I get my copy of SQL Server 2000 with the Processor license
thinking that's all I'm going to need. Open the box, read the
license. WHOOPS! No commercial hosting allowed under this license.
Seems it's only good for your own personal website. Great deal for
4,200.00.
So, n
That only happens for the most basic scopes. The behavior is a bit of a
vestigal tail... not supported for any new variable type.
variables.
form.
url.
I'm not surre about cookie. (I could do a quick test but I'm feeling an
attack of laziness coming on).
All others, assume NOT. Yet another r
Where do you do this? I have a seperate Application.cfm that has
and I still cant figure out why
this tag is not working, everything is in the proper directory.
TIA
Michael
~~
Structure your ColdFusion code with Fusebox. Get the official
Hi All,
Can anybody explain the cftransaction tag isolation parameter. As I dont
seem to be able to find any information other than very basic explinations.
What is happeing is if I place a Read_uncommited level on a DB Read, when I
update the same table I get a 'Cannot Update a table that is
Hello,
Has anyone used CFQUERY with XML documents as a datasource?
Is this even possible?
Rick
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-a
> Do something like this:
>
> error checking page.
>
>
>
>
>
Actually, Netscape will fail on the message, it should be
Personally I don't like or use CFLocation as it causes another CF request
when it's not needed
I tend to put a CFInclude in the template depending on the outcome of t
Do something like this:
error checking page.
Then on login page.
alert(#URL.strErrorMsg#);
That should do the trick !
~~
Structure your ColdFusion code with Fu
Why not use the Login Page to validate the User?
Jason Lees
National Express
Email : [EMAIL PROTECTED]
-Original Message-
From: Hubert Earl [mailto:[EMAIL PROTECTED]]
Sent: 02 March 2001 10:55
To: CF-Talk
Subject: Problem with login code
Hi everyone,
The code below is a loginaction
Are you passing the variable back to the Login.cfm form?
On the Login.cfm page are you displaying the ERRORMESSAGE?
You should pass it back to the template and check
for its existence and if exists display the message
-Original Message-
From: Hubert Earl [mailto:[EMAIL PROTECTED]]
Sent
Hi everyone,
The code below is a loginaction template. It's supposed to give an error
message if the wrong id or password is given on a login form, or if either
or both aren't given. Instead, it only gives the message if something is
missing. If something is wrong, it simply sends the user bac
The problem I get is with this code:
The flash movie pulls in the var "menutxt" from menu.cfm the code in
menu.cfm is:
SELECT X, Y, X_url, Y_url FROM
X_table ORDER BY X
MenuText= #X#
The output "part" works as I get the value X outputted as a link, but after
the first row I get
MenuText
Does it output in order when you just view the cf page? Could it be
something to do with the link into excel. Perhaps it has trouble with some
data types.
-Original Message-
From: Winston Sia [mailto:[EMAIL PROTECTED]]
Sent: 02 March 2001 07:33
To: CF-Talk
Subject: cfquery table data with
Go to the admin WWW page, advanced section. Tick the first box.
Go to userdirectorys, and create a new one with namespace=Windows NT, and
location = name of the domain.
Then its just ya standard rules and users (I use the resource view,
resources button on main advanced page).
The Allaire whitepap
> Is there a difference (that can be seen by a third party) between
> an Allaire Certified Developer that passed the test and one that
> _aced_ the test?
That smug air that they exude?
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites
Ah ha !
Cheers muchly :-)
I though CF would automagicly try attributes.,cookies., etc. if you just
gave it a variable name ?
-Original Message-
From: Sandra Clark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 5:19 PM
To: CF-Talk
Subject: RE: cfmodule oddness
Are you using At
91 matches
Mail list logo