SQL Mailing List RSS Feed

cfinclude and cffile

Fri, 15 Aug 2008 01:12:00 GMT

Thanks, Dave.

Rich

On Aug 14, 2008, at 6:56 AM, Dave Babbitt wrote:

>
>
> #Chr(60)#cfinclude template='includedFile.cfm'#Chr(62)#
>
> static + dynamic content
>
>
>
> On Thu, Aug 14,
[more]

cfinclude and cffile

Fri, 15 Aug 2008 12:52:00 GMT

#Chr(60)#cfinclude template='includedFile.cfm'#Chr(62)#

static + dynamic content

On Thu, Aug 14, 2008 at 2:15 AM, Rich wrote:

> Hi. I'm trying to write a cfm file
[more]

cfinclude and cffile

Thu, 14 Aug 2008 02:41:00 GMT

Sorry about that, Peter.  I just got caught up in this and forgot
which list I was posting to.

Thanks for the suggestion.  I was thinking about something like that,
but I was curious as to whether there was something built into CF for
handling
[more]

cfinclude and cffile

Thu, 14 Aug 2008 02:35:00 GMT

> parsed, as expected. How can I do this so that the cfinclude tag is
> parsed only when the output file is actually run?
>

Not sure that this belongs on the SQL mailing list. :P

Anyway, you just have to do something similar to this:

[more]

cfinclude and cffile

Thu, 14 Aug 2008 02:19:00 GMT

Hi.  I'm trying to write a cfm file using
and include a cfinclude tag in the file.  I have all of my dynamic
content in a cfsavecontent tag and I'm using that as the output of the
cffile tag.  However, I want the file
[more]

How to change a project to a new IP

Sat, 09 Aug 2008 10:19:00 GMT

It's been a while since I did this, but I think you have to connect to
the old IP if you still can, open the project, then change the
database connection configuration to the new IP. If you can no longer
connect to the old IP, there may be a way to
[more]

How to change a project to a new IP

Sat, 09 Aug 2008 12:03:00 GMT

I'm using MS Visual Studio to build a SSIS package to upload my database to
the remote server. The database has 39 tables with quite a complex array
of foreign keys and dependencies, so they can't be just uploaded. They
have to be uploaded in the
[more]

Query Help PLEASE!

Fri, 08 Aug 2008 08:11:00 GMT

>  I'm trying to output the results like this
>           Total Orders Failed Orders Total Errors   Wrong   OverPick Damage  Missing
> 1/1/2008 5       4  14        2 3  8     1
> 1/2/2008 5       2  15        6 2  2     5
>
>  Total Orders: Count of
[more]

Query Help PLEASE!

Fri, 08 Aug 2008 02:20:00 GMT

I'm trying to run Audit data for our network. Here is the way the data is stored.
ID DATE Order Site Wrong Overpick Damage Missing
1 1/1/2008 7456345 NY 0 0 0 0
2 1/1/2008 8234645 NV 1 1 1 1
3 1/1/2008 1657768 PA 0 0 4 0
4 1/1/2008
[more]

SQL Injection

Mon, 04 Aug 2008 10:16:00 GMT

Thanks, Claude.

On Aug 4, 2008, at 9:45 AM, Claude Schneegans wrote:

>>> So there's no way to write CF tags as
> text into a database record?
>
> Actually, yes you can, but you can't execute it when read from a
> database.
>
> --
>
[more]

SQL Injection

Mon, 04 Aug 2008 09:48:00 GMT

>>So there's no way to write CF tags as
text into a database record?

Actually, yes you can, but you can't execute it when read from a database.

--
_______________________________________
REUSE CODE! Use custom tags;
See http://www.contentbox.
[more]

SQL Injection

Mon, 04 Aug 2008 02:39:00 GMT

Ah. OK, thanks!

Thanks, everyone.

Rich

On Aug 4, 2008, at 2:31 AM, James Holmes wrote:

