Dbfield=
Steve
-Original Message-
From: Robert Harrison [mailto:rharri...@aimg.com]
Sent: Friday, April 17, 2015 3:58 PM
To: cf-talk
Subject: SQL Server and Nulls
In an update query, to a tinyint field which allows nulls, I have the update
dbfield=#mydatefield#
If mydatefield has no
dbfield =
On Fri, Apr 17, 2015 at 3:58 PM, Robert Harrison wrote:
>
> In an update query, to a tinyint field which allows nulls, I have the
> update
>
> dbfield=#mydatefield#
>
> If mydatefield has no value, sql is throwing an error. The field allows
> nulls. I've never had to say if "" then N
I find this intriguing as well. Almost like a poor mans historical
archive system.
A generator for the triggers would be cool also based on Illidium PU-36
--
Dan O'Keefe
On Fri, Jul 30, 2010 at 9:08 AM, Pete Ruckelshaus
wrote:
>
> Feel free to pass on any enhancements or improveme
Feel free to pass on any enhancements or improvements!
On Fri, Jul 30, 2010 at 11:02 AM, Robert Harrison <
rob...@austin-williams.com> wrote:
>
> Very nice! Thanks for sharing that. Think I'll play with it a bit as well.
>
>
> Robert B. Harrison
> Director of Interactive Services
> Austin & Will
Very nice! Thanks for sharing that. Think I'll play with it a bit as well.
Robert B. Harrison
Director of Interactive Services
Austin & Williams
125 Kennedy Drive, Suite 100
Hauppauge NY 11788
P : 631.231.6600 Ext. 119
F : 631.434.7022
http://www.austin-williams.com
Great advertising can't b
Steve, to keep things simple(r), I would store that info at the source table
level. Since it's a web site, there's a single generic user account at the
database level, but I do track user and IP at the CF application level in
the table that specific data is stored...it's just not shown in the tbl
Pete,
This is awesome! I'm going to consider using it for certain tables that
we have problems with. I might suggest that you add in the user name
and/or ip that made the change. That can help if you need to find out
who made specific changes!
Thanks,
Steve
-Original Message-
From: Pe
>> hardware improvement options and need to quantify
>> (as much as possible) performance increases
In my limited experience with MSSQL the best investment is improved Hard
drive speed and/or throughput and increased memory. They are usually the
bottlenecks.
Dennis Powers
UXB Internet - A Webs
>
> 3) When I do a CFQuery, it won't work unless I write the table name as
> "canadianofficespacecom.city", instead of just "city".
>
Is the database specified in the DSN?
Sounds as if one isn't specified.
Ricardo.
~|
Want
On Fri, Dec 11, 2009 at 2:53 PM, Larry Soo wrote:
> So would I be correct in assuming that
> the problem I'm having is that the default schema for "dbo" is "master"
> instead of "canadianofficespacecom"?
I believe so, yes. In order to resolve this from the user side of
things you're going to nee
Recap of problem: I imported an old, backed up SQL Server file. Now, when
I view the tables or try to access them in CF, it requires me to prefix all
table names with "canadianofficespacecom.".
Ezra Parker wrote:
> I didn't see a mention of which version of SQL Server you're running,
> but it
.microsoft.com/en-us/library/aa275462%28SQL.80%29.aspx
~Brad
Original Message --------
Subject: re: SQL Server question re table names - still stuck
From: "Larry Soo"
Date: Fri, December 11, 2009 3:07 am
To: cf-talk
> How many tables are there? If there are under 75, you migh
> but it sounds to me like canadianofficespacecom is either
> an object
> owner or a schema:
+1
That would make more sense than being part of the actual table name.
~|
Want to reach the ColdFusion community with someth
I didn't see a mention of which version of SQL Server you're running,
but it sounds to me like canadianofficespacecom is either an object
owner or a schema:
http://www.sqlteam.com/article/understanding-the-difference-between-owners-and-schemas-in-sql-server
I'm assuming that it's most likely SQL
I wrote:
> > A client asked me to see if I could get a copy of his old web site up
and
> > running. I did a restore of the backed up database onto my PC. The
> > problem is that all the table names have the name of the database
prepended
> > to them.
> >
> > When I view the tables in SQL Ser
I have only seen that with exports from MS Access.
Yes, +1 about using the information INFORMATION_SCHEMA views. Tapping into the
system views is my favorite way to generate mass statements on-the-fly ;-)
DECLARE @DBPrefix VARCHAR(50)
SET @DBPrefix = 'oldabc.'
SELECT 'exec sp_rename @objname
I can't say I've ever seen that one before, but you could just do a loop
over the contents of INFORMATION_SCHEMA.TABLES and build/exec an ALTER
statement for each one.
http://technet.microsoft.com/en-us/library/ms190273.aspx
How many tables are there? If there are under 75, you might be just as
"I have maintain connections selected."
Did you check that setting on all data sources for both CF Servers. Are
you storing client vars in via a datasource?
Run a trace on the SQL server to see what sort of operations are being
performed-- especially by new connections.
~Brad
~~
Thanks to everyone for their help with this!
Will
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://ww
Original Message
Subject: Re: SQL server - Order totals by month, even without month
data
From: Greg Morphis
Date: Wed, March 25, 2009 7:26 am
To: cf-talk
Create a dummy table with the information for the current year and
preform a UNION to your existing data
On Wed, Mar 25, 2009 at 6:26
Create a dummy table with the information for the current year and
preform a UNION to your existing data
On Wed, Mar 25, 2009 at 6:26 AM, Will Tomlinson wrote:
>
> I have your typical tblorders. I'm trying to query it to get order totals by
> month, and I'm outputting them in
>
> All goes fine
when i had to do a similar thing, this is how i did it:
your query returns monthName and totalOrders columns.
create a structure from your query with Month as key and Total as value:
create a list of month names in the format returned by your query:
create a new query you will use for you
posted a reply hours ago, but it still hasn't showed up... reposting...
when i had to do a similar thing, this is how i did it:
your query returns monthName and totalOrders columns.
create a structure from your query with Month as key and Total as value:
create a list of month names in the
There are 2 ways that come to mind right off the bat.
1. Create another table that has each month in it. Do an outer join that
allows the other table to return 0 for the months where you have no records
in your original table
2. Inspect the query in CF for missing months. If there are any miss
The only way to get data into a query is to have data in a table. So there are
a couple of options.
1. Create a months table that has 12 records
2. Create a temp table with 12 records
You may also need to create a years table as well.
Then your query would be something like
SELECT year, mo
Hello Will,
I'd advise building yourself a calendar table, these are always a useful
facility in any application where you're going to be doing report
generation, I've attached the SQL script which creates and populates your
calendar table, this basically creates a record for each date in a range
Create a calendar table. Load it with dates from 1900-2100. Each
record relates to a single day. You can join to this table in many
ways. Here is an example of one of my records...
date
1900-01-01 00:00:00.000
dayOfWeek
2
dayOfWeekName
Monday
day
1
dayLeadingZero
01
month
1
monthLeading
Also, since you are using SQL, you can use a CTE to dynamically generate
a date range as a temp table, so to speak. I prefer a regular table as
I mentioned in my last reply, however.
Thanks,
Mike
-Original Message-
From: Will Tomlinson [mailto:w...@wtomlinson.com]
Sent: Wednesday, Marc
For those who are interested this was solved at:
http://forums.newatlanta.com/messages.cfm?threadid=D0F5E9DE-C84B-43EC-8C34667F8FB9077B
Thanks to those who helped!
Stan
~|
Adobe® ColdFusion® 8 software 8 is the most important
I checked that TCP/IP is enabled and it was. I found an article that talked
about making sure SQL Server 2000 was at least sp3a, so I updated to sp4.
Now CF8 on a remote box verifies the connection, but BD7 does not (BD7 is on
the same box as CF8). I get the error:
"Login failed for user '[us
Is TCP/IP enabled on your SQL 2005 instance? By default, TCP/IP connections
are disabled in SQL 2005.
- Pat
-Original Message-
From: Brad Wood [mailto:b...@bradwood.com]
Sent: Tuesday, February 17, 2009 10:32 PM
To: cf-talk
Subject: Re: SQL Server 2005 Datasource failing
What port
What port is SQL Server 2005 listening on?
Also, can you connect using the same password in Enterprise Manager?
Run a trace on the 2005 database and include failed login events from the
audit group. Can you see the login failures coming through. If not, CF
isn't hitting the correct SQL instan
Thanx Jim. Awesome resource!!
~G~
On Wed, Oct 8, 2008 at 7:19 PM, Jim Davis <[EMAIL PROTECTED]>wrote:
> > -Original Message-
> > From: Gerald Guido [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, October 08, 2008 6:19 PM
> > To: cf-talk
> > Subjec
> -Original Message-
> From: Gerald Guido [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 08, 2008 6:19 PM
> To: cf-talk
> Subject: Re: SQL Server on development box?
>
> >> absolute best-of-breed management tools
>
> The only issue I really had
>> absolute best-of-breed management tools
The only issue I really had with the express MSSQL Management Studio is the
lack of import/export functionality. If you have a license for MSSQL 2005
you should be able to install the Management Studio that came with the
server.
On Wed, Oct 8, 2008 at 4
> -Original Message-
> From: RobG [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 08, 2008 12:15 PM
> To: cf-talk
> Subject: Re: SQL Server on development box?
>
> I thought MSSQL Express (developer) edition was free?
>
> Rob
I second this - the Express
There is an express version of Management Studio you can use for free.
The biggest limitation to me was that you can't have a database larger
than 4 Gigs. If you have a larger database, fork over the 50 bucks.
~Brad
Original Message
Subject: Re: SQL Server on developmen
They have an Express version. I just set it up.
http://www.microsoft.com/sql/editions/express/default.mspx
If you need Full text search get the Express Edition with Advanced Services.
Here is the run down on features
http://www.microsoft.com/sql/editions/express/comparison.mspx
G
On Wed, Oct 8
If you want to use their tools, yes. You also use squirrel as a query editor.
It is a free java based editor that works with any db platform that has a jdbc
driver.
~|
Adobe® ColdFusion® 8 software 8 is the most important and d
I thought MSSQL Express (developer) edition was free?
Rob
On Wed, Oct 8, 2008 at 9:05 AM, Billy Cox <[EMAIL PROTECTED]> wrote:
> I recently moved our sites to a new server running CF8 and SQL 2005
> Standard. Do I have to buy the 'Developer Edition' of SQL 2005 for my
> development box or is the
Well I got this up and running through ODBC but unforunately when I did
Transfer ORM, which I'm using to manage my DAO, throws an error message.
How do permissions work in SQL Server in terms of CF. From what I can all I
need is the datawriter and datareader roles applied to that user. This is w
Ben,
Search House of fusion for a recent thread on query optimization as well...
There was an interesting issue with a stored proc taking too long and it
turned out to be permissions on the database (made me go hm.)
-mark
-Original Message-
From: Ben Mueller [mailto:[EMAIL PROT
Okay, that's kind of what I thought. I think the SequeLink thing is what I was
thinking of wrt to the ODBC driver. Thanks, Dave.
>ColdFusion only supports JDBC, so you'll be using JDBC. You can either use a
>"pure Java" JDBC driver, or you can connect to ODBC datasources using
>SequeLink as a J
> We're running CFMX7 and SQL Server 2000 in Windows2003
> Server. I know there are a variety of ways that one can get
> CF to talk to a SQL Server box: ODBC, JDBC, Named Pipes, and
> so on. I don't even pretend to know what all of that really
> means. The question is what's the best practic
> Hopefully this is not off topic. We have a lot of CF sites
> running our software that use SQL 2000. We are going to be
> moving to SQL 2005 and are doing research on the licensing
> options. It seems that there is a "Standard" license and a
> "Workgroup" license of SQL 2005. For the purp
Dave,
Thanks for responding on this. After almost six hours on the phone with
MS, it looks like the best guess option is to restart services. Since
the release of MS SQL 2000 their support has received one call for this
issue, so they aren't really sure. We'll find out in another twenty min
wh
> Currently we utilize MS SQL 2000 with multiple databases. One
> of our CF servers (one of the 6.1 boxes) recycled it's cached
> ds connections and was no longer able to authenticate to the
> db's. We were also no longer able to connect via Enterprise
> Manager, receiving the (essentially) sam
> (CONVERT(varchar, dbo.tblUserTransactionLog.Processed, 101) >=
> \'08/01/2007\') AND
Yes, that works but could hinder indexes. Josh is correct about date
comparisons. If you want all records with a _date_ of 08/01/2007 a better way
to write that query is:
--- Notice the less than < 08/02/
Ah Ha! I figured out the problem with the query. This following seems to work
as expected:
SELECT
dbo.tblSubscribers.SID,
dbo.tblSubscribers.Username,
max(dbo.tblUserTransactionLog.Processed) AS LastTransaction
FROM
dbo.tblSubscribers,
dbo.tblUserTransactionLog
WHERE
han
'2007-08-02', so that won't be picked up by less than or equal to.
-- Josh
- Original Message -
From: "C. W. B." <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Wednesday, August 08, 2007 5:37 PM
Subject: Re: SQL Server problem getting records within
Hello again Janet...
I am so sorry to be bugging you again on this, but I am having trouble with
this new query - not doubt it's something I just don't understand.
If I set the dates in this query to 08/01/2007 and 08/02/2007 I only get
results from 08/01/2007. And, if I have them both set to
Hello again Janet, thank you for your help on this. It suare has had me
stumped.
So, like this?
SELECT
dbo.tblSubscribers.SID,
dbo.tblSubscribers.Username,
max(dbo.tblUserTransactionLog.Processed) AS LastTransaction
FROM
dbo.tblSubscribers,
dbo.tblUserTransactionLog
WH
Yes, that looks correct.
~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive:
http://www.houseoffusion.com/groups/CF-Tal
> I should have mentioned that I need to get only the most recent
> transaction for each user within the given time-frame. That's why I
> am using max(). Using this aggregate function, I think, requires I
> use "having," no?.
No, if I'm understanding correctly its not required here. The WHER
Hello Janet - thanks for the reply.
I should have mentioned that I need to get only the most recent transaction for
each user within the given time-frame. That's why I am using max(). Using
this aggregate function, I think, requires I use "having," no?.
Thanks, CWB
>Use the WHERE not HAVING
Use the WHERE not HAVING clause. Try something like
SELECT ...
FROM ...
WHERE dbo.tblSubscribers.SID = dbo.tblUserTransactionLog.SID
ANDdbo.tblUserTransactionLog.Processed >= convert(datetime, '08/01/2007',
101)
AND dbo.tblUserTransactionLog.Processed <= convert(datetime, '08/07/2007',
> You are correct sir! Thank you. I do have a follow up
> question, however. I'm curious - the password I was trying to
> use that was being rejected was a GUID created using
> CreateUUID(). Should/can such identifiers not be used as
> passwords in the CF Administrator? My thought was that you
>> I have a SQL Server database and I want to make it accessible
>
>I'll bet you actually have the incorrect password. There's nothing special
>you have to to create logins that you can use from CF. Try changing the
>password.
>
>Dave
You are correct sir! Thank you. I do have a follow up questio
> I have a SQL Server database and I want to make it accessible
> to CF. I can connect successfully to the datasource in CFIDE
> using the sa account, but I cannot do the same using a New
> Login with SQL Server Authentication. The error I receive is
> "Login failed for user 'theuser'" which is
To answer my own question:
http://support.microsoft.com/default.aspx/kb/914278
"Microsoft SQL Server 2005 Express Edition can only use one CPU, even if
the computer has more than one CPU."
So it can be installed on a multi-CPU machine, it'll just limit how it
works. Perfect.
Damien McKenna
Web D
Thanks - let me try that - a lot cleaner than I thought it would be.
~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR
Andrew Peterson wrote:
> Hi,
>
> I'd like to see how this is done, even though it is not necessary and I like
> my ColdFusion thank you very much. Can someone give me a general idea of how
> this code would look in SQL Server? It takes literally 5 minutes to write in
> CF; but for me to put it
Is it MS SQL 200 or MS SQL 2005?
If 2005, the tcp/ip port 1433 is not switched on by default.
On 3/9/07, Paul Dormody <[EMAIL PROTECTED]> wrote:
>
> I have looked at the Adobe help files and Forta's blog about setting up
> a MS SQL datasource in CF MX 7. I have followed all of the suggestions
>
> Long Text Buffer - The default buffer size, used if Enable Long Text
> Retrieval(CLOB) is not selected. The default value is 64000 bytes.
Oh, 64,000 chars should be plenty. Thanks guys.
--
My Sites:
http://www.techfeed.net/blog/
http://www.cfquickdocs.com/
http://cfformprotect.riaforge.org/
> A co-worker of mine just told me that in order to use the
> text data type in SQL Server, you have to enable CLOB and
> BLOB in the data source in CFAdmin. Is this true? I need to
> use the text data type because my users potentially could
> enter a large amount of text (> 8000 chars).
Str
You don't have to enable clob to use text or ntext data types but if you
don't then CF will crop any input to those fields that exceeds a certain
length. I can't remember what the length is that CF crops at but I have
experienced this. Not sure about blob.
- Original Message -
From: "
I'm not an expert, but I've been using 'text' and/or 'ntext' in SQL Server
for years and have never done that, so I'm going to say no, that's not true.
Matt
A co-worker of mine just told me that in order to use the text data
> type in SQL Server, you have to enable CLOB and BLOB in the data
> s
I'm sure our dba has this done already. Thanks for pointing it out though/
-Original Message-
From: James Smith [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 24, 2007 5:08 AM
To: CF-Talk
Subject: RE: SQL Server, querying between two DBs
> Our dba finally got out of his
> Our dba finally got out of his meeting. Turns out that not
> only are they separate databases, but they're also on a
> different server.
>
> So it's [server_name].databasename.dbo.tablename.
This will work fine but remember to set up "linked servers" in Enterprise
Manager or the cross-server
lto:[EMAIL PROTECTED]
Sent: Tuesday, January 23, 2007 3:35 PM
To: CF-Talk
Subject: Re: SQL Server, querying between two DBs
Andy Matthews wrote:
> I've got two DBs showing up in Enterprise Manager. I need to query
> against both of them. In MySQL you can do this by simply prepending
Andy Matthews wrote:
> I've got two DBs showing up in Enterprise Manager. I need to query against
> both of them. In MySQL you can do this by simply prepending the db name to
> the tablename like so:
>
> SELECT t1.id
> FROM db1.t1 t1
> INNER JOIN db2.t1 t2
> ON t1.id = t2.fkID
>
Assuming t
> I've got two DBs showing up in Enterprise Manager. I need to
> query against both of them. In MySQL you can do this by
> simply prepending the db name to the tablename like so:
>
> SELECT t1.id
> FROM db1.t1 t1
> INNER JOIN db2.t1 t2
> ON t1.id = t2.fkID
>
> How would you do this in Ent
You use Query Analyser, Tools > Query Analyser (in SQL 2000). New Query in
2005.
..
"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains information wh
Is this a one off import? If yes, I've never had a problem pasting excel into
access. From there it should be easier to import into sql server.
~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create pow
I ran into this last year, but I forgot the exact cure. Try changing
your ntext field to a varchar large enough to hold your text. Then,
once imported, change the varchar back to ntext.
If that doesn't work, save the spreadsheet as a delimited text file and
then import that.
I believe the probl
Thanks,
George
On 1/9/07, Richard Kroll <[EMAIL PROTECTED]> wrote:
>
> The drivers we used are located at http://jtds.sourceforge.net/
>
> Rich Kroll
>
>
~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusio
The drivers we used are located at http://jtds.sourceforge.net/
Rich Kroll
> -Original Message-
> From: George Abraham [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 09, 2007 10:02 AM
> To: CF-Talk
> Subject: Re: SQL Server Error 8179: Could not find prepared statemen
Hmm, we did have other problems with the current drivers we are using that
was shipped with the product by (then) Macromedia. Mayve we can look at this
driver you mention.
Thanks,
George
On 1/9/07, Richard Kroll <[EMAIL PROTECTED]> wrote:
>
> George,
> We ran into the same problem a few months ag
George,
We ran into the same problem a few months ago. What we found was the
error was thrown on random queries that had CFQUERYPARAMs in them (which
was almost every query in our application). Somewhere on the net I
found an article explaining that it had something to do with the
drivers. We s
thanks guys!!
Will
~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
Hi Will,
Set the identity seed to 1000 in enterprise manager.
--
Pete Freitag
http://foundeo.com/ - ColdFusion Consulting & Products
http://petefreitag.com/ - My Blog
http://spendfish.com/ - Fish for Deals
On 1/3/07, Will Tomlinson <[EMAIL PROTECTED]> wrote:
> I've decided to change an orderID
In SQL Server, open the table in Design mode, select the field and set
it to
Identity and set the SEED to 1000.
-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 03, 2007 7:58 AM
To: CF-Talk
Subject: SQL Server - starting integer at 1000
I've
Tim Claremont wrote:
> I am running CFMX 7.1 on Win2k3 Server with SQL Server 2005
CF MX 7.0 or CF MX 6.1?
> I just installed SQL Server 2005, and I am unable to connect to it
> with the JDBC Driver. I have downloaded the driver from MS, and
> followed the instructions in the CF TechNote on th
> > Some of my frustrations with MySQL are:
> > - Only 1 query per
>
> I happen to think that is a good thing :)
Sorry, I have to jump in here. I agree with this, it is a good thing.
They don't allow multiple queries because to do so is a security risk.
But I always laugh because whenever I bri
> Some of my frustrations with MySQL are:
> - Only 1 query per
MySQL can handle multiple queries, it's just disabled by default. Cameron
Childress has a post about this.
MySQL: How to Combine Multiple SQL Statements in One CFQUERY
http://www.sumoc.com/blog/index.cfm?mode=entry&entry=7F6F7314-50
Matthew Chambers wrote:
>
> Some of my frustrations with MySQL are:
> - Only 1 query per
I happen to think that is a good thing :)
> - Unable to handle complex join queries e.g. I ran a complex query in
> a trail version of SQL Server 2000 and it returned in 3 seconds, it
> took 33 mins in M
To cut your cost for SQL Server find an SPLA partner and pay $10 month
instead.
Russ
-Original Message-
From: Matthew Chambers [mailto:[EMAIL PROTECTED]
Sent: 12 November 2006 23:57
To: CF-Talk
Subject: SQL Server 2005 vs MySQL 5?
Hi,
I've been working on a website built using MySQL a
It mainly shows a way to make your code more compact and reading stuff from
a properties file and using that infomation in your JDBC connection. Does
SQL server send out information when it restarts?
If isClosed() is YES sever is down and another check or ping isClosed() No
means it's back.
~
Hi Dan,
I'm confused, how is this code intended to work? Does it keep the connection
with the new principle? What is the server was restarted.
blists
-Original Message-
From: Dan Plesse [mailto:[EMAIL PROTECTED]
Sent: October 7, 2006 11:36 PM
To: CF-Talk
Subject: Re: SQl Server 2
And finally if isClosed() equals YES then its closed and a NO means its
open.
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered
I think this is it.
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.co
You can also use java util props and keep shrinking the code until you get
one line.
Like the CF classLoader, one line is all you need!
It would interesting if you load these lines into CF from a props file.
Call it sql_server.properties
ion()#
Database Name:#DatabaseMetaData.getDatabaseProductName()#
Database Version: #DatabaseMetaData.getDatabaseProductVersion()#
-Original Message-
From: blists [mailto:[EMAIL PROTECTED]
Sent: October 5, 2006 12:05 PM
To: CF-Talk
Subject: RE: SQl Server 2005 w/ Mirroring. How does CF know when t
PM
To: CF-Talk
Subject: RE: SQl Server 2005 w/ Mirroring. How does CF know when to 'failo
ver' to the mirror?
> I am just doing some research into this. With SQL Server 2005
> and mirroring, the mirror will automatically take over if the
> primary/principle server fai
> I am just doing some research into this. With SQL Server 2005
> and mirroring, the mirror will automatically take over if the
> primary/principle server fails. But if you the datasource
> references the principle SQL Servers name, and that server
> was down, how would it failover?
>
> The on
JediHomer wrote:
> As far as can remember, if you use the short hand for outer joins... e.g.
>
> select *
> from member, payment
> where member.id *= payment.member_id
>
> Aren't supported by default, you have to change something on the server...
>
> I believe this is blogged on Ben Forta's Blog
:54 AM
To: CF-Talk
Subject: Re: SQL Server 2005
Steve LaBadie wrote:
> I have upgraded my web server from Access to SQL Server. Is there a
GUI
> interface for creating tables and database similar to Access?
>
In addition to Management Studio, you can use Access to manage a SQL
databa
Express Edition is a different tool. You don't need it if you have the full
standard version
-Original Message-
From: Steve LaBadie [mailto:[EMAIL PROTECTED]
Sent: 21 September 2006 16:54
To: CF-Talk
Subject: RE: SQL Server 2005
I did install Management Studio, so I assume I d
://www.esu.edu
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: Thursday, September 21, 2006 11:46 AM
To: CF-Talk
Subject: RE: SQL Server 2005
If you have standard you will have SQL Server Management Studio if you
chose
to install it!
-Original Message
Steve LaBadie wrote:
> I have upgraded my web server from Access to SQL Server. Is there a GUI
> interface for creating tables and database similar to Access?
>
In addition to Management Studio, you can use Access to manage a SQL
database fairly effectively...create a new Access Project and poi
1 - 100 of 804 matches
Mail list logo
