That'd be great. I'm using SQL Server 2000.
~|
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/fle
What Database are you using for this? I can whip this out in a quick stored
procedure using SQL Server using table variables.
Teddy
On 1/16/07, Richard Cooper <[EMAIL PROTECTED]> wrote:
>
> Unfortunately, yes
>
>
~|
Create ro
Unfortunately, yes
~|
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:
Will the number of services be dynamic?
Teddy
On 1/16/07, Richard Cooper <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> This explanation is a bit long but it kind of needed it to explain what I
> was trying to achieve.
>
> I have three tables which I would like to join for use within creating a
> ta
Hi Pete,
could it be that one of the advertisers is in more than one category? Just dump
the query and look at the repeating entries. There will be some of the columns
that change from record to record. Even though you think they are identical.
Gert
> Hi there
>
> I have a query that I have d
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
Hi Claude,
The safeText() method that I pass the url param to fails if I don't wrap
the url param in HTMLEditFormat(). So something really hokey is
happening and my only assumption is that its being truncated at some
point. So unfortunately, its not only relegated to output but also
non-displa
>>I used HTMLEditFormat() and it finally pulled out
I SWEAR I didn't read your last message when I answered the first ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [
>>I've tried all different types of variations to ensure that the passed
data is preserved but its being truncated somehow.
How do you know it is truncated?
If you just output it without using HTMLEditFormat(), the
I'm using CFMX 6.1. :o)
Robertson-Ravo, Neil (RX) wrote:
> Doesn't CF7 provide out of the box features to stop this from happening. I
>
>
>
>
>
>
>
>
> "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
> Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed B
Good morning, Jochem. I used HTMLEditFormat() and it finally pulled out
the full value as opposed to the truncated one.
Rey...
Jochem van Dieten wrote:
> Rey Bango wrote:
>> and the value of the query param translates to:
>>
>> '")
>>
>> But when I go to use it in the code, I'm getting this:
>>
t: Fri Dec 22 11:27:45 2006
Subject: Re: SQL Injection Script
>Doesn't CF7 provide out of the box features to stop this from happening.
Read the docs, I'll bet the answer to your question lies there. Hahahahaha!
Couldn&#x
>Doesn't CF7 provide out of the box features to stop this from happening.
Read the docs, I'll bet the answer to your question lies there. Hahahahaha!
Couldn't help it Neil. :)
Will
~|
Create robust enterprise, web RIAs.
Upg
Rey Bango wrote:
>
>and the value of the query param translates to:
>
>'")
>
>But when I go to use it in the code, I'm getting this:
>
>URL Parameters:
>C1='")
Is that all you get, or is that all your browsers shows you?
Jochem
Doesn't CF7 provide out of the box features to stop this from happening. I
"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 which is
Thanks to everyone for your help! These work perfectly.
Mark
[This E-mail scanned for viruses by Declude EVA]
~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclic
Use the COALESCE function. It returns the first non-null value:
SELECT COALESCE(mycolumn, "default value") AS someField
FROM table_name
If any row for the mycolumn field returns null, the null value will replaced
with the string "default value".
-Original Message-
From: Mark Leder [mai
Yes... Use IsNull()
This changes your example as follows:
SELECT U.userID, U.userFirstName, U.userMiddleName, U.userLastName,
(U.userFirstName + SPACE(1) + IsNull(U.userMiddleName + SPACE(1), "") +
U.userLastName)
AS assignedName
FROM a_Table
Greetings / Grüsse
Gert Franz
Customer Care
R
Mark Leder wrote:
> I'm using this cfquery to pull records from an MSSQL 2005 db:
>
> SELECT U.userID, U.userFirstName, U.userMiddleName, U.userLastName,
> (U.userFirstName + SPACE(1) + U.userMiddleName + SPACE(1) + U.userLastName)
> AS assignedName
>FROM a_Table
>
> It works great, with o
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
#jUDate.getTime()#
..:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 07, 2006 3:25 PM
To: CF-Talk
Subject: RE: SQL getting the next available ID
What he said... I also
rsday, December 07, 2006 11:28 AM
To: CF-Talk
Subject: Re: SQL getting the next available ID
yes thats what he's saying. Since you create the UUID yourself with
createuuid() you can reference it early and often anytime, without any
added cfqueries or whatever. I like to use a replace funct
yes thats what he's saying. Since you create the UUID yourself with
createuuid() you can reference it early and often anytime, without any
added cfqueries or whatever. I like to use a replace function to
remove the underscores from the uuid, but thats as much personal
preference as it is anything
I am using SQL2K. I am not quite sure I am following the createUUID() Are
you saying to use this value as the adid versus using auto increment?
Regards,
Doug
~|
Create robust enterprise, web RIAs.
Upgrade & integrat
ou wanted to do.
..:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 07, 2006 9:49 AM
To: CF-Talk
Subject: Re: SQL getting the next available ID
Bobby,
So basically what I would do is add a column to my advertisem
From: "Bobby Hartsfield" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Thursday, December 07, 2006 7:28 AM
Subject: RE: SQL getting the next available ID
> Entering it temporarily will ensure that it isn't used again... ever
>
> Also, a simple flag like 'verified&
Entering it temporarily will ensure that it isnt used again... ever
Also, a simple flag like 'verified' as a bit field would make it easier than
having 2 separate tables for verified and unverified ads.
Enter all of the info and set the verified flag to 0. Once the user verifies
it, you can set
Why not set your ID to be a uniqueue identifier, then generate the ID with CF...
This should keep the ID unique for that Add...
On 07/12/06, Doug Brown <[EMAIL PROTECTED]> wrote:
> I am needing to get the next available ID from my (permanent)advertisements
> table and be able to hang onto it un
:) know the feeling, jim...i completely overlooked the distinct, left out a
comma between the fields, and left out the table name even though it was
right there...lol. all of this snow up here must be affecting my brain
cells...all 2 of them. oh, well, at least terry got some valuable feedback
on t
Thanks all of you. Wow, I really enjoy this list when you
all pitch in and help each other like you just did.
Really Appreciate it.
Terry
-Original Message-
From: Jim Wright [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 03, 2006 8:20 AM
To: CF-Talk
Subject: Re: Sql aggregate woes
Jim Wright wrote:
> SELECT inventory.ItemNumber, SUM(inventory.qty) as
> invqty
> FROM inventory
> GROUP BY inventory.ItemNumber
> HAVING SUM(inventory.qty) > 0
>
oops...told you to take the DISTINCT out, and then left it in...see above.
~~
Terry Troxel wrote:
> I am having a senior moment and could use some help with a
> sql select query I am attempting to use to populate a
> listbox with only those items that have inventory.
>
> SELECT DISTINCT inventory.ItemNumber, SUM(inventory.qty) as
> invqty where invqty > 0
>
> And I get the
select distinct
i.itemnumber
sum(i.qty) as invqty
from [your inventory table name here] i
group by i.itemnumber
having sum(i.qty) > 0
On 12/3/06, Terry Troxel <[EMAIL PROTECTED]> wrote:
>
> I am having a senior moment and could use some help with a
> sql select query I am attempting to us
SELECT DISTINCT inventory.ItemNumber, SUM(inventory.qty) as invqty where
invqty > 0
GROUP BY inventory.ItemNumber.
All items not aggregated in a select must be also placed in a Group By
Clause.
Sandra Clark
==
http://www.shayna.com
Training in Cascading Style Sheets
That looks like the right/only way to do it as far as I know.
Mark
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 30, 2006 11:02 AM
To: CF-Talk
Subject: OT: SQL question
I am not a MS SQL guru and this bit of SQL is about as advanced as I
g
Thanks Gert, that did the trick.
~|
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.fusionauthorit
Sorry, I grouped over the DateAdded Field too. You have to remove it
from the Select and Group BY statement.
Gert
Richard Cooper schrieb:
> Hi,
>
> I have a table (ordersonline) that may have multiple entries for each client
> within the client table (clients).
>
> I wanted to be able to see th
Hi Richard,
in order to get the sum of all details in the ord table you should not
group over fields in the ord table that are not equal for each client.
So if you do something like this:
SELECT COUNT(ORD.orderID) AS numbProducts, CLI.fname, CLI.sname,
CLI.city, CLI.clientID, SUM(ORD.price
That works too. Thanks Dave.
Thanks,
Mark
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 16, 2006 11:56 AM
To: CF-Talk
Subject: RE: SQL Problem
> I'm stumped on this. How to I retrieve records that do not match (I'm
> wa
Jim,
Thank you, that worked perfectly. Admittedly, I get confused by the LEFT/ON
attribs in queries.
Thanks,
Mark
-Original Message-
From: Jim Wright [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 16, 2006 11:56 AM
To: CF-Talk
Subject: Re: SQL Problem
Mark Leder wrote:
>
You could use the GROUP BY and count() function. See
http://www.petefreitag.com/item/169.cfm
HTH,
Aaron
On 11/16/06, Mark Leder <[EMAIL PROTECTED]> wrote:
> I'm stumped on this. How to I retrieve records that do not match (I'm
> wanting to display orphaned Companies that are not associated with
>
Try this:
SELECT company, companyID, companyCity, companyState, companyZip,
FROM dbTable_Clients_Companies_List
WHERE companyID Not in (Select companyID From dbtable_Clients_Projects_List)
ORDER BY company ASC
this sould do...
Greetings / Grüsse
Gert Franz
Customer Care
Railo Technologies GmbH
Mark Leder wrote:
> I'm stumped on this. How to I retrieve records that do not match (I'm
> wanting to display orphaned Companies that are not associated with
> Projects). Tried <> and using NOT and NOT IN() without success.
>
> SELECT C.company, C.companyID, C.companyCity, C.companyState, C.com
> I'm stumped on this. How to I retrieve records that do not
> match (I'm wanting to display orphaned Companies that are not
> associated with Projects). Tried <> and using NOT and NOT
> IN() without success.
>
> SELECT C.company, C.companyID, C.companyCity, C.companyState,
> C.companyZip,
>
-Original Message-
From: "Doug Brown" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: 11/14/06 7:17 PM
Subject: Sql error during insert
I do not recall seeing this before. Could someone tell me what I am doing
wrong? I get the following error while executing this query.
Error Executing Da
Thanks. I hate it when the little stuff haunts you -)
Doug
- Original Message -
From: "Bobby Hartsfield" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Tuesday, November 14, 2006 8:21 PM
Subject: RE: Sql error during insert
> You are mis
Never mind...I missed a closing ) on my query. Geez looked at it forever.
D.B
- Original Message -
From: "Doug Brown" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Tuesday, November 14, 2006 8:15 PM
Subject: Sql error during insert
> I do not recall seeing this before. Could someone tell m
You also need to specify the delimiter in your loop as a |
..:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Crow T. Robot [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 14, 2006 10:22 PM
To: CF-Talk
Subject: Re: Sql error during insert
If
You are missing a ) after the queryparam
..:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 14, 2006 10:15 PM
To: CF-Talk
Subject: Sql error during insert
I do not recall seeing this
If this is a true "copy and paste", you're missing your ending ')' in the
VALUES statement.
On 11/14/06, Doug Brown <[EMAIL PROTECTED]> wrote:
>
> I do not recall seeing this before. Could someone tell me what I am doing
> wrong? I get the following error while executing this query.
>
> Erro
> > 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
Hi,
This has been solved (sort of). I edited some data in the DB and it started to
work.
Thanks for the help.
Richard
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion informa
Hi Jochem,
Thought you had it but unfortunately the end result was the same. It's really
weird why the join affects the other table. Do you have any other ideas?
Richard
~|
Introducing the Fusion Authority Quarterly Update. 80
Richard Cooper wrote:
>
> i.e. results for CP1 disappear when I uncomment out the either of the
> two and statements.
> SELECTCP1.pageID
> ,CP1.pageGroupID
> ,CP1.subGroupID
> ,CP1.pageTitle
> ,CP1.alternativeLink
> ,
Richard Cooper wrote:
> Hi All,
>
> How would I turn this into an SQL while loop rather than a nested query? I
> never used while loops and can't quite suss it.
>
> Here's the code:
>
>
>
> SELECTpriority, serviceID
> FROM TPSservices
> WHERE active = '1'
> AND priority >
You could also do:
SELECT MAX(thedate)
FROM yourtable
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 22, 2006 9:05 AM
To: CF-Talk
Subject: SQL Question
Im a little burnt out need some help.
If I query a table that tracks the number of times a
Thanks Kris! That makes sense.
> -Original Message-
> From: Kris Jones [mailto:[EMAIL PROTECTED]
> Sent: Sunday, October 22, 2006 10:12 AM
> To: CF-Talk
> Subject: Re: SQL Question
>
> select top 1 *
> from tablename
> order by datefield desc
>
>
select top 1 *
from tablename
order by datefield desc
On 10/22/06, Chad Gray <[EMAIL PROTECTED]> wrote:
> Im a little burnt out need some help.
>
> If I query a table that tracks the number of times a book was checked out and
> returned. I want to get the most recent item in the table to f
>Remember that the database is the most important part of the Web site,
>and you don't want to use any tool that may have some bug that could
>result in data loss.
Very true. I only mention the product that I use because it is considerably
cheaper for what it does and because the issues I have h
Reed Exhibitions."
Visit our website at http://www.reedexpo.com
-Original Message-
From: Mike Chabot
To: CF-Talk
Sent: Wed Oct 18 17:41:47 2006
Subject: Re: SQL compare software
Remember that the database is the most important part of the Web site,
and you don't want to use any too
Mike Chabot wrote:
> Remember that the database is the most important part of the Web site,
> and you don't want to use any tool that may have some bug that could
> result in data loss. I believe that RedGate does a good job with QA
> testing and they have been supporting their software for a long
Looks like I have to get crackin on these
> suggestions.
>
> > -Original Message-
> > From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, October 18, 2006 10:19 AM
> > To: CF-Talk
> > Subject: Re: SQL compare software
> >
> > &
Thanks for all the replies. Looks like I have to get crackin on these
suggestions.
> -Original Message-
> From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 18, 2006 10:19 AM
> To: CF-Talk
> Subject: Re: SQL compare software
>
> >Try T
>Try Teratrax SQL Compare. It just came out of beta. It's not as polished
>as Red-Gate's tools, but it's cheaper, and it's all one product (both schema
>and data compare).
I'm using DB Explorer. It also is a lot cheaper and does both the schema and
data compare and synchronize. I've run into
Also have a butchers at ApexSQL - quite nice though I think Redgate is the
defacto standard,
-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]
Sent: 18 October 2006 15:17
To: CF-Talk
Subject: RE: SQL compare software
Try Teratrax SQL Compare. It just came out of beta. It&#
Try Teratrax SQL Compare. It just came out of beta. It's not as polished
as Red-Gate's tools, but it's cheaper, and it's all one product (both schema
and data compare).
It still doesn't work for one of my tables, and I haven't really been using
it in depth, but once my RedGate's Trial is over,
Hi Ray,
I agree, I've been using them for the past month or so.
I've upgraded to the Professional version for the command line
functionality. Means I can update however many sites in one go rather have
to process each project separately, saves even more time.
The SQL Data Compare is also a drea
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
Dave Watts wrote:
>> Thanks Dave. You said "open Query Analyzer and run the file".
>> I don't see where in QA I can open a file...
>
> I don't have it in front of me, but I'm pretty sure there's an option to
> open a text file. If you can't find it, you could open the file in Notepad,
> then copy
October 03, 2006 10:22 AM
To: CF-Talk
Subject: Re: SQL ''Invalid Object Name'' on Insert, after Create Table
Thanks for the suggestions so far. I'll try them now.
Here's the code:
IF object_id('aaa_bwdatadump..djbtest') IS NOT NULL
BEGIN
DROP TAB
When you modify the schema, are you performing this from a cfquery block?
If you are, put the schema modification in a stored procedure for purposes
of security, speed and abstraction.
Teddy
On 10/3/06, Bobby Hartsfield <[EMAIL PROTECTED]> wrote:
>
> I've seen that happen on a database that was m
It had to happen.
For some reason I had 'quotes' around the col-name in the Insert. D'oh!
Sorry to waste space...
>
> INSERT INTO #getuser.owner#.djbtest ('id')
> VALUES ('sdfasdfafasdfasfd')
>
>
~|
Introducing the F
Thanks for the suggestions so far. I'll try them now.
Here's the code:
IF object_id('aaa_bwdatadump..djbtest') IS NOT NULL
BEGIN
DROP TABLE djbtest
END
CREATE TABLE dbo.djbtest (
id varchar(200)
)
SELECT * from djbtest
SELECT name, xtype, uid AS [owner id], USER_NAME(ui
I've seen that happen on a database that was moved from one server to
another where user names/passwords were different in the Enterprise
Manager/CF Admin.
Check those first... should be pretty easy to spot. Open the enterprise
manager and view the tables in that particular database scan down
Don't know if it matters, but are you opening a transaction before you
create the table, and trying to insert while that transaction is still
open?
Is this MS SQL Server?
If so, is there a "Go" command after the table creation?
Just random thoughts.
~Brad
-Original Message-
From: Derek
Can you create a physical table and insert into it in the same batch? I'm
not sure you can.
Show us the code.
Adrian
-Original Message-
From: Derek Bezuidenhout [mailto:[EMAIL PROTECTED]
Sent: 03 October 2006 14:50
To: CF-Talk
Subject: SQL 'Invalid Object Name' on Insert, after Create Ta
> Thanks Dave. You said "open Query Analyzer and run the file".
> I don't see where in QA I can open a file...
I don't have it in front of me, but I'm pretty sure there's an option to
open a text file. If you can't find it, you could open the file in Notepad,
then copy and paste into the T-SQL wi
Thanks Dave. You said "open Query Analyzer and run the file". I don't see where
in QA I can open a file...
>It's called "Query Editor" now, and it's inside SQL Server Management
>Studio.
igleaf.com/ for more information!
~|
Intr
> This is SQL 2005 - not 2000. Where can I find query analyzer?
It's called "Query Editor" now, and it's inside SQL Server Management
Studio.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training c
This is SQL 2005 - not 2000. Where can I find query analyzer?
>> I have a database dump (> 900MB> in a .sql file. It has all
>> the sql to create a database and put data in. I want to use
>> it to make a db in SQL 2005 but can't find a way to do this
>> using import data / transact SQL etc. Doe
> I have a database dump (> 900MB> in a .sql file. It has all
> the sql to create a database and put data in. I want to use
> it to make a db in SQL 2005 but can't find a way to do this
> using import data / transact SQL etc. Does anyone know how to
> do this?
If the file contains a CREATE DAT
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
901 - 1000 of 4779 matches
Mail list logo
