of the logs and the offending IP's.
Has anyone done something like this before?
Thanks,
Rob
-Original Message-
From: Dana Kowalski [mailto:[EMAIL PROTECTED]
Sent: 14 March 2007 18:17
To: CF-Talk
Subject: Re: SQL Login Faliure
a decent reference from microsoft on securing SQL Server:
http
are you on a co-locate, home network, virtual hosting etc?
Normally I would just put blocks at the router/firewall level to not allow the
SQL machine (if its seperate form the web server) to communicate to anything
outside the domain, or more specifically only to the web server (depending on
Also, 'Kowalski' is a VERY cool name! :-D
Rob
-Original Message-
From: Dana Kowalski [mailto:[EMAIL PROTECTED]
Sent: 14 March 2007 14:30
To: CF-Talk
Subject: Re: SQL Login Faliure
are you on a co-locate, home network, virtual hosting etc?
Normally I would just put blocks at the router
.
Is there a method for closing the server so it only receives connections
through the local server, It's only 2 or 3 of my CF apps that use it.
Thanks,
Rob
-Original Message-
From: Dana Kowalski [mailto:[EMAIL PROTECTED]
Sent: 14 March 2007 14:30
To: CF-Talk
Subject: Re: SQL Login Faliure
are you
Robert Rawlins - Think Blue wrote:
Is there a method for closing the server so it only receives connections
through the local server, It's only 2 or 3 of my CF apps that use it.
Set an IPSec policy.
Jochem
~|
ColdFusion MX7
Thanks Jochem,
I'll give that a go this afternoon.
Rob
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: 14 March 2007 16:24
To: CF-Talk
Subject: Re: SQL Login Faliure
Robert Rawlins - Think Blue wrote:
Is there a method for closing the server so it only
I'll second that. IPSec can be complicated when you first set it up but is
very flexible.
- Original Message -
From: Jochem van Dieten [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Wednesday, March 14, 2007 4:23 PM
Subject: Re: SQL Login Faliure
Robert Rawlins - Think
a decent reference from microsoft on securing SQL Server:
http://msdn2.microsoft.com/en-us/library/aa302434.aspx
(I was looking for it before but my bmarks have become unwieldy :o )
~|
ColdFusion MX7 by Adobe®
Dyncamically
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 into
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
Hi Richard,
Take a look at this post that I found on tek-tips:
http://www.tek-tips.com/faqs.cfm?fid=4751
Cheers,
Kris
Hi, i am using ms sql server and need to implement get the median of a set of
values. i have looked all over the web and cant find a simple explanation.
i would appreciate
thank kris, the problem i am having is that all the information i find is
always centered around getting a median using every single row in the table.
except i have groups of data in the table and want to work out a median for
each group. the group is identified by 4 different columns (the 5th
You need brackets around the ORs, otherwise it'll only join correctly on the
first condition, and not the second two:
SELECT *
FROM tbl_meddelregos m, tbl_mdconfregoptions r
WHERE m.confregoptionid = r.confregoptionid
AND (m.confregoptionid = 1
OR m.confregoptionid = 6
OR cocktailparty
If I understand you correctly
select *
from tbl_meddelregos m, tbl_mdconfregoptions r
where
m.confregoptionid = r.confregoptionid and
(
m.confregoptionid = 1 or
m.confregoptionid = 6 or
) AND
cocktailparty 0
order by
-
From: Peter Boughton [mailto:[EMAIL PROTECTED]
Sent: Sunday, 11 March 2007 10:03 AM
To: CF-Talk
Subject: Re: SQL - slightly OT
You need brackets around the ORs, otherwise it'll only join correctly on the
first condition, and not the second two:
SELECT *
FROM tbl_meddelregos m, tbl_mdconfregoptions r
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
and
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
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:
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).
Straight
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/
Are you sure your Mysql DBMS understands the 'INTO' SQL command. I have not
seen that used much and do not know how universal it is among database systems.
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
-
| 1 | |
- Binary Sudoku
|
Take a look at this page for the proper INTO syntax. May change depending
on which version of mysql you're using. It looks like you have to do
something like INTO @visaudactvols if you're trying to use a variable.
http://dev.mysql.com/doc/refman/4.1/en/select.html
-- Josh
- Original
That's because MySQL does not support SELECT INTO for tables, only external
files and variables, so MySQL thinks your destination is a variable and is
complaining that it does not exist. You may want to use INSERT SELECT
instead.
Pete wrote:
Hi
Hoping someone might be able to assist - its 4am and I have just been called
by a client coz their system crashed. They have just moved from using an
Access DB to MySQL.
They have a piece of code:
select *
into visaudactvols
from visualauditrecs
I don't believe
Jim Wright wrote:
Pete wrote:
They have a piece of code:
select *
into visaudactvols
from visualauditrecs
I don't believe MySQL supports this use of INTO. You can use:
INSERT INTO visaudactvols(somecolumn)
SELECT somecolumn FROM visualauditrecs
but the table will have to exist
We are looking to buy SQL Server 2005 Workgroup. Seems more
than enough omph for complex web databases behind a CF Server.
So, I am a little confused by CALsthey state for every user that
directly connects needs a CAL...but is a web connection to a
CF server calling back to that
We are looking to buy SQL Server 2005 Workgroup. Seems more
than enough omph for complex web databases behind a CF Server.
So, I am a little confused by CALsthey state for every user that
directly connects needs a CAL...but is a web connection to a
CF server calling back to that
thanks heaps for the advice guys.
i am currently downloading the ems manager lite suggested by mike. looks right
up my alley.
cheers
mike
There is a free tool for SQLServer2005 at
http://sqlmanager.net/products/mssql/manager/.
It's called EMS SQLManager Lite.
The Lite part means it doenst
There is a free tool for SQLServer2005 at
http://sqlmanager.net/products/mssql/manager/.
It's called EMS SQLManager Lite.
The Lite part means it doenst have some features on it, but nothing
that would worry us for what we do. The bits taken out are for
professional DBAs and what's left is fine
Mike | NZSolutions Ltd wrote:
Hi guys,
Did a bit of research on this topic, but a little confused.
What should I be using as an enterprise manager equivalent for sql
server 2005 (hosted at my webhost). I wish to be able to connect to the
db and create/organise tables - including reordering
I'm not sure this came through properly the first time so here it goes
again... sorry if this is a duplicate post.
In SQL Server 2005, the Enterprise Manager has been replaced with the
SQL Server Management Studio. There is a version called SQL Server
Management Studio Express Edition that is
SQL Server Management Studio combines the features of Enterprise Manager
*AND* Query Analyzer in a single tool, which is great.
You do not need a full license, you can install the client software locally
- just download the trial of SQL 2005 and install only the client software.
Rick
On
Get the Microsoft Action Pack you get a ton of Microsoft software for only $299
per year, Including SQL Server 2005. https://partner.microsoft.com/us/40013779
Enrollment is open to: Resellers, Technology Consultants, Value-added
Technology Partners, System Integrators, System Builders, and best
If you want a GUI tool that will interface (connect and more) to MS-SQL 7,
2000, 2005, as well as MySQL, SyBase, Oracle, etc...
Try Aqua Data Studio from Aqua Fold http://www.aquafold.com
-Original Message-
From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED]
Sent: Saturday,
Add something like this into your where clause
WHERE clientID = cfqueryparam value=#clientID-1#
cfsqltype=cf_sql_integer/
OR clientID = cfqueryparam value=#clientID# cfsqltype=cf_sql_integer/
OR clientID = cfqueryparam value=#clientID+1# cfsqltype=cf_sql_integer/
and then sort by clientID.
: Re: SQL next and previous
Add something like this into your where clause
WHERE clientID = cfqueryparam value=#clientID-1#
cfsqltype=cf_sql_integer/
OR clientID = cfqueryparam value=#clientID# cfsqltype=cf_sql_integer/
OR clientID = cfqueryparam value=#clientID+1#
cfsqltype=cf_sql_integer
Mik Muller wrote:
select left(datetime,11), count(*) as dt
from sitelog
where datetime = '2007-02-03 00:00'
group by left(datetime,11)
order by left(datetime,11) desc
Well, now that I look at it, the order by is ordering by jan 1 2006 etc in
This is how I'm doing it for now...
select count(*) as dt cfif url.stats eq bar-day, left(datetime,11) as
datetime/cfif
from sitelog
where datepart(year,datetime) = '#theyear#'
and datepart(month,datetime) = '#themonth#'
cfif listLen(url.datestat,/) eq 2
and datepart(year,datetime) =
Bruce,
One way to accomplish this is to query your (unique) records and populate
another table with the same structure with that data. Once it is done, then
you can re-populate that table from the table you created. Hope that makes
sense.
Doug B.
- Original Message -
From: Bruce
Without looking too hard, would using a TOP 1 in the sub select work?
-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED]
Sent: 01 February 2007 17:26
To: CF-Talk
Subject: SQL QUestion
I have a lot of duplicate information in a table. I know how to query to
find the dupes,
Bruce Sorge wrote:
I have a lot of duplicate information in a table. I know how to query to
find the dupes, but I am having problems with deleting them (there are
thousands). I tried this:
DELETE
FROM CODES
WHERE Code =
(SELECT Code,
COUNT(Code) AS NumOccurrences
FROM Codes
GROUP BY
OK, I figured it out pretty much. So now I have this:
CREATE TABLE #tempduplicatedata
(
Code NVARCHAR(20)
)
--Identify and save dup data into temp table
INSERT INTO #tempduplicatedata
SELECT Code FROM Codes
GROUP BY Code
HAVING COUNT(Code) 1
--Confirm number of dup rows
SELECT @@ROWCOUNT AS
I actually bloged about this earlier this month. See here:
http://www.ruslansivak.com/index.cfm/2007/1/10/Deleting-duplicate-rows-from-
SQL-Server
Russ
-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 01, 2007 12:26 PM
To: CF-Talk
Subject:
Bruce Sorge wrote:
I have a lot of duplicate information in a table. I know how to query to
find the dupes, but I am having problems with deleting them (there are
thousands). I tried this:
create a clone of your table but make your key duplicated column as a unique
key setting the index to
How many records are coming back?
How are you calling it?
I have ran tests before for where running exec sp_name in side of a
cfquery was faster than cfstoredproc.
Just a thought.
Also are you sure the stored proc is really taking 20 seconds to run OR
is the CF page just taking 17 seconds to
You may want to recompile the sp... It may have been compiled before the
statistics for the tables involved were updated.
You could check the query plan of the sp vs. the query to see how they
differ. (Not sure what db you are using...)
Mark
-Original Message-
From: Tim Do
Bruce Sorge wrote:
OK, I figured it out pretty much. So now I have this:
CREATE TABLE #tempduplicatedata
(
Code NVARCHAR(20)
)
--Identify and save dup data into temp table
INSERT INTO #tempduplicatedata
INSERT INTO #tempduplicatedata (code)
SELECT Code FROM Codes
GROUP BY Code
Damn! Always the simple shit that gets me.
Thanks.
On 2/1/07, Jochem van Dieten [EMAIL PROTECTED] wrote:
Bruce Sorge wrote:
OK, I figured it out pretty much. So now I have this:
CREATE TABLE #tempduplicatedata
(
Code NVARCHAR(20)
)
--Identify and save dup data into temp table
There must be other indexes on this table that include the text fields.
Check in SQL Enterprise Manager.
Mark
-Original Message-
From: Scott Weikert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 30, 2007 1:03 PM
To: CF-Talk
Subject: SOT: SQL insert issue with indexes
In my
Gaulin, Mark wrote:
There must be other indexes on this table that include the text fields.
Check in SQL Enterprise Manager.
Did. There's four fields:
The main identity field (PK)
Two int fields referencing IDs in other tables (with indexes, but no
foreign key/relationships set up)
One
difference using the shorter index.
(I've never done that before in real use but I was just able to define a
table and index that way.)
Mark
-Original Message-
From: Scott Weikert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 30, 2007 3:21 PM
To: CF-Talk
Subject: Re: SQL
Gaulin, Mark wrote:
Ok, so how is the varchar field defined? If it is over that limit you
mentioned earlier (1000 or so?) then that's the problem. Basically, SQL
Server would be complaining only when the data to index actually was too
big.
I suspect that's the issue - in this
cfquery name=queryName
SELECT yourcolumn, 0+REPLACE(SUBSTRING_INDEX(yourcolumn,' ',1),',','') AS
sort
FROM yourtable
ORDER BY sort
/cfquery
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 25, 2007 8:13 AM
To: CF-Talk
Subject: SQL order by
When you
Chad Gray wrote:
I cannot switch it to an integer field because there will be some text also.
Any way to accomplish this?
maybe something like...
SELECT thefield FROM foo
ORDER BY CASE WHEN IsNumeric(thefield)=1 THEN CAST(thefield AS INT) ELSE
0 END,thefield
That should put the text
If you keep it as a string column, you cannot avoid this. The only way you
can sort it correctly is to pad the single digits with a leading 0.
This will force:
01
02
03
.
update
tblFoo
set
columnFoo = '0' + columnFoo
where
cast(columnFoo AS integer) 10
^---MS SQL solution.
Or you could do that =) Either you update the data which allows better
sorting or you inline query it with aggregate solutions and the data remains
unsorted.
It is a philosophical choice. I like to keep good indexes, so I perform a
lot of data scrubbing to avoid complex queries for other team
Thanks Andy,
I am using MS SQL and don't have substring_index. Is there a MS SQL function
similar?
-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 25, 2007 9:22 AM
To: CF-Talk
Subject: RE: SQL order by
cfquery name=queryName
SELECT
Thanks Jim! That works great for me!
I will have to look up CASE, I am not familiar with that function.
Thanks again!
-Original Message-
From: Jim Wright [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 25, 2007 9:26 AM
To: CF-Talk
Subject: Re: SQL order by
Chad Gray wrote:
I
: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 25, 2007 9:22 AM
To: CF-Talk
Subject: RE: SQL order by
cfquery name=queryName
SELECT yourcolumn, 0+REPLACE(SUBSTRING_INDEX(yourcolumn,' ',1),',','') AS
sort
FROM yourtable
ORDER BY sort
/cfquery
-Original Message
Case isn't a function. It's a flow control statement. Just like doing a
cfswitch statement in CF.
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 25, 2007 8:52 AM
To: CF-Talk
Subject: RE: SQL order by
Thanks Jim! That works great for me!
I
-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 25, 2007 8:52 AM
To: CF-Talk
Subject: RE: SQL order by
Thanks Jim! That works great for me!
I will have to look up CASE, I am not familiar with that function.
Thanks again!
-Original Message-
From: Jim Wright
, THEN, ELSE, END in SQL.
-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 25, 2007 9:51 AM
To: CF-Talk
Subject: RE: SQL order by
Case isn't a function. It's a flow control statement. Just like doing a
cfswitch statement in CF.
-Original
I should point out one issue with the way I did it...the isnumeric
function is not perfect, and will resolve to true things that can't be
converted to INT...case in point...
IsNumeric('1,0.') = 1
CAST('1,0.' AS INT) throws an error
Jim Wright wrote:
I should point out one issue with the way I did it...the isnumeric
function is not perfect, and will resolve to true things that can't be
converted to INT...case in point...
IsNumeric('1,0.') = 1
CAST('1,0.' AS INT) throws an error
and further, you need to look at the
Subject: Re: SQL order by
Jim Wright wrote:
I should point out one issue with the way I did it...the isnumeric
function is not perfect, and will resolve to true things that can't be
converted to INT...case in point...
IsNumeric('1,0.') = 1
CAST('1,0.' AS INT) throws an error
and further
!
-Original Message-
From: Jim Wright [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 25, 2007 10:18 AM
To: CF-Talk
Subject: Re: SQL order by
Jim Wright wrote:
I should point out one issue with the way I did it...the isnumeric
function is not perfect, and will resolve to true
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 join
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 meeting
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
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 Enterprise
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 that the
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
the db name to the tablename
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
Thanks for both your code examples. I'm succesfully testing both out now, not
sure yet which route I will pick though. Very useful, thanks again.
R
~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 MX7 integration create
Bruce,
I got that error what I was using CFQueryParam with CF_SQL_DATE.
Apparently CF_SQL_DATE is not inherently supported. If you are using it,
try switching over to CF_SQL_TIMESTAMP, which is supported by SQL
Server.
..
Ben Nadel
Certified Advanced ColdFusion MX7
Thanks Ben,
I will give that a try when I get home. I just find it odd that on my test
server at home and the production server, it I have no issues with this. It
is only my laptop. The only difference in my laptop and the test and
production servers is that the laptop is running Windows XP
I am getting this error on my development laptop but not on
any other machine. I googled the problem but could not get
anything very useful.
[Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC SQL Server Driver]Optional feature
not implemented
I am using CFMX 7 and SQL
VMware baby!! No honestly that is why I use VMWare on my Dev Server and my
Laptop. At anytime I can spin up similar enviroments Linux,Win2k3, etc .
Best 200.00 I spent :)
Eric Haskins
Web Systems Developer
On 1/17/07, Bruce Sorge [EMAIL PROTECTED] wrote:
Thanks Ben,
I will give that a try
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
table of
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:
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 robust
That'd be great. I'm using SQL Server 2000.
~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
Richard,
I did not like the TSQL dynamic SQl that I created. I always hate defeating
an execution plan. Here is a CF way:
!--- I used ad hoc queries for the sake of time. I highly recommend
putting this in a multi-result stored procedure ---
cfquery datasource=test name=qryEntry
select
Sent: Tue Jan 16 21:49:57 2007
Subject: Re: SQL Join Data group output
Richard,
I did not like the TSQL dynamic SQl that I created. I always hate defeating
an execution plan. Here is a CF way:
!--- I used ad hoc queries for the sake of time. I highly recommend
putting this in a multi-result
Sorry for the delay. I had some deliverables and a few meetings. It was a
fun little code challenge that I put on myself to finish it under 25
minutes.
Teddy
On 1/16/07, Teddy Payne [EMAIL PROTECTED] wrote:
Richard,
I did not like the TSQL dynamic SQl that I created. I always hate
There are probably many ways to do this, but one thing you might find
useful is to make use of a CROSS JOIN in your query...that way you can
return one record for each combination of tbl1ID and service, and then
use a LEFT JOIN to determine if there is a match in Table 2...something
like...
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
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
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
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 ago.
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 statement
with
handle x
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 Coldfusion MX7
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 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 PK
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:
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
Rey Bango wrote:
and the value of the query param translates to:
')script id=8000 /
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.
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.
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't help it Neil
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:
')script id=8000 /
But when I go to use it in the code, I'm getting
801 - 900 of 4661 matches
Mail list logo