At 03:19 PM 3/29/00 -0500, you wrote:
Are you saying you got cfa_htmleditor to work in netscape?
No, I'm saying that I was told that it worked. I didn't do anything, I sat
and watched the people demonstrating do things. I was also saying that,
with creative use of javascript to tweak the
I'm also working with Jeff, and I wanted to add that when RDS goes down,
you cannot stop and start the service. It doesn't respond to any control
signals, even if both CF server and CF Exec are shutdown. The only thing
the brings RDS back up is a full reboot of the server.
Judah
At 01:37
At 11:23 AM 4/13/00 -0400, you wrote:
Yes. You can save the query to SESSION scope.
cfif NOT IsDefined("SESSION.QueryName")
cflock name="#SESSION.SessionID#" timeout="30"
cfquery name="SESSION.QueryName" datasource="#dsn#"
SQL STUFF
Here is the code:
CFSET NewDate=CreateODBCDate(#dateformat(Now(),"mm/dd/yy")#)
Should be cfset NewDate = #CreateODBCDate(Now())#
Pound signs always go on the outside, any text not escaped (inside single
or double quotes) insides the pound signs are interpreted as
variables. And creating a
At 02:24 PM 4/20/2000 -0500, you wrote:
Alright, I think it's beer:30 again. We're getting cranky. Myself included.
Yeah, I agree. Even though it's only 1 something in my time zone. Good
thing I work only 2 block from a fantastic pub...
Judah
At 10:55 AM 5/3/2000 -0700, chris wrote:
Leave it to Microsoft to make it so the escaped HTML entities
are essentially reserved words. Pretty pathetic.
To be completely fair, the W3C specs for HTML say that if you are going to
use in the url, you are supposed to use the character entity. If
iginating server has requested no caching
Can anyone tell me what the difference between these two are and if they
would effect browser and proxy caching differently?
I looked through the http 1.1 spec and could get a really solid grasp on
caching and proxy vs. browser implementations.
T
I can't tell you about CommerceTrends, but I used Webtrends for awhile and
was not terribly impressed. The biggest problem was that a combination of
Webtrends, IIS, and CF reliably crashed CF once every couple days (or more
often). Since uninstalling Webtrends, my CF stability has increased
At 08:40 AM 5/11/2000 -0700, you wrote:
We spec our CF boxes (NT/2000) at 2 PIIIs (not Xeon), mirrored disks and
512 MB. We generally buy the fastest processors available, lately 733s
and, as tempting as those little IBMs may be, we currently favor Dell 2450s.
We've got much the same setup,
At 12:42 PM 5/11/2000 -0400, you wrote:
Well with database more RAM is always better. Though on the list it has been
posted many times that if you're going to get a multiprocessor do 2
computers with 2 processors instead of one 4 processor. Not only do you get
clustering, but the performance
At 01:14 PM 5/15/2000 -0400, you wrote:
I completely agree with you. The main thing I got out of my comp sci degree
was the ability to think more logically. And, boy, do I know how to sort
(bubble, merge, radix, quicksort)!
Woo Hoo!! Let the fun begin!
Stephanie Cunningham
Web System
We don't use Spectra at the moment (wish I had a spare $15,000 laying
around...), but I can tell you the way that we tackled that problem. We
defined a table of option types (color, size, fabric, etc) and a table of
option values with foreign keys to the option types (color, red; color,
At 11:13 AM 5/17/2000 -0700, you wrote:
Now, if you need to perform a search on the db in real time, Verity's not
the answer. Easy enough, however, to "almost" query in real time: everytime
you update/insert to the db, you re-run your collection page (of course,
that can be a bit excessive
I had to set up a system like this for a client. Basically, the process
needs to work by attaching the web cam to a video board (like the Winnov)
and having software that snags a jpg from the video feed every 20
minutes. Generally speaking, as long as the video board supports Video for
Not very elegant, but here it is...
cfset new_date = #CreateODBCDate(Evaluate(Month(Now())+1)'/1/'Year(Now()))#
Currently outputs: {d '2000-06-01'}
Good luck.
Judah
At 04:32 PM 5/31/00 -0400, Timothy C. Hill wrote:
I have been on a 23 hour coding spree to finish up a project. How do
you
At 05:51 PM 6/17/2000 -0400, you wrote:
We're in the midst of a minor disagreement about the location of
the default 404 error message delivered by CF (_not_ the web
server default; we started abusing that one long ago). I'm pretty
sure that it's being spat directly out of the application
If you are implementing form2urlattributes, it doesn't like pages in
sub-folders. It has a few built-in assumptions (if I recall correctly),
two of which are that the page being called is index.cfm and the second
being that it is at the top level of the web directory (i.e.,
At 01:18 PM 6/21/2000 +0200, you wrote:
Hi everyone.
We're using SQL server 7.0 and it's working great. The DoD recently
purchases a site license
for the entire DoD for Oracle. My question is should I move my SQL server
DB to Oracle?
Just to be contrary, I'd put my vote in for Sybase. Great
At 01:27 PM 6/21/2000 -0400, Zac wrote:
Hope that's helpful.
Do be careful using host headers, tho. They're far less reliable
than using separate IPs. I'd consider them accessable for internal
stuff or for personal sites, but I would NEVER rely on them for a
publicly accessable site that
At 10:04 AM 6/22/2000 -0700, Karl Simanonok wrote:
My experience with Sybase has been that the company is incompetent about
technical matters regarding their own products, nonresponsive to support
issues and even to potential buyers,
and their database is a dinosaur that performs poorly
At 04:55 PM 6/29/2000 -0400, you wrote:
Hello,
We are about to start a fairly large project using mysql on Unix
as our DB. I hear there is no transaction support, you can't do
'sub selects' (Is that the same thing as a sub-query?), and that it is
in some way 'single threaded' and/or unsuitable
At 04:47 PM 7/6/2000 -0400, you wrote:
On Win2000, be forewarned that you'll experience about a 17-20% performance
degradation over NT 4.0. This is with the ZDLabs ServerBench 4.1 CPU suite
of tests in our labs.
Any ideas why? I've been pondering moving some servers to W2K as I've like
W2K
Looks good, although I have one thought to throw in...
At 05:47 PM 7/10/00 -0400, you wrote:
sniped
!--- Can convert multiple IP's using large dim arrays?? *shrug* ---
CFLOOP LIST="#ipAddress1#" DELIMITERS="." INDEX="i"
CFSET ipAddress1Arr[loopCnt] = i
CFSET loopCnt = loopCnt
At 11:00 AM 7/12/2000 +1000, you wrote:
Hai,
can i get information how to display alphabetical order from a query
cfquery
SELECT id, blah, moreblah
FROM sometable
ORDER BY blah
/cfquery
Assuming that blah is some sort of character field, this will sort it
alphabetically. Options
At 04:27 PM 7/14/2000 -0700, you wrote:
Watch out when using cfmail on solaris (and more than likely linux as
well) when sending via a qmail SMTP server. I recently found that the
messages wouldn't go out because of bare linefeeds. CF would return the
messages to the coldfusion/mail/undelivr
We recently purchased Macromedia Generator 2 and have been attempting to
use cfx_generate in order to use the offline generation features. The
problem is, that when we run cfx_generate, nothing noticable happens. It
doesn't generate an error, doesn't log anything when cfx_generates logging
At 11:18 AM 7/25/2000 +, you wrote:
Late last week, the server began coughing on the slash-delimited query
strings. It
appears that the server believes the slashes indicate folders, and it
gives 404 errors
whenever a slash-delimited URL query string is accessed.
You have to tell IIS to
At 02:32 PM 7/28/2000 -0700, you wrote:
However, that brings me to my next question - what is user.dmp? Isn't that
a user-sensitive file? In other words, am I sure that CF is writing to
that file? or is it possible that some service crashed and the machine
wrote to that file everything that
First thing I do is ratchet down the TTL (time to live) on the dns
records. As I recall, the default TTL for an A record is 48 hours. When
I'm going to move hosts, I'll bring it down to usually an hour or two.
It means that you'll get more traffic to your dns servers, checking the
address, but
I haven't done exactly what you are attempting to do, but we move files
over to our db server for bulk insert using cffile and UNC paths. So you
would use a cffile call with the action move and the destination \\{db
ip}\{share}\ The big gotcha (and possibly what's wrong with your
current
Wil Genovese wrote:
snip
This is the sort of thing I posted about earlier. Eclipse/CFEclipse has
chosen to not follow defined usability and accessibility keyboard
shortcuts. For you (Eclipse community) to just shrug it off as well
that's just their defaults is wrong. For the Eclipse
We are currently using ActivePDF Toolkit version 4 for a small
pdf-related need. The function currently reads in an existing pdf, adds
some text to it, then writes it out to a new file. I need to make a
slight change to the process and for it to work, I need to be able to
get the page height
Well, since its hockey, you know that there are 20 minutes in a period,
so any numbers greater than 20 (ie 36) are going to be seconds (00:36)
but two digit numbers 20 or less are going to be an area that needs more
definition. Is 18 supposed to be 18:00 or 00:18? I think that needs to
get
FTPS is not the same thing as SFTP. FTPS is ftp over SSL. It typically
runs on port 990. SFTP is ftp running over SSH. It typically runs on
port 22.
I've seen differing support for the two protocols. Filezilla, for
instance, support SFTP and FTPS on the client, but only supports SFTP in
the
Dan G. Switzer, II wrote:
I've seen differing support for the two protocols. Filezilla, for
instance, support SFTP and FTPS on the client, but only supports SFTP in
the server product.
Actually, FileZilla Server only support FTPS on the server. :)
This is the problem with having FTPS and
Dale Fraser wrote:
Ok,
I'm officially sick of waiting, someone please give me the inside Goss on
CF8 pricing, I'm dying here.
$2.15
Anyone know where that number comes from, for a cookie? :)
Judah
~|
Get the
Claude Schneegans wrote:
this was a quiz question on cf weekly
Then, if it was a quiz question, the quiz is dummy, because true random
number with no duplicates
cannot exist ;-)
That's not true. You can have true random numbers without duplicates.
Each successive iteration of the
I'm pretty sure that you want count(products.id) not sum. If the product
id is 100 then sum(product.id) is going to be 100 even though there is
only one record. But Rick knows that, he just needs to fire his typist ;-)
Judah
Rick Root wrote:
That should be:
having
sum(products.id)
It is a potential race condition, but that doesn't automatically mean
that a lock is needed. The data being updated is a list of forums and
threads. It may be the case that it doesn't need to accurate to the
millisecond. If I create a new thread and someone has a page view at the
exact time I
A project I am working on has the opportunity to leverage some of the
new integration between CF 8 and PDF, particularly creating and filling
out forms. However, a number of customers on this project are going to
have existing forms that need to be imported into the system, preferably
in as
Chris Martin wrote:
When you do the database update, you'll have to run the select query
again and then use...
cfoutput query=jss
cfset theSubCat = #Evaluate(form. SUBCAT)#
/cfoutput
Evaluate is almost never, ever needed. SUBCAT is a dynamic key in the
struct FORM. Happily, Coldfusion
INSERT INTO tbl2 (col1, col2, etc)
SELECT col1, col2, etc
FROM tbl1
Should copy everything from tbl1 to tbl2. This presumes that tbl2 is empty.
Cheers,
Judah
daniel kessler wrote:
I have a table and I'd like to duplicate all of it's data to another table.
I've set the second table to have
Raymond Camden wrote:
And in case you can't find it on the site, you can see a visual list here:
http://www.coldfusionbloggers.org/feeds.cfm
and an OPML feed here:
http://www.coldfusionbloggers.org/opml.cfm
I can also get you the list spelled out on a cake. But that may take
longer.
I'm working for a new boss that happens to have family in Edinburgh and
its looking promising so far that I may be able to use this fact as
leverage to get him to send me to Scotch 2008.
Now I just have to finish this project so we have the money...
Judah
Sean Corfield wrote:
On 9/12/07, Tom
It should be noted that CF treats Yes and 1 and True (boolean value,
not the string) as logical equivalents. So !0 might return Yes when
output to the screen but that is the same thing to CF as 1 when it comes
to boolean logic. Take the result and format for display as you wish
using Int, Val,
Dave Watts wrote:
snip
Well, if you're using CF, you don't need to do that at the web server level
at all:
http://www.doughughes.net/index.cfm/page-blogLink/entryId-37
You'll notice that this is an SES URL, on an IIS 6 server, that points to a
simple description of how to set up SES URLs
Robertson-Ravo, Neil (RX) wrote:
Granted, while it is a cleaner URL it is in no way friendly, it's an ugly
hack.
An ugly hack? How so? A URL (or more properly a URI) is meant to provide
a descriptive and permanent location for a piece of content. The url I
provided does exactly that. One of
Robertson-Ravo, Neil (RX) wrote:
Well, your URL is simple a rewrite of index.cfm?foo=foo, it is not a
permanent location for this document in that if I bookmark this page and you
delete foo, I will be 100% guaranteed to get it again. This is simple a
facade onto the normal query string
Dave Watts wrote:
You'll notice that this is an SES URL, on an IIS 6 server ...
I would argue that in fact that's not a search engine
friendly url at all. That url gives me no context for what
I'm going to find on the page if I follow the link.
Note the acronym: SES. Not SEF. The last S
Dave Watts wrote:
If you say that URLs are more properly called URIs, that's not semantic
hair-splitting, it's an error, in the same way that it would be an error to
tell someone they shouldn't say car or truck or bicycle, but should
instead say vehicle. When you use the term URL, you are
Robertson-Ravo, Neil (RX) wrote:
I always thought URLs were different than URIs
W3C work on Addressing schemes: http://www.w3.org/Addressing
And in particular, URIs, URLs, and URNs: Clarifications and
Recommendations: http://www.w3.org/TR/uri-clarification/
Judah
Dave Watts wrote:
Now, a reasonable reading of any of that doesn't lead me to the conclusion
that if I say URL, you'd be right to correct me by saying, no, URI. And
that's essentially what you did in your original response. You said that
URLs are more properly called URIs. You didn't provide
Dates aren't supposed to be in quotes. Remove the single quotes and that
should work. If its a column, like date_created, that should always have
the time it was created, then I'd just add the value to the default on
that column in the database. For mssql, you can set the default to
getdate()
Richard Cooper wrote:
Also, you didn't use the cfqueryparam tag
Like this:
'#session.lname#',
cfqueryparam value=#createodbcdatetime(now())# cfsqltype=cf_sql_date /)
There's no need to use cfqueryparam (as far as I know) in this situation
because its not user supplied data. Now() is a
Charlie Griefer wrote:
don't forget that preventing SQL injection attacks is only one benefit
of cfqueryparam. creating bind variables to increase performance is
another :)
Fair enough, although I believe that this is true only if the query is
used in a loop. In this particular instance,
One method to do this is use the ValueList function, which returns a
list of all the values in a query column, then convert the list to an
array and use the ArraySum function.
expense_total = ArraySum(ListToArray(ValueList(getexpenses.expensevalue)));
Judah
Steve Good wrote:
I'm back with
I just installed Eclipse 3.2.1, CFEclipse 1.3 and I downloaded the most
recent version of the Flex Builder trial (2.0.1). I ran the extraction
for the trial and but didn't run the installer. I did get the ColdFusion
Extensions folder with the CF_FB_Extensions.zip file in it. Eclipse
seemed
Dwayne Cole wrote:
When configuring the RDS connection did you get the connection
successs message?
I had a similar problem but on Friday I finally upgraded to 3.2
Eclipse/ 1.3 CFEcplise and set the connection port to 80 (localhost),
it all worked just fine and I really like the results
Thanks Jeff, I'll try going back to 3.2 and see how that goes, then
report back here.
Judah
Jeff Fleitz wrote:
I upgraded my Eclipse build to 3.2.1 about a month ago (with the CFEclipse
1.3 beta build) when the Flex Builder 2.01 update came out, and my RDS
stopped working. It would display
RobG wrote:
Found it! And best of all, IT WORKS!! Amazing! Thank you! Finally,
functional RDS on Eclipse 3.2.1.
Rob
Hmm..still doesn't work for me. Perhaps I need to try this on a machine
with no other versions of Eclipse installed. But so long as I install to
a new folder and have it
Evaluate is almost never needed. Best CF programming practice
discourages its use.
Try this:
cfloop from=1 to=8 index=i
pValue #i# = #MyField[value i _a]#/p
/cfloop
Judah
Scott Weikert wrote:
I think you need:
cfloop from=1 to=8 index=i
pValue #i# =
I would expect an open source version of CF to implement a strong subset
of the CF that most developers use on a daily basis and to implement it
with excellent performance. I suspect that open sourcing the core of CF
would make it so that you had a stable, lower footprint server that
would run
For those of you that are interested in jQuery, I might suggest that you
take a look at DomQuery by Jack Slocum.
http://www.jackslocum.com/blog/2007/01/11/domquery-css-selector-basic-xpath-implementation-with-benchmarks/
I like DomQuery better than jQuery and its 2 to 3 times faster than
Rey Bango wrote:
Hi Judah. This is a bad comparison. DomQuery is a DOM/CSS selector which
can be used as an extension to YUI.
A true comparison would be DomQuery to jQuery's DOM methods, Dojo's
dojo.query() or Dean Edward's cssQuery.
Yes, DomQuery is the DOM/CSS selector portion of the
Dan G. Switzer, II wrote:
The size of jQuery is also considerably smaller than loading the DomQuery
library w/its dependencies.
So, if you're working on a large application where you're going be heavily
relying on lots of DOM manipulation the size of the library may not be that
big of a
You should check out the library again if you haven't recently. Jack has
removed most (I believe now all, but I'm not 100% certain) of the
dependencies on YUI. Its really more of its own library now. If you
click on the Download link on the yui-ext site, you can build your own
set of scripts
That's great to hear Rey. I think it will be a good resource for all
involved. I'm really excited to see all the progress that the various
ajax libraries have made. If you asked me two years ago that we would be
at this point with Javascript and XMLHttpRequest, I would have laughed.
Ajax does
I love the comment system too. I was reading the most recent blog
posting the other day and looking at the comments when I found this one:
Jezza: Quite apart from the rest of this goodness, this commenting
system makes me moist
Honestly, as a developer, I cannot think of a higher compliment :)
Dave Watts wrote:
I shouldn't complain too much, as they don't care how
much it costs and pay quickly - but, is there a more
efficient way of doing this?
triggers.
AJAX. Field-based editing with a simple log. =]
I'm sorry, but that, by itself, is a very silly answer.
AJAX is display
Just so my previous email doesn't get drowned out in a debate over ajax,
if I were tackling this problem, I would have a hidden form field on
each page that lists the fields that have been changed. Attach an
onChange handler to each form field that the sys managers can change.
Have it call a
Robertson-Ravo, Neil (RX) wrote:
Indeed and a Google for sites using it is just as good...
Google allinurl:.cfm
Note though that that won't catch sites, like mine, that use url
rewriting and don't have a .cfm anywhere in the address. Netcraft is
throwing some errors for me, but perhaps
Robertson-Ravo, Neil (RX) wrote:
You are just using URL rewriting, you still have .cfm in the address? It's
just obfuscated by / etc?
No, I use uris such as
http://www.somesite.com/articles/decor/how-to-use-drapes-to-good-effect/
No file extension anywhere. The rewriter takes the incomming
I would do it almost exactly the same way that you did it, except that I
read the requirements differently.
You are outputting fizzbuzz, buzz and fizz instead of i. I don't see
anything in the spec that says instead of, so I presume that its in
addition to. I would print out the number on
Good call. Just goes to show that I shouldn't interpret specs at the end
of the day :)
Judah
Paul Vernon wrote:
snip
I don't see anything in the spec that says instead of
snip
It's on line three below...
Here's the specific one he mentioned:
Write a program that prints the numbers
We're investigating performance issues in a db app that is throwing lock
contention errors. One of the things we are looking into is using the
UPDLOCK optimizer hint (this is for SQL Server 2000). However, we have a
situation where a number of queries are run inside a cftransaction tag.
We
For what its worth, we have a couple of sites for a company that sells
porn dvds. They are really well done, high end content management
systems with a very sophisticated e-commerce setup, affiliate system,
search engine optimization, etc. The fact that they are selling porn
dvds is
a potentially like the one that Judah McAuley
wrote in his recent post.
Cheers,
Chris
~|
Macromedia ColdFusion MX7
Upgrade to MX7 experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion
Rick Faircloth wrote:
I would have to respond that due to the sensitivity of corporations
to their image, that most would immediately instruct their
IT departments to change their technology usage rather than
be associate with *any* industry which would negatively affect
their image.
I think you might need some parentheses to group your search fields
correctly. I've also rewritten the query to use the more explict join
syntax, hope you don't mind, but try this:
SELECT tblMusicProducts.musicprodID
, tblMusicProducts.musicprodname
, tblMusicProducts.musicprodprice
Robertson-Ravo, Neil (RX) wrote:
AFAIK the example and the latter are the same URL and will be treated as
such. I can understand the others, I don't agree with them, which I why you
should publish pages out like that straight off the bat, with no URL
rewriting required.
For what its worth
You don't mention what db you are using but I've had good success on MS
SqlServer writing to a csv file and then doing all the processing to the
database entirely in SQL using the BULK INSERT INTO command. If you're
able to go that route with whatever db you are using, I'd opt for csv
(or tab
Rick you might be right in some audiences but I think you may be wrong
in many other audiences. Larger corporations, for instance, do much more
extensive security filtering. They can block javascript/activeX/etc at
the firewall and they can also enforce browser settings at the desktop
level.
Rick Faircloth wrote:
snip
It's like coding for users of the Opera browser. If they want to be able
to have the best experience on my sites, then install IE.
It's just too much work to cater to every minority group in the virtual
universe.
And this is where I fundamentally disagree. Its
T Lux wrote:
No, the error happens before any code is run. Tracking down the issue
with IEHTTPHeaders as well as Etheral running on the server itself,
it seems that for some reason CF was not receiving the packets either
in the right order or malformed or ... most likely something in the
Is there a good run down somewhere of the pros/cons of cfid/cftoken
versus J2EE session management? I'm realizing that this is an area I
really ought to brush up on.
Thanks,
Judah
Dave Watts wrote:
Thanks for that information guys, I'll go into the admin and
switch it over to J2EE session
I pretty much always use an array of structs for this sort of situation.
I like the descriptive name of the key names in the struct (user.name,
user.lastseen, user.event) and I like the ease of the array functions
for looping over, appending and counting. That way I can just loop from
1 to
Robertson-Ravo, Neil (RX) wrote:
Has it? I thought JRun didn't support 1..5?
Page 18 of the What's New in CF 8 guide
(http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf)
says Scorpio supports JDK 1.6 as the runtime environment. By default,
Scorpio installs and
Mark is right about the fax really being an image (most likely a TIFF). I've
had to do some rather ugly things like this before and what I did was use
ImageMagick to convert the pdf to a tiff, place the second image atop it in
the correct spot, then merge the layers and save it out as a another
I'd also suggest rewriting the query to use ANSI SQL-92 syntax to be more
explicit and likely have it be more portable across db engines and versions.
cfquery name=get_client datasource=#dsn#
select c.*, fg.*, e.*
fromclients c inner join family_groups fg
on
Untested but should work:
cfquery name=getPhysicianRecords datasource=#DSN#
SELECT * FROM Contacts
WHERE Contacts.ContactType = 'Physician'
cfif Len(form.field) AND StructKeyExists(form,form.field)
AND Contacts.#FORM.Field# = '#Trim(form[form.field])#'
cfelse
1 = 0
/cfelse
ORDER BY
Ah, sorry, didn't explain fully. I did a StructKeyExists and a Len to make
sure that the field you are going to evaluate really exists in the form. If
it doesn't, you don't want your cfquery to throw a gnarly error (most
likely) so if the assertion is false, the WHERE clause becomes WHERE 1 = 0
I just consider Evaluate to be sloppy coding. It is (almost) never needed as
it basically tells coldfusion to do something it already is doing: look at
this and see if its a variable. It is by no means the worst thing in the
world but to the extent that you can cut it out of your code, I think
That's a nice list Isaac, but I'm curious about two things.
1) what is the sort versus order by. I'm quite familiar with the order
by clause but I've never heard of a sort clause. Perhaps you mean something
else?
2) You say to not put ANY user-supplied variables into the content property
of a
Are the other fields in your table the same when the email is the same?
Meaning, are the records really duplicate? Or is it just the email that is
duplicate and the other fields may have varying values for two rows that
have the same email? If they do vary, do you care which of the duplicate
rows
As a test case, can you create a datasource with the built in DB (Derby)? It
would probably help to figure out if the issue is with datasources in
general or with mssql 2005 in particular.
Judah
On Wed, Sep 17, 2008 at 1:26 PM, Jeff Chastain [EMAIL PROTECTED] wrote:
And as a follow on, a
, Jeff Chastain [EMAIL PROTECTED] wrote:
Judah,
Creating a data source to Derby works just fine. I can verify the existing
data sources as well as create a new one. The issue only appears when I am
trying to connect to SQL 2005.
Thanks
-- Jeff
-Original Message-
From: Judah
To take this to a new thread...
Does anyone know how to write sql that will return the results in an
editable grid? If I do a right click on a table I can choose to edit top
200 rows and it returns the results in an editable grid and then I can open
up the sql pane above and rewrite the sql and
Short of reinstalling CF (which seems like a good idea at this point) I'd
suggest perhaps looking at your JRE version and reinstalling/upgrading the
JRE version and see if that fixes the obviously borked jdbc driver for
mssql. If you really want to get to the bottom of this and figure out the
jsessionid only exists if you are using J2EE session variables instead of
traditional coldfusion session variables (cfid and cftoken). So you have
either cfid/cftoken or you have jsessionid, depending on which type of
session variables you decide to use. To set which type you use, you go into
the
If this is for an internal application, then I'd suggest creating your own
SSL certs which you can do for free. Your users will get a warning about a
untrusted certificate the first time around, but you can explain to them
that they need to trust it permanently adn then the error will not recur
1 - 100 of 424 matches
Mail list logo