Every NULL Interface PTR error I've seen means you don't have an OLEDB
datasource configured correctly.
Make sure the datasource PARAGON is confingured correctly and is, indeed, an
OLEDB datasource.
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 23,
hihi.. i'm thinking of putting up a forum for a non-profitable drama organisation in
singapore for their members to interact with each other...
so anyone hav any idea i can sign up a free forum for them.?? or anyone here hosting a
free one..??
hmm.. or have any simple codes to spare..? sigh..
hmm.. think i cant do that... coz.. thats will oso return 6 yrs 7 yrs..
blah
hmm.. anyway... i think i got it... thats a datepart in sqlsever oso...
i can use datepart to chk the yr in orderdate = (current yr -5)
hope that can work.. havnt try that out...
thanx anyway pal!!: )
cheers
han
Steven:
Given that business days are generally monday thru friday, you can use the
code below (where date, daysUntilDue & dueDate would be values from your
database).
businessDaysUntilDue: #businessDaysUntilDue#
NOTE that this does not cover holidays (such as the US holidays: P
In exporting data to Excel by using HTML, is there any way to force Excel
to diplay gridlines by default? I can set a border on the HTML table
created, but it only applies to the data area, not the whole worksheet.
Thanks,
Jim
Nope. Same error. However I did namage to find the solution by
guesswork
ALTER TABLE settings ADD BLAH text(10) NULL;
works, and
ALTER TABLE (settings ADD BLAH text(10) NULL);
Does not. It's the surrounding parentheses. @#$%&!!
Thanks for helping out,
--Matt Robertson--
MSB Designs, Inc
Try this:
ALTER table_name
ADD COLUMN column_name column_definitions
Seamus
At 01:56 pm 24/03/02 , you wrote:
>I can't get the supposedly dirt-simple query below to work. Can anyone
>see anything wrong with my SQL? No matter what I do I get this error:
>
>ODBC Error Code = 37000 (Syntax err
I can't get the supposedly dirt-simple query below to work. Can anyone
see anything wrong with my SQL? No matter what I do I get this error:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE
statement.
The field add
I am having trouble getting it to work with my query. With my query second select
never populates. I fail to see why!
Thanks!
Here is a portion of the given sample query output:
MASTER_CAT MCODE CODE CAT FEATURED_POSTING
General Merchandise GEN GENALL All General Mdse. P4069
> So far my code looks like this in application.cfm after some
> thought over the last hour.
>
>
> sessionmanagement="yes"
> sessiontimeout="#createtimespan(0,0,0,0)#">
>
>
> clientmanagement="yes"
> sessionmanagement="yes">
>
> But ding dang dong, its still not working:( Any ideas?
Thi
Hmmm, what if that session setting code is also in application.cfm?
So far my code looks like this in application.cfm after some thought over
the last hour.
But ding dang dong, its still not working:( Any ideas?
- Original Message -
From: "Joseph DeVore" <[EMAIL PROTECTED]>
To
For the past week or so I've been experiencing a very strange error that I've never
seen before.
"Error","TID=1376","03/20/02","15:31:40","Web server provided content data when none
was expected. Data ignored."
My first inclination is that someone has somehow spoofed my page and are trying to
Pardeep,
One way you could accomplish this task is to add code like this to your
Application.cfm file.
Any time the session information isn't available, it will send the user to a
template that you set the session variables in.
HTH,
Joseph DeVore
VeloxWeb Technologies
-Original Mess
I have a Database it has a date in one of the columns. I take that date and
another column in the table which is just an integer an use the DateAdd
function to come up with a second date.
I have:
date1, duedate(created from the DateAdd function), days_until_it_is_due
Now I need to give these
Problem solved..
I forgot to trim the variable... :-)
Mike
- Original Message -
From: "Michael Tangorre" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, March 23, 2002 4:48 PM
Subject: CF menu and output
> Hi everyone.
>
> Can anyone provide me a little directio
Hi everyone.
Can anyone provide me a little direction here.
I have a query that queries the SQL DB for the main categories..
I then do a cfoutput with a query attribute set to maincats.
I get the following:
Hardware
Software
Books
Networking
Now, this is the desired results, but what I am tryi
> PROVIDER="OLEDB"
if i recall, sp called via OLEDB might need to be wrapped within
a SET NOCOUNT ON/OFF block.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.325 / Virus Database: 182 - Release Date: 2/19/2002
_
Hi, I'm having a problem using session variables. They are set to time out
at 120 (2 hours).
However if someone does NOT close his browser and then they try to come back
to the site after a couple of hours, they get an error message.
Is there a way to flush and totally expire session variables w
Errr...actually my regular expression pattern was off. This works for IE 5.5, Netscape
4 and Netscape 6:
var re = /\n/g;
document.myform.ta.value = document.myform.ta.value.replace(re, "");
Of course, if you hit the back button you see all the s so there's probabaly a
better solution out ther
CF Talk List
I am writing my first cold fusion stored procedure call. I
am getting an error I do not understand and do not know how
to correct. I am unable to find any information on the
error, and I am hoping somebody out there can give me a
lead. Here is the cold fusion code I am using to ca
CF Talk List
I am writing my first cold fusion stored procedure call. I
am getting an error I do not understand and do not know how
to correct. I am unable to find any information on the
error, and I am hoping somebody out there can give me a
lead. Here is the cold fusion code I am using to ca
> > I am not aware of the MM strategy for Flash. However,
> > I found Flash to be more limited, specialized, and
> > harder to learn than CF. If MM plan to make CF scripting
> > available on the desktop, I applaud them, whatever
> > vehicle they choose!
>
> This paper may be of great interest
Hi
i tried your suggestions:
I still get the same ouotput. THe outout I get is the same output I get if I
run it at the command line with no arguements. I added the USE to
the file but still get the same problem.
Thanks
> >-Original Message-
> >From: Scott Van Vliet [mailto:[EMAIL PR
CF_AccessMonger is one I wrote, and recently upgraded to use user names
instead of ID numbers.
You'll find boatloads of this sort of app in the Developers Exchange.
Search for password protection.
--Matt Robertson--
MSB Designs, Inc.
http://mysecretbase.com
-Original Message-
From: N
http://www.moock.org/unity
Colin Moock is the god father of Flash, and has already created a socket
server and client objects (.as files) for building chat applications.
Pretty insane.
I also build a chat application based on Flash Services from NEO, but I
don't think I can let you guys see it (
On 3/23/02, Jochem van Dieten penned:
>Is this going to be a (free?) product someday? I would be interested.
Close to free. :) Probably 10 bucks. Almost everyone will spend 10
bucks. :) May may a free version which limits the number of users to
10 or something.
--
Bud Schneehagen - Tropical W
Hi All.
Is there a software that will the given list of procs
on a database on a given server?
right now, I have to install each proc at a time on
the database. It would be much nice if all the procs
would be installed automatically if the list of the
procs would be provided.
Also, is there an
Sorry, meant to say flash MX
"Success is a journey, not a destination!!"
Doug Brown
- Original Message -
From: "Douglas Brown" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, March 23, 2002 7:51 AM
Subject: Re: Help me test Flash Chat app?
> BudJust a t
File size, maybe?
-- jon
-
jon roig
senior manager, online production
epilepsy foundation
tel: 215.850.0710
site: http://www.epilepsyfoundation.org
email: [EMAIL PROTECTED]
-Original Message-
From: Abraham Lincoln [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March
BudJust a thought if you use xml, you can keep your connection open for clients
using flash 5 and XMLSocket. The down fall to doing so would be cpu usage and memory.
IE:
// Create a new XMLSocket object
sock = new XMLSocket();
// Call its connect method to establish a connection with port
Jochem,
That worked! Thanks! Here's something strange though:
This works in Netscape 6.1:
document.myform.ta.value = document.myform.ta.value.replace(/[\r\n]/g, "");
And this works in IE 5.5 and Netscape 4:
document.myform.ta.value = document.myform.ta.value.replace(/[\r\n][\r\n]/g, "");
So it
Dina Hess wrote:
> Javascript gurus,
>
> I thought I'd solved the textarea problem, but when I test my 'solution' in Netscape
>6.1 and Netscape 4, the Javascript is completely ignored!! I don't get it.
>
> Here's what works well in IE 5.5:
>
>