> You can write them to the DB - you just can't get them to execute
> without writing them to a file and using cfinclude.
>
> On Mon, Aug 4, 2008 at 2
[more]

SQL Injection

Mon, 04 Aug 2008 02:35:00 GMT

You can write them to the DB - you just can't get them to execute
without writing them to a file and using cfinclude.

On Mon, Aug 4, 2008 at 2:28 PM, Rich wrote:
> That might be the way to go. So there's no way to write CF tags
[more]

SQL Injection

Mon, 04 Aug 2008 02:31:00 GMT

That might be the way to go. So there's no way to write CF tags as
text into a database record?

Rich

On Aug 4, 2008, at 2:22 AM, James Holmes wrote:

> You could write the query (including cfquery and cfqueryparam tags) to
> a file and
[more]

SQL Injection

Mon, 04 Aug 2008 02:26:00 GMT

You could write the query (including cfquery and cfqueryparam tags) to
a file and cfinclude it to execute it.

On Mon, Aug 4, 2008 at 2:11 PM, Rich wrote:
> Then what Maureen was suggesting was what I was actually trying to
>
[more]

SQL Injection

Mon, 04 Aug 2008 02:15:00 GMT

Then what Maureen was suggesting was what I was actually trying to
avoid.  I guess there's no easy solution.  As far as what you're
suggesting, the cfqueryparam tag will be processed when the string is
constructed.  How can you enter it into the
[more]

SQL Injection

Mon, 04 Aug 2008 02:09:00 GMT

when building the string

parameter1='A' AND parameter2='B'

build it the way you want to run it.

parameter1= AND parameter2=

since you are building the string, Maureen was suggesting you run through
your stored
[more]

SQL Injection

Mon, 04 Aug 2008 02:00:00 GMT

I don't follow.

On Aug 4, 2008, at 12:50 AM, Maureen wrote:

> Parse the storedstring and put everything after your comparsion as the
> value of cfqueryparm.
>
> On Sun, Aug 3, 2008 at 7:59 PM, Rich wrote:
>> Hi. I'm using
[more]

SQL Injection

Mon, 04 Aug 2008 12:54:00 GMT

Parse the storedstring and put everything after your comparsion as the
value of cfqueryparm.

On Sun, Aug 3, 2008 at 7:59 PM, Rich wrote:
> Hi. I'm using cfqueryparam with any dynamic cfquery tag. However, in
> one case, I'm
[more]

SQL Injection

Sun, 03 Aug 2008 11:03:00 GMT

