Anyone help me please ? This is on an MX6.1 (with updater) server and
SQL 2000.
Up until now, I've been using a bit of code to convert SQL server binary
timestamps to text, storing them as a form field and then converting
them back to binary data when updating the record. I'd then catch any
Jochem. tried your code, but got the following error.
Server Msg: -3010, State: 07002, [Microsoft][ODBC Microsoft Access Driver]
Too few parameters. Expected 2.
with this code you supplied.
SELECT *
FROM auction_item_categories_sub5 s5
INNER JOIN
Hello,
I've used both, and migrated most of my db's from MySQL to SQL Server. It's
pretty simple I think.
What I did was purchase the developer edition of SQL Server. It's only $50, and
it comes full blown!
http://www.microsoft.com/sql/howtobuy/development.asp
Other than storied procedures
Matt Wisdom wrote:
10 drive raid
Which controller? Chipset? Battery backup? RAM?
What RAID config would you use for the databases?
Depends on what RAID controller you have. If it is IOP321 based,
10 disks in a RAID 6 or 9 disks in a RAID 5 and a hotspare.
How important is (battery
I'm not sure why you are using parenthesis for your joins since SQL
doesn't need them. This may sound horribly simple but I noticed a
change in your field naming convention throughout this thread. You have
category_id for all your tables except for your alias s4
(auction_item_categories_sub4)
Adam Howitt wrote:
I'm not sure why you are using parenthesis for your joins since SQL
doesn't need them.
Access ...
This may sound horribly simple but I noticed a
change in your field naming convention throughout this thread. You have
category_id for all your tables except for your
I have an application that sets a session variable.
That session variable is also stored in the database.
Is it possible to determine if a specific variable belongs to any active
sessions?
For example, I want to know if there are any active sessions containing
the session variable named FOO
Jochem van Dieten wrote:
I'm not sure why you are using parenthesis for your joins since SQL
doesn't need them.
Access ...
I know it's not really relevant to THIS discussion, but some database
servers DO require parentheses around multiple joins our DB2
mainframe does. So I tend to
Yes, if you have a look at this
http://tech.badpen.com/index.cfm?mode=entryentry=3 article by Tim
Blair you should be able to figure out how to get a loop going over
the highest level, drop in to session then check if your var is in the
struct.
Ian
On Sun, 16 Jan 2005 12:12:10 -0500, Rick Root
CFLib may be down for a little bit today. I'm switching servers.
(And btw, I'm switching to CFXHosting - who have been _extremely_ helpful!)
--
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket
Jared, Thanks to you and Doug James for checking into this
issue.
I just hit your test page, and the PDF form came up, the contents of
the FDF came up... same as Doug.
But when I clicked on the link to the FDF, I got the Reader splash
screen, and then nothing. Blank screen. No content at
Who were you with prior to today's move?
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 16, 2005 1:36 PM
To: CF-Talk
Subject: CFLib Downtime
CFLib may be down for a little bit today. I'm switching servers.
(And btw, I'm switching to
Adam, the code you gave didn't seem to work. same goes with Jochem. Although I
think we are getting closer with the last bit of code Jochem posted.
Error:
Server Msg: -3010, State: 07002, [Microsoft][ODBC Microsoft Access Driver]
Too few parameters. Expected 1.
SQL:
SELECT *
FROM
SQL:
SELECT *
FROM auction_item_categories_sub5 AS s5
INNER JOIN auction_item_categories_sub4 AS s4 ON
s5.category_id = s4.id )
INNER JOIN auction_item_categories_sub3 AS s3 ON
s4.category_id = s3.id )
INNER JOIN auction_item_categories_sub2 AS s2 ON
Protoculture wrote:
Although I think we are getting closer with the last bit of code Jochem
posted.
Error:
Server Msg: -3010, State: 07002, [Microsoft][ODBC Microsoft Access Driver]
Too few parameters. Expected 1.
SQL:
SELECT *
FROM auction_item_categories_sub5 AS s5
The regex works for most cases... but it's not stopping at the next ending
tag...
For example, the quote replac regex...
I have
[quote]heres a quote[/quote]
Here's some text
[quote]here's another quote[/quote]
The expression replaces quote tags with blockquote tags unless it false
between
Are you using CFMX? If so you can specify minimal matching, which I think is
probably the only way you can do this using a single regex. I think you
replace .* with .*?
-Original Message-
From: Ewok [mailto:[EMAIL PROTECTED]
Sent: Monday, 17 January 2005 10:01 a.m.
To: CF-Talk
Subject:
Regular expressions are greedy by default, they match as much as they can.
Adding ? to a qualifier makes it non-greedy - this seemed to do the job
for me, but I haven't looked too closely at your expression.
str = rereplace(str,
(\[quote\](.*?)\[/quote\])(?!((?!\[code\]).)*?\[/code\]),
MAN! How simple was that! Uhgg thanks guys
-Original Message-
From: Mike Nicholls [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 16, 2005 4:11 PM
To: CF-Talk
Subject: RE: regex help (Almost)
Regular expressions are greedy by default, they match as much as they can.
Adding ? to a
Sorry Jochem you were right.
Anyway, to get things more concise here, perhaps I'm not even doing the right
kind of join... here is my db structure...
http://www.webgoblins.net/db.gif
The Last Code I tried was Jochems and while it did run succesfully, there were
no results returned.
Why not just use cookies to store login info? I have developed
systems that use both ASP and CF. A cookie set using cfcookie can
be read by an ASP (or PHP I imagine) page with no problems, as long as
it is in the same domain.
On Sat, 15 Jan 2005 12:33:19 -0500, Rick Root [EMAIL PROTECTED]
From: Protoculture [mailto:[EMAIL PROTECTED]
The Last Code I tried was Jochems and while it did run
succesfully, there were no results returned. Essentially What
I'm doing is selecting all related categories from the where
all the ( auction_item_categories_sub.category_id = 1 ) and
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
I forgot to change something when copy/pasting.
SELECT
A.name
FROM
auction_item_categories A
INNER JOIN auction_item_categories_sub S1
ON (A.id = S1.category_id)
INNER JOIN
actually i think what i am gunna do is replace the php login with a flash one
so that way i can send username and password both to the php script and to the
cfm template (via actionscript)
maybe not optimal but in theory should work great :)
-- Original Message
Does anyone out there know of a tool or utility to unpack the schema of an
access database? We are doing a conversion of a fairly large Access db and
we are looking to save some leg-work.
-mark
Mark A. Kruger, CFG, MSCE
www.cfwebtools.com
www.necfug.com
http://blog.mxconsulting.com
did u know u get a big error mesage when u go there with ie? (see below)
was pointed out to me by jamie at hostmysite.com (silly boy still uses ie!!)
works fine with firefox though
Error Occurred While Processing Request
Could not find the included template /cflib/includes/udf.cfm.
Note:
10 drive raid
Which controller? Chipset? Battery backup? RAM?
Looking at an adaptec U320, 256 MB w/battery backup for 72 hours. The rest
of the system is a SuperMicro serverworks dual xeon mobo + case. It has 10
drive bays in the 4U case with a backplane and hotswap. 4GB of ram. About
$6,000
From: dave [mailto:[EMAIL PROTECTED]
did u know u get a big error mesage when u go there with ie?
(see below)
was pointed out to me by jamie at hostmysite.com (silly boy
still uses ie!!)
works fine with firefox though
Ray said that he was switching servers today
What is the most intense client vars database anyone here has set up?
It's a little strange because since the indexing is handled automatically it
isn't obvious how optimized the processes are. Has this ever been a
bottleneck for scalability?
Matt
why would it throw that error with ie though and not any of the good browsers?
-- Original Message --
From: Michael T. Tangorre [EMAIL PROTECTED]
Reply-To: cf-talk@houseoffusion.com
Date: Sun, 16 Jan 2005 18:00:39 -0500
From: dave [mailto:[EMAIL
From: dave [mailto:[EMAIL PROTECTED]
why would it throw that error with ie though and not any of
the good browsers?
Maybe IE is caching the pages... Who knows.
~|
Find out how CFTicket can increase your company's
Maybe your good browser is/was cached unbeknownst to you :)
-Original Message-
From: dave [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 16, 2005 6:19 PM
To: CF-Talk
Subject: RE: cflib ATT raymond
why would it throw that error with ie though and not any of the good
browsers?
It's a little strange because since the indexing is handled automatically
it
isn't obvious how optimized the processes are. Has this ever been a
bottleneck for scalability?
Matt,
I've run traced load tests on an isolated client variables database (i.e.,
separated from the transactional DB)
Matt Wisdom wrote:
10 drive raid
Which controller? Chipset? Battery backup? RAM?
Looking at an adaptec U320, 256 MB w/battery backup for 72 hours.
Cache size matters. See for instance the following tests with 128
vs 512 MB controller cache:
http://www.tweakers.net/benchdb/testcombo/82
Stephen...
I just hit the URL again using IE 6.
I got two messages from Acrobat, one that the page contained no
comments with Yes and No buttons.
The other one said This action is not permitted.
Both of these ocurred while I had Reader open as a standalone app.
When I hit the FDF page without
Incase you havent realized regex's arent my forte!
This seems to be the last little kink to get out of this thing and it will
be set (or I'm going back to the original Jim Davis loop!)
str = rereplace(str, (\[hr\])(?!(?!\[code\]).*?\[/code\]), hr, ALL);
this regex works perfectly as long
I have found that we had cache web server paths checked in the Server
Administrator. Now the different sites are running the correct
versions of the code, but they are still sharing the applications
vars. I cant find anything in the cf admin that could be making this
happen.
My application.cfm
Set up multiple CF instances in JRun. The free developer edition (or
the soon to be killed DevNet version) let you do this without cost.
You'll be running each version of the app in a totally independant
environment with no possibility of confusion. We do this in our
office with great success.
Jared,
Thanks again. I've tried every configuration I can think of I can't
get either of the results you reported. Would you mind trying this
link at planetpdf.com and letting me know what happens:
http://www.planetpdf.com/planetpdf/inetpub/demo2.html
This is the same basic idea of serving a
Still fighting that thing, eh? I spent 3 hours this afternoon trying
to figure out why a simple INSERT query wouldn't work... finally I
wrapped the query text in ## and a cfoutput, then copy/pasted it into
Query Analyzer... only to find out that the problem was a new column
in the database that
Thanks Barney, but it seems entirely unpractical that mx cant
distinguish application names/variables when they are set on
differenct sites. Are you telling me that this is a bug and there is
no other way around it except for separate instances of jrun?
On Sun, 16 Jan 2005 17:04:54 -0800,
CFMX happily distinguishes different applications with no problem, so
that's not the issue. There are a lot of things to deal with in
trying to run completely separate instances of the same application
inside the same CFMX instance. Enough that I don't think it's
practical to try, when there is
Maybe (just a thought here...) it wouldn't be a bad idea to think
Blackstone, or get the Macromedia FlashPaper add-on (it's what, $69?
$99?) to go direct html-to-pdf without anything extra in the middle.
I think, by and large, Acrobat is a great tool for disseminating
information to any supported
BTW... that sample site in ASP isn't working for my version of Reader either.
I get a file currupted message.
I do find that some things just aren't stable with pdfs unless they're
generated with Exchange or something, and even then they're twitchy
and take tuning to get working sometimes.
At least I'm not alone :)
I had thought about something to that effect but...
I wanted content between [code] and [/code] to stay exactly as the user
typed it. So if there are b tags they display as b and if there are [b]
tags they display as [b]
Jim Davis came up with a loop that extracts code
Geeze,
I sure hope anyone who read this paragraph:
Still fighting that thing, eh? I spent 3 hours this afternoon trying
to figure out why a simple INSERT query wouldn't work... finally I
wrapped the query text in ## and a cfoutput, then copy/pasted it into
Query Analyzer... only to find out that
Dude, have you considered taking a online Computer related stress test or
lowering your caffeine intake? Hah jokes. Believe me... we've all been
there... just some more than others. :)
-Original Message-
From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED]
Sent: Sunday, January
:P
I just read the note I sent and thought Good god, that sucked.
Figured if I thought it, someone else probably did too. But then,
we're all our own worse critics...
And I only got 2 cups of coffee today... every time I went to fill my
cup, the pot was empty.
Hey, maybe that's the problem...
Jared Rypka-Hauer - CMG, LLC wrote:
really awesome static fomation. However, any attempts I've seen to do
dynamic PDFs outside of fairly high-end tools just doesn't work very
opensource iText works a treat, though i don't know what you mean by
fairly high-end tools, i wouldn't normally
We had hassles with iText and multiple pages, but we got FOP working a
treat.
-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED]
Sent: Monday, 17 January 2005 12:38 PM
To: CF-Talk
Subject: Re: Dynamic CF PDFs - help request
Jared Rypka-Hauer - CMG, LLC wrote:
really
James Holmes wrote:
We had hassles with iText and multiple pages, but we got FOP working a
treat.
really? never had any issues w/it. nothing a quick email to their list
didn't solve.
~|
Stay Ahead of Hackers - Download
If you were thinking about trying cfeclpse, but didn't want to mess
with the plugin hunt, you can now try it out by just downloading the
files from my blog, unzip them, then run the Eclipse executable in the
cfeclipse.X directory.
There are now packages available for MacOSX, Linux, and the other
I'm sure we could have solved it, but we were in evaluation mode and we
really liked the coolness of FOP's XML/XSLT interface so we went with that
:-)
-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED]
Sent: Monday, 17 January 2005 2:05 PM
To: CF-Talk
Subject: Re: Dynamic
The Other One lol.
I've used quantum with the Oracle thin driver and that also works fine - is
adding that to the bundle a violation of Oracle's licence or is it worth
considering?
-Original Message-
From: Rob [mailto:[EMAIL PROTECTED]
Sent: Monday, 17 January 2005 2:08 PM
To: CF-Talk
54 matches
Mail list logo