--Original Message-----
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 17, 2000 9:52 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Noodling over Switch Statements and Stored Procedures and
Eff icie ncy
There's your answer...that's the last time I'll use EXEC!!!
-Origin
When you have created your datasource make sure you set it to be "NT trusted
connection"
-Original Message-
From: Gleber, Brian A [mailto:[EMAIL PROTECTED]]
Sent: 17 August 2000 15:01
To: [EMAIL PROTECTED]
Subject: Login Failed For User '/'
Hello,
I am having a connectivity
You can see this help file re configuring ODBC DSN's in the CFStudio
help
Use Trusted Connection -- Allows SQL Server to authenticate on the user's
Windows NT login. You can use this option if the SQL Server database is
using an Integrated or Mixed security mode. Integrated security uses
We are using ClusterCats for one of our projects which has 2 web servers and
2 database servers. However, we are not hosting the servers and the company
who is set it all up so I can't tell you much about it. From what I
understand though it does the job.
-Original Message-
From: Kevin
If you are using SQL 6.5 then I think I know what's causing this.
This part of your code: (len(wire_id)-2) could well be producing a negative
result and hence when you wrap the right function around it you will get a
536 errorfor more info have a look at what Microsoft say about
Can't combine the where clause as they are different tables. You could do a
number of things:
1) As Chad suggested you could have to CFQueries and deal with them
together in your template or
2) If you don't want to deal with the result sets seperately you could
write a query/SP that deals
yehit's got something to do with the cursor you are using when you make
the connection to SQLit's been a long time since I used an Access front
end to a SQL database but start investigating down these lines until you get
the solution! In the meantime I'll try to dig it out of my memory
Just remembered (I think) When you open the recordset/resultset make sure
you open it as a Dynaset (cursor type). What data access are you using?
RDO? ADO?...
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: 16 August 2000 16:47
To: '[EMAIL PROTECTED]'
Subject
the problem is that if you use distinct it takes into account all of the
fields that you have included in your select.
If you are not using them, why are you including Events.ProgramName,
Events.ProgramDate in your select list? If you omit these and use diatinct
it will work...e.g:
SELECT
not quiteyou need to use barckets around the exec i.e.
declare @mysql varchar(300)
select @mysql = ' select ...'
exec (@mysql)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 15 August 2000 14:23
To: [EMAIL
much better to build up your sql string dynamically and then execute
it...takes less code in the long run if you have to do lots of if
statementsremeber to make sure you do "Select @sqlstring = @sqlstring +
etc if you need to append lots of bits so that you don't overwrite
anything you've
agreed.it's much better to have it as an SP. That way SQL doesn't have
to parse the SQL before executing it.
-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: 15 August 2000 14:40
To: '[EMAIL PROTECTED]'
Subject: RE: SQL Server Stored Procedure problem
much
Correct. "Select Distinct" selects distinct records for ALL of the columns
that you supplied. i.e.
"SELECT DISTINCT name From table" selects one record for each distinct name.
"SELECT DISTINCT name, otherfield From table" selects one record for each
distinct combination of name and other
Let me see if I understand you correctly..if you create your own cookies
to store CFID and TOKEN, overwriting the ones put there by default by CF, do
these cookies automatically get destroyed when the browser is closed as
opposed to the default cookies which expire on the client when the
Document Management/Version Controlyou need to buy SourceSafe!
-Original Message-
From: Ed Toon [mailto:[EMAIL PROTECTED]]
Sent: 10 August 2000 14:49
To: [EMAIL PROTECTED]
Subject: RE: Document Management Solution
What exactly are you looking for? And for god's sakes, why would
Uh.why is "#dsn#" the error? I think you want to remove
sessionmanagement="Yes".
-Original Message-
From: Floris Brouwer [mailto:[EMAIL PROTECTED]]
Sent: 10 August 2000 14:53
To: [EMAIL PROTECTED]
Subject: RE: lame client variable question
error is "#dsn#"
F.
-Oorspronkelijk
should be easy enough.
Matt
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 10, 2000 5:10 AM
To: '[EMAIL PROTECTED]'
Subject: RE: CFAPPLICATION - Need some advice
Let me see if I understand you correctly..if you create your own cookies
to store
use the CFObject tag
-Original Message-
From: Bill Killillay [mailto:[EMAIL PROTECTED]]
Sent: 10 August 2000 16:29
To: Cf-Talk
Subject: COM Objects?
How does one go about calling a com object from ColdFusion?
Bill
on the client). We use only
app/session vars, and use a login/database system for client vars so it has
not ben an issue. Sorry if this doesn't help you.
Matt
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 09, 2000 11:10 AM
To: '[EMAIL PROTECTED]'
Subject
on the client). We use only
app/session vars, and use a login/database system for client vars so it has
not ben an issue. Sorry if this doesn't help you.
Matt
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 09, 2000 11:10 AM
To: '[EMAIL PROTECTED
oooh...doesn't sound to good.
What I'd try is to create another database and import all of the data
across. Delete the old database and then change your DSN's to point to the
new database.
-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: 09 August 2000 13:34
To:
this error applies to?
Thanks,
Howie Hamlin
- Original Message -
From: Andy Ewings [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 09, 2000 8:45 AM
Subject: RE: SQL Server errors
oooh...doesn't sound to good.
What I'd try is to create another database and import all
the event log. The SQL Server is still running and
working. This error quickly fills up the event log (that's how many times
it's ahppening).
Thanks,
Howie Hamlin
- Original Message -
From: Andy Ewings [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 09, 2000 8:56 AM
I've just run a small test here and had no problems. I created an Access
database with 1 table in it with a memo field with data in it.
I then used then imported data into SQL using the Import wizard in SQL 7. I
did this by selecting MS Access as the source, My SQL server as the
destination
m
mailto:[EMAIL PROTECTED]
-Mensaje original-
De: Andy Ewings [mailto:[EMAIL PROTECTED]]
Enviado el: miércoles 9 de agosto de 2000 14:52
Para: '[EMAIL PROTECTED]'
Asunto: RE: CFAPPLICATION - Need some advice
Session management is a bit of a nightmare in CF in my
opinion. If
It'll be much easier if you use SQL as the engine to import the
data.
-Original Message-
From: Brian Mitter [mailto:[EMAIL PROTECTED]]
Sent: 02 August 2000 15:31
To: [EMAIL PROTECTED]
Subject: SQL Server Virgin seeks advice
I'm (trying to!) upsize my first access db to a sql7
Whoops, sorry,.replied to this yesterday!
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: 03 August 2000 11:42
To: '[EMAIL PROTECTED]'
Subject: RE: SQL Server Virgin seeks advice
It'll be much easier if you use SQL as the engine to import the
data
procedure to import the database could
the different accounts/permissions (his and mine) cause this sort of error?
Thanks
Brian
- Original Message -
From: Andy Ewings [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 02, 2000 3:50 PM
Subject: RE: SQL Server Virgin
There is an OLEDB provider for SQL but to be honest you are probably better
sticking with ODBC if you are using ColdFusion as the development tool. I
don't think you are that restricted by using an ODBC DSN. You may want to
use OLEDB if you are say creating connections on the fly in code e.g.
han the Allaire documentation".
Thanks for your help, appreciated
Brian
- Original Message -----
From: Andy Ewings [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 03, 2000 12:03 PM
Subject: RE: oledb and native drivers
There is an OLEDB provider for SQL but to be honest you
Can anyone tell me if it is at all possible to get CF to find an element in
an array?
I know you use ListFind and StructFind for lists and structures respectively
but don;t know how to do it with an array.
I have a 2-dimensional array so can't use the ArrayToList function and then
do a
here here...the only problem is you have to adapt to new technologies
because sooner or later the ones you have been using may eventually not be
supported.
-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: 03 August 2000 14:14
To: '[EMAIL PROTECTED]'
Subject:
Shame you can't use SQL as you wouldn't have to make 2 hits to the database
then. You could look at the 'Inserted' table after adding the record
-Original Message-
From: Jim Mixon [mailto:[EMAIL PROTECTED]]
Sent: 03 August 2000 15:32
To: [EMAIL PROTECTED]
Subject: Re: Access AutoiNumber
Yeh thought so..thanks for confirming. Bit naff don;t you think?why
haven't allaire supported this for arrays but have for Structs and Lists?
-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: 03 August 2000 15:43
To: [EMAIL PROTECTED]
Subject: RE:
absolutely.The point is that OLEDB is supposed to be more versatile than
ODBC in that you can link to pretty much any datasource. If you want to
link to a more 'traditional' database then you'll do just as well to use
ODBC with RDO/ADO/etc.Although OLEDB will be just as quick it is
I did something similar recently although not with dates using SQL. What
you might like to do is to write an SP which excepts a string parameter
containing each of the days (i.e. columns) that you want to update separated
by a comma i.e. '1,15,25' and then another parameter which holds the text
cfset listname = "" to initialise a list and cfset ArrayName =
ArrayNew(dimension) to initialise an array.
If you want to hard code an element of an array just use cfset
arrayname[1][1] = value for the first dimension of the first element for
example.
-Original Message-
From: Kevin
If I were you I wouldn't use the upsize wizard. I'd use the import data
facility within SQL (right click on tables, all tasks, import data) The
wizard is fairly self explanitory. Make sure you use the transfer data
option rather than using a query to select data.
You also get much more
y/List Initialization
Actually what i was referring to was something along the lines of
cfset listname= ArrayNew(1)
cfset listname = ("a","b","c","d")
This way i won't have to do
listname[1] = "a"
listname[2] = "b" ...
It will be a single
I think this is a 'hazy' area. It's the same as CF. If you are running a
multi-processor server you are supposed to have a special CF license for
each processor but I heard that Allaire have sold very few of these. Every
company that I have worked for have bought a normal SQL license (£1400)
501 - 540 of 540 matches
Mail list logo