Hi.  I'm using cfqueryparam with any dynamic cfquery tag.  However, in
one case, I'm storing the "WHERE" conditions in a user account so that
the user can call up the last search he did.  So I  construct the
string (e.g. parameter1='A' AND
[more]

text truncating

Fri, 01 Aug 2008 09:44:00 GMT

>>ColdFusion has a max long text buffer of 64k.

This was the second more obvious
[more]

text truncating

Fri, 01 Aug 2008 09:33:00 GMT

I found the issue and it wasn't SQL. ColdFusion has a max long text buffer of 64k. This limits 32k worth of characters to be passed through CF to a text field. I just doubled the size and it works ok.

>>>I'm storing a large chunk of text into a text
[more]

text truncating

Fri, 01 Aug 2008 09:20:00 GMT

>>I'm storing a large chunk of text into a text field and I just found out
that the text is being truncated.

Just to eliminate the more obvious:
Of course, you have already verified the maximum length of the text field?

--

[more]

text truncating

Fri, 01 Aug 2008 09:15:00 GMT

I'm storing a large chunk of text into a text field and I just found out
that the text is being truncated. This is on SQL2k. Anyone know what's going
on?
Thanks

--
Michael Dinowitz (http://www.linkedin.com/in/mdinowitz)
President: House of Fusion
[more]

comparing two columns with like

Wed, 23 Jul 2008 10:07:00 GMT

You may need quotes -- '%dcp.titleslug%'

If it runs, I would expect it a LONG execution time

hth

-brian

On Tue, 22 Jul 2008 23:20:42 -0400, Michael Dinowitz wrote
> I tries
> select dcp.title, cdb.title
> from gcd cross join cdb
> where
[more]

comparing two columns with like

Wed, 23 Jul 2008 12:33:00 GMT

Perfect.
'%'+dcp.titleslug+'%'

Only returned 296 potential matches. So much for my hopes of automating the
merge operations. :(

On Wed, Jul 23, 2008 at 12:17 AM, James Holmes
wrote:

> Oh I get the problem now (my bad
[more]

comparing two columns with like

Wed, 23 Jul 2008 12:21:00 GMT

Oh I get the problem now (my bad).

This works in Oracle:

select dcp.title, cdb.title
from gcd cross join cdb
where cdb.titleslug like '%'||dcp.titleslug||'%'

|| is the string concatenation operator in Oracle; try the appropriate
one for your
[more]

comparing two columns with like

Tue, 22 Jul 2008 11:24:00 GMT

I tries
select dcp.title, cdb.title
from gcd cross join cdb
where cdb.titleslug like %dcp.titleslug%

This is on SQL 2000 and I got:
error in where clause near '%'
unable to parse query text.

As for speed, we're talking about 80,000 titles to
[more]

comparing two columns with like

Tue, 22 Jul 2008 11:08:00 GMT

"Something like where dcp.titleslug like %cdb.titleslug%"

That's pretty much what I'd do in this situation (although it will run
slow) - is it not working?

On Wed, Jul 23, 2008 at 10:04 AM, Michael Dinowitz wrote:
> I'm doing a join of two tables
[more]

comparing two columns with like

Tue, 22 Jul 2008 10:07:00 GMT

I'm doing a join of two tables where each has a title-slug (a string with
all non-alphanumeric characters converted and dashes between words). I'd
like to do a like join between the two title slugs but don't know how to do
it with non-variable data.
[more]

restriction of access to system tables

Tue, 22 Jul 2008 12:54:00 GMT

Hello you SQL Server DBAs out there:

Is there any way how I can restrict the access to system tables for SQL
Server 2000 (such as syscolumns) on the master DB to only the SA account?

Qing Xia
[more]

SQL Database Administrator, Technical Services

Mon, 30 Jun 2008 04:29:00 GMT

Qualifications:

" Bachelors degree preferred.
" Minimum of seven (7) years experience with MS SQL Server is required.
" Minimum of seven (7) years experience writing code for database access, modification and construction including Triggers,
[more]

MIDL Developer needed

Mon, 30 Jun 2008 02:41:00 GMT

Clearance:

� Active TS/SCI

Location:

� Suitland, MD

Education & Experience

Masters Degree in Computer Science, Engineering (or related discipline) with 5 years experience in software development, or Masters Degree
[more]

SQL Query to count the number of columns

Tue, 17 Jun 2008 04:28:00 GMT

http://www.catb.org/~esr/faqs/smart-questions.html

For example, which DB platform are you on?

On Tue, Jun 17, 2008 at 3:58 PM, Koushik Ghosh wrote:
> SQl Query to count(find) the number of columns present in a table
[more]

There has never been a better time to be a ColdFusion Developer

Sat, 06 Sep 2008 08:59:55 GMT

Adobe® ColdFusion® 8 software is a must-have release for developers to create compelling internet applications that fit in today's enterprise environment. Now you can build rich and engaging application experiences for users that do more and look better faster than ever. There has never been a better time to be a ColdFusion Developer. Get the Free Trial

SQL Query to count the number of columns

Tue, 17 Jun 2008 04:01:00 GMT

SQl Query to count(find) the number of columns present in a table
[more]

The Fusion Authority Quarterly Update Volume 2, Issue 4 is out now

Sat, 06 Sep 2008 08:59:55 GMT

If you want your ColdFusion skills to be up-to-date then you need the Fusion Authority Quarterly Update. The current issue is all about Best Practices and Development Environments. Just what we all need. Order now