> Does anyone have any Coldfusion code to insert a new
> autoincrement key field in to a MS SQL table and then
> remove the old one? Or is there a way to modify a key
> field to autoincrement?
If you're just running into occasional collisions, you could use
with an exclus
Hi Dawn,
This is something which should be handled by the database. In a database
where you have auto incrementing the primary keys it shouldn't be the
applications responsibility to keep an eye on that, you should be doing
simple INSERT statements and allowing the DB to do the work.
In
em is to recreate the
autoincrment
key fields somehow.
Does anyone have any Coldfusion code to insert a new autoincrement key field in
to a MS SQL table and then remove the old one? Or is there a way to modify a
key
field to autoincre
From: Ian Skinner [mailto:h...@ilsweb.com]
Sent: 23 April 2009 16:25
To: cf-talk
Subject: Re: YIKES! I must let internet users write SQL queries for our
database!
Robert Rawlins - Think Blue wrote:
> Hey Ian,
>
> My first thoughts on this would be to ensure that YOU keep total control
>
Robert Rawlins - Think Blue wrote:
> Hey Ian,
>
> My first thoughts on this would be to ensure that YOU keep total control
> over the actually SQL that is being run, if you're working with large sets
> of data (more than a few GB) than the performance problems which arise f
INs
2. The flex/AJAX query builder idea is a nice one, you could also
provide a drop-down driven query builder and let it dynamically build
the SQL statement for the user, then give the user the ability to edit
the SQL.
Since you're running off a replicated database the need for heavy
regex
Ian Skinner wrote:
> Did I get your attention? Luckily these are read-only queries, but still!
I forgot to mention an important consideration is to somehow control and
mitigate query requests so that users don't tie up the database with a
task taking hours and hours to process.
It is already a
Hey Ian,
My first thoughts on this would be to ensure that YOU keep total control
over the actually SQL that is being run, if you're working with large sets
of data (more than a few GB) than the performance problems which arise from
poorly written SQL could likely cause you all kinds of
Rob Parkhill wrote:
> What about creating a Flex based tool...
That has potential. The current tool is simple HTML forms that attempt
to do what you describe, but does not flow very well as it currently exists.
~|
Adobe® ColdF
Ian,
What about creating a Flex based tool that allows users to choose the table
they want to get the data from and then the columns for the table (that you
wanted to be able to select by) would be available. Basically making a
'drag and drop' kinda query builder. where the users don't type anyt
Did I get your attention? Luckily these are read-only queries, but still!
I have a meeting this afternoon to discuss reworking/developing an
interface to allow anonymous, anybody in the world, users to develop add
hock queries on a respectably large database. This database gets about
2.5 mill
Hi All,
SQL Server locks seem to cause problems that result in processes remaining
blocked until something intervenes in two cases: circular dependencies
between processes and application or when a query is cancelled but the lock
isn't released.
My question pertains to the latter. Has a
wrote. If you go to the MSDN page:
http://msdn.microsoft.com/en-us/library/ms189885(SQL.90).aspx
And look down for "C. Generating a value list using PATH mode" it
shows their example.
The only real difference is that they were using AS "data()" which I
am not familiar wi
I don't know about the data function. I try to avoid SQL Server when
I can. ;) We use it for some projects with MySQL's query language
wasn't rich enough to express certain types of queries, but in general
I use MySQL when possible.
Did they have an example of a query equivale
data(). I'm not familiar with the data() function and why
they would use it but your query doesn't Would you mind elaborating?
And for those interested in what I'm talking about his Barney's use of
FOR XML PATH, the msdn reference is here:
http://msdn.microsoft.com/en-us/library/ms18
Here you go. Note that they're not really semantically equivalent,
they just happen to return the same results. The approach for
obtaining the result is completely different, and the MS SQL one,
while less direct for the actual comma separate list creation, is far
more expressive for
sion's valuelist method.
> Very
> > nice indeed!
> >
> > -Original Message-
> > From: Richard White [mailto:rich...@j7is.co.uk]
> > Sent: Tuesday, April 14, 2009 2:59 PM
> > To: cf-talk
> > Subject: Re: expert sql challenge
> >
&g
> Sent: Tuesday, April 14, 2009 2:59 PM
> To: cf-talk
> Subject: Re: expert sql challenge
>
>
> thanks for all your replies.
>
> barney, yes we are using mysql and didnt even know about the qroup_concat.
> it works like a dream and where this task was taking 23
Nice. So group_concat works sort of like ColdFusion's valuelist method. Very
nice indeed!
-Original Message-
From: Richard White [mailto:rich...@j7is.co.uk]
Sent: Tuesday, April 14, 2009 2:59 PM
To: cf-talk
Subject: Re: expert sql challenge
thanks for all your replies.
barney
DB are you using? If it's MySQL, you can use this:
>
>select client.name, group_concat(clientphone.number) as phone numbers
>from client
> left outer join clientphone on client.id = clientphone.clientId
>group by client.name
>
>If it's MS SQL Server you can use a sub
or example, this is the output query that we need
> client details | telephone numbers
>
> mr client 1 | 123456789,234567891,21342
> mr client 2 | 583736245,828262u82
>
> we have no idea if there is a way to ask SQL to combine the one to many
>
Have you looked into StoredProcs? Push the load off the web server onto the
SQL Server (or Oracle whichever)
On Tue, Apr 14, 2009 at 3:38 PM, Richard White wrote:
>
> Hi
>
> we have a relational database and one task is taking far too long but we
> cannot see any way to impro
ut query that we need
> client details | telephone numbers
>
> mr client 1| 123456789,234567891,21342
> mr client 2 | 583736245,828262u82
>
> we have no idea if there is a way to ask SQL to combine the one to many
> telephone numbers into one c
What DB are you using? If it's MySQL, you can use this:
select client.name, group_concat(clientphone.number) as phone numbers
from client
left outer join clientphone on client.id = clientphone.clientId
group by client.name
If it's MS SQL Server you can use a subquery with FOR XM
the output query that we need
client details | telephone numbers
mr client 1| 123456789,234567891,21342
mr client 2| 583736245,828262u82
we have no idea if there is a way to ask SQL to combine the one to many
telephone numbers into one cell and seperate them
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
Thank you all for your bits on Vista.
FYI, to those who have to deal with sql server 2005 express, a few days ago, XP
SP3 had a serious problem with installing this sql server package due to the
MSXML6.0 SP2 bugs.
Don
>Windows_NT
>
>I'm running Vista Home Premium
>
&g
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
missing
months, then create a new query using QueryNew to hold the old query, plus
the new rows of months that have a 0 in them.
William
-Original Message-
From: Will Tomlinson [mailto:w...@wtomlinson.com]
Sent: Wednesday, March 25, 2009 4:26 AM
To: cf-talk
Subject: SQL server - Order totals
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
-talk
Subject: SQL server - Order totals by month, even without month data
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, except in 2009. We have no order data for April-December
of course, so the query re
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
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, except in 2009. We have no order data for April-December of
course, so the query returns just three rows (Jan, Feb, March).
I need it to return all 12 months, with 0
worked for me. Plus, that is what Adobe shows in their docs.
2009/3/16 Jason Fisher :
>
> Interesting ... COUNT(DISTINCT prodcode) will work, huh? That may come in
> handy some day. Thanks!
>
>
>
>
~|
Adobe® ColdFusion® 8 so
COUNT(DISTINCT [fieldName] is very important to remember when using JOINS. For
example, if you have the query...
SELECT COUNT(A.code) AS total
FROM TableA A INNER JOIN TableB ON A.code = B.code
And you wanted to know how many records in TableA have records in TableB.
If this query returns 10
Interesting ... COUNT(DISTINCT prodcode) will work, huh? That may come in
handy some day. Thanks!
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doublecli
Thanks. I found it finally.
The right syntax (for this issue) is select count(distinct prodcode) as prodcnt
There was a second issue with computed_field_1 the was being bounced
by the ODBC driver as well.
On Mon, Mar 16, 2009 at 3:54 PM, Jason Fisher wrote:
>
> This is invalid:
>
> distinct(
This is invalid:
distinct(count prodcode)
Are you trying to do a DISTINCT on the aggregate function COUNT()?
Not sure that would work, but it would have to be DISTINCT COUNT(prodcode)
if that's what you're after.
~|
Adobe
Can anyone point me to the error in this code and the generated query?
I am kind of stuck right now as it all looks ok to me.
Thanks
--S
^
[Macromedia][SequeLink JDBC Driver][ODBC Socket][DataDirect][ODBC
Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL
statement at or
the generated query?
> I am kind of stuck right now as it all looks ok to me.
>
> Thanks
> --S
> ^
>
>
> [Macromedia][SequeLink JDBC Driver][ODBC Socket][DataDirect][ODBC
> Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL
> statement at or about "
Hey Jeanmarie,
I have always used OpenQuery() for my linked server connections.
SELECT *
FROM
openquery([connectionname], '[query]')
The cool thing about this is that you can bring everything from the access
dB to the SQL server for joining.
Example might be...
SEL
Hi --
I am quering against a linked server (access2007) via SQL 2005. When I first
started working on this I wrote all of my CF queries against a local copy of
the Access2007 database. Each query works fine. Now that I am migrating my
code to query against this linked server, queries that
On Wed, Mar 11, 2009 at 3:01 AM, Rick Root wrote:
> The server has 4x146gb scsi drives set up in 2 RAID-1 mirrored sets.
>
> We ended up with a 20 gig C drive and a 120gb D: drive on one mirrored
> set, and 70 gig E: and F: drives on the other mirrored set. Currently
> we'v
Dear list,
We had an engagement with the SeeFusion folks a few months ago (6?) in
which they made some recommendations to us regarding a new SQL Server
box. I'm not sure if our hosting company did what they recommended (I
was not involved in that part of the engagement) but here's
times I'm talking about those
wierd lock ups where all your threads get tied up or jrun error
messages get output to the browser.
Dan
On 2/26/09, Dave Watts wrote:
>
>> > Have you considered migrating SQL Server to a
>> > dedicated machine?
>>
>> I'd l
> > Have you considered migrating SQL Server to a
> > dedicated machine?
>
> I'd like to avoid that for cost reasons. I've been running
> the site nobosh.com on the one sever for over a year
> without issue, only recently due to product updates and
> increa
>FROM
>tableA p LEFT OUTER JOIN
> tableB e ON (p.use_no = e.use_no AND p.year = e.year and
>e.duplicate_set is not null) LEFT OUTER JOIN
>tableB d ON (e.duplicate_set = d.duplicate_set AND e.year =
>d.year)
Yes, I think that would work. There is probably a more elegant method
Try this setup:
http://www.fusioncube.net/index.php/coldfusion-sql-server-express
On Thu, Feb 26, 2009 at 9:37 PM, Mike Little wrote:
>
> hey guys, i have recently installed coldfusion 8. everything going sweet
> except creating a datasource to connnect to a remote ms sql server.
i am not totally following your question, but if it helps - i can connect to
the db with enterprise manager.
>Did you check with th TCP/IP enadled, port number and you should not use
>windows password but the database password.
>
>
>
>On Thu, Feb 26, 2009 at 9:37 PM, Mike Little wrote:
>
>>
~
nnnect to a remote ms sql server.
>
> i get the following...
>
> Connection verification failed for data source: xyz123
> java.sql.SQLException: Timed out trying to establish connection
> The root cause was that: java.sql.SQLException: Timed out trying to
> establish connection
hey guys, i have recently installed coldfusion 8. everything going sweet except
creating a datasource to connnect to a remote ms sql server.
i get the following...
Connection verification failed for data source: xyz123
java.sql.SQLException: Timed out trying to establish connection
The root
Not quite I sure I follow (sorry, almost out the door here), but I think
you just want your aggregate to an entry for every A regardless of B,
right? Try making your joins LEFT, and I think you'll have it:
...
FROM
tableA p LEFT OUTER JOIN
tableB e ON (p.use_no = e.use_no AND p.year
This is a follow on request to yesterday's post:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319832.
To review I have two tables something like this.
TableA
year use_no county rec_type
2009 1 1 X
2009 3 1 X
2009 4 1 Y
2009 5
Not sure about what the record_with_dups is exactly supposed to
represent, but it looks like you want something along these lines:
SELECT a.county, a.rec_type, COUNT(a.use_no) AS records,
COUNT(b.dup_set) AS record_with_dups
FROM [Table A] AS a LEFT OUTER JOIN
[Table B] AS b ON a.use_no = b
>I think something like ((A join B on use_no) join A on county) union A
>will effectively merge both table so you have all records full
>complete in the result. Then you can window / partition that for yout
>record_with_dups column.
>
>Jochem
I am still wrapping my head around it. But from what I
On Thu, Feb 26, 2009 at 12:12 AM, Ian Skinner wrote:
> Yes, that is exactly what the first three columns are; a count of
> records grouped by County and then rec_type. The tie-in with TableB is
> that this table contains other records that are suspected to be
> duplicates of records that where pu
C S wrote:
> Maybe I need glasses, but I missing something here. The first three report
> columns look like a count(*) from tableA by use_no and county. What is the
> tie-in with TableB and the "record_with_dups" column?
>
Yes, that is exactly what the first three columns are; a count of
r
Maybe I need glasses, but I missing something here. The first three report
columns look like a count(*) from tableA by use_no and county. What is the
tie-in with TableB and the "record_with_dups" column?
>county rec_type records record_with_dups
>1 X 2 3
>1
I have a tough nut to crack of a SQL report. First off, this is against
a Oracle 11ge database if that matters.
I have two tables.
Table A
use_no (key) county rec_type
1 1 X
3 1 X
4 1 Y
5 2
- Original Message -
From: "Matt Williams"
To: "cf-talk"
Sent: Tuesday, February 24, 2009 7:47 PM
Subject: Re: Can I do this in a single SQL query?
> UPDATE comments
> SET userID = (
> SELECT userID
> FROM users
> WHERE users.email =
On Tue, Feb 24, 2009 at 9:25 PM, Jim McAtee wrote:
>>
> The new system requires user registration and new comments are now tied
> directly to a user account. What I'd like to do is link any newly
> registered users to their old comments by using the email address. It's
> imperfect, but better t
Can you update the comments table when a new registration happens, with the
userid that matches the email address?
William
-Original Message-
From: Jim McAtee [mailto:jmca...@mediaodyssey.com]
Sent: Tuesday, February 24, 2009 6:26 PM
To: cf-talk
Subject: Can I do this in a single SQL
e name and email columns populated, while new comments
have the userid populated instead.
users
userid int
username varchar
email varchar
...
comments
commentid int
userid int
name varchar
email varchar
commentvarchar
...
Is there a single
e you found. Keep in mind, this
>> approach ASSUMES that one patient will never have two appointments at
>> the same time on the same day.
>>
>>
>> This runs on SQL Server 2000. It is a little crude, but should get the
>> point across:
>>
>
d, this
> > approach ASSUMES that one patient will never have two appointments at
> > the same time on the same day.
> >
> >
> > This runs on SQL Server 2000. It is a little crude, but should get the
> > point across:
> >
> > declare @appointment
e two appointments at
> the same time on the same day.
>
>
> This runs on SQL Server 2000. It is a little crude, but should get the
> point across:
>
> declare @appointment table
> (id int identity primary key,
> patient_id int,
> doctor varchar(50),
> appointment_
id
>> patient_id
>> doctor
>> appointment_date (datetime)
>>
>> A patient can have 0...n appointments on any given day. What I need to
>> do right now is generate a view that lists only the first appointment
>> for each patient each day. I'm pretty
appointment
>> for each patient each day. I'm pretty sure I need to be grouping by a
>> day of year function on the appointment_date but my brain is kind of
>> losing it on the rest. DB server is Sql Server 2000.
>>
>> Any thoughts?
>>
>> Thanks in advance
t lists only the first appointment
> for each patient each day. I'm pretty sure I need to be grouping by a
> day of year function on the appointment_date but my brain is kind of
> losing it on the rest. DB server is Sql Server 2000.
>
> Any thoughts?
>
> Thanks in advance
based on the min date you found. Keep in mind, this
approach ASSUMES that one patient will never have two appointments at
the same time on the same day.
This runs on SQL Server 2000. It is a little crude, but should get the
point across:
declare @appointment table
(id int identity primary key
This is related to an earlier post today "Coldfusion 8 Data Source Timeout".
I am still getting a timeout when configuring a certain Data Source to a remote
database.
Using dbaccess from my CF8 machine works - no problem.
I looked the cfserver.log and get: A non-SQL error occu
e 0...n appointments on any given day. What I need to
do right now is generate a view that lists only the first appointment
for each patient each day. I'm pretty sure I need to be grouping by a
day of year function on the appointment_date but my brain is kind of
losing it on the rest. DB server
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
Mike Kear wrote:
> The first two examples are selecting the literal value 'mike' and '1'
> In the first example, you are telling SQL to give the column
> containing 'mike' a name of 'name'.
aha.. literal was the word I was looking for. I did
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 correc
On my local network I've been using SQL Server 2000 and connecting to it with
BD7 & CF8 with no problems. I also have SQL Server 2005 on it and am having
trouble creating a datasource that logins. It seems to see SQL Server 2005, but
I am getting the following error:
Connection ver
> Has anyone got an example of a wish list request coming into the
> language/server?
>
> Not being flippant, just interested is all.
I can think of quite a few. Recently, the support of CFQUERYPARAM with
cached queries, for example.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fi
Jochem van Dieten wrote:
> ColdFusion comes with DataDirect 3.x.
>
> http://adobe.com/go/wish/
or you might give jTDS a spin.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free T
Has anyone got an example of a wish list request coming into the
language/server?
Not being flippant, just interested is all.
Adrian
> -Original Message-
> From: Jochem van Dieten [mailto:joch...@gmail.com]
> Sent: 17 February 2009 16:41
> To: cf-talk
> Subject: Re: May
On Tue, Feb 17, 2009 at 5:33 PM, Rick Root wrote:
> On Sat, Feb 14, 2009 at 6:45 PM, Paul Hastings wrote:
>>
>> ..or you might look to a newer JDBC driver that knows about "n" datatypes.
>> it's
>> not cf, its the db driver.
>
> I find it hard to believe that CF8's database drivers don't know abo
On Sat, Feb 14, 2009 at 6:45 PM, Paul Hastings wrote:
>
> Rick Root wrote:
>> It would seem that way. My rule of thumb is now:
>>
>> Always use nchar even if you know it will NEVER have unicode data in
>> it (like you're storing a coldfusion UUID) because CF will do all
>> unicode or all non-uni
I've always known it as selecting a literal value. So "SELECT 1" is "select
the literal value 1".
On Mon, Feb 16, 2009 at 7:41 PM, Mike Soultanian wrote:
>
> I was curious if anyone knows how you describe the following SQL
> functionality:
>
> SELECT &#
> I was curious if anyone knows how you describe the following SQL
> functionality:
>
> ...
>
> The last one is obvious as it's SQL arithmetic, but what are the first
> two examples? Are those also examples of "SQL arithmetic" as well? I
> can't find
The first two examples are selecting the literal value 'mike' and '1'
In the first example, you are telling SQL to give the column
containing 'mike' a name of 'name'.
A practical example of where you might use this behaviour might be :
SELECT
I was curious if anyone knows how you describe the following SQL
functionality:
SELECT 'mike' as name
returns a single column named "name" with a single row containing "mike"
I also know you can do stuff like:
SELECT 1
Which returns a column named "1&qu
ume currently?
>
>Hmm... Those are questions I don't know how to answer. However, if
>I'm understanding where your question process is going, you think
>having a process that would copy and apply the transaction logs on the
>SQL 2005 server might be a safer idea? That
o test :) Just do a restore of the full backup
somewhere and run some transaction logs afterwards.
> However, if
> I'm understanding where your question process is going, you think
> having a process that would copy and apply the transaction logs on the
> SQL 2005 server might be a s
to answer. However, if
I'm understanding where your question process is going, you think
having a process that would copy and apply the transaction logs on the
SQL 2005 server might be a safer idea? That's an interesting idea!
How would I accurately monitor those metrics?
As I said
> Don wrote:
> With regard to 1,498 tables, do you mean, User Tables? just for clarity.
Yes, 1498 user tables. The application was originally built on a
flat-file database system like DB3/4 or Foxpro and was ported to SQL
Server without re-engineering the database. All of the tables
On Mon, Feb 16, 2009 at 1:16 AM, C. Hatton Humphrey wrote:
> The main thing I'm worried about is any performance "hit" on the
> publishing server. The target server can lag behind data-wise by a
> bit (30 minutes to an hour is an acceptable delay).
Those do not appear to be very challenging requ
>Thanks for the comments, Don!
>
>The main thing I'm worried about is any performance "hit" on the
>publishing server. The target server can lag behind data-wise by a
>bit (30 minutes to an hour is an acceptable delay). The problem is
>the size. A MS Dynamics GP database contains 1,498 tables (
Thanks for the comments, Don!
The main thing I'm worried about is any performance "hit" on the
publishing server. The target server can lag behind data-wise by a
bit (30 minutes to an hour is an acceptable delay). The problem is
the size. A MS Dynamics GP database contains 1,498 tables (not
in
>Question for anyone that handles SQL Replication: What effect would
>setting up transactional replication from a large Windows 2000
>database (17 Gb) with moderate usage (18-20 max simultaneous
>connections) to a Windows 2005 server have on the performance of the
>Windows 2000
f you need to use MS SQL Server you should stop using UUIDs
alltogether and just use GUIDs in your CFMl and the UNIQUEIDENTIFIER
datatype in MS SQL Server.
Jochem
--
Jochem van Dieten
http://jochem.vandieten.net/
~|
Adobe® Cold
901 - 1000 of 14349 matches
Mail list logo
