| |
 error message!!! in DB MSG |
Author
seopo
Date
01/04/2001 11:28 AM |
I have a problem in DB MSG at brinkster
It is in a SQL statement...
'select * from tablename'--> It is well operated...
But 'delete from tablename' or 'update set No =1 where No=3...etc'----> It is not well operated....
There appears error message
It is.....
Query Results
ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.
/DatabaseManager.asp, line 473 ""
I want to find a way...
please! give me an answer.... |
| |
 RE: error message!!! in DB MSG |
Author
nhsa
Date
01/04/2001 3:00 PM |
DELETE * FROM tablename WHERE stringfield='stringvalue'
UPDATE tablename SET stringfield='hello' WHERE numberfield=10
HTH
Nige - nhsa@yahoo.com |
| |
 RE: error message!!! in DB MSG |
Author
hiflyer
Date
01/05/2001 4:28 AM |
Nige is right with his SQL string examples, but the error you are getting is because you are trying to perform operations on a recordset which has been closed. If you look at your code you will probably find a line such as dbConn.close, or RS.close or Set RS = nothing somewhere before line 473.
HTH,
Bod.
www5.brinkster.com/hiflyer |
| |
 writing db results to multiple pages |
Author
shiaislamasp
Date
01/04/2001 7:56 PM |
how do i write say 10 db results, from a select statement, on a page, then link to another page, with the next 10, and so on..
I would be very grateful for any help
Thank you |
| |
RE: writing db results to multiple pages |
Author
adom
Date
01/05/2001 3:33 AM |
Asuming your database is sorted by a incrementing value you can use the BETWEEN statement in your querry.
That is on the first page you do:
SELECT * from Table WHERE OrderValue BETWEEN 1 and 10
Then you pass along the last value to the next page ""show_rewults?start=11"" for example and go from there
SELECT * from Table WHERE OrderValue BETWEEN 11 and 20
and so on? |
| |
what is this error... It works on my iis |
Author
feiyeung
Date
01/04/2001 5:02 AM |
keyword =url =comment = there is an error
Microsoft JET Database Engine error '80040e09'
Cannot update. Database or object is read-only.
/input.asp, line 39
it wokrs on my iis5.0 fine. It is because the db dir isn't set rite or what?
anyone has any ideaS
FELIX |
| |
dynamic queries |
Author
vpl
Date
01/03/2001 3:21 AM |
i want to rerieve the value from the database based upon the selection criteria that is out of ten text fields if the user select two values means,i should get the output based upon that value.the query should be a single query. |
| |
RE: dynamic queries |
Author
product
Date
01/03/2001 6:49 AM |
The Best Way is to write SQl Statement .
For Example
Select Empno,Ename from emp where empno = '1001' or Sal >100
if you can provide a code, will try to provide a solution. |
| |
CF Custom Tag directory??? |
Author
Michael
Date
01/19/2001 5:18 PM |
Hi,
how do i change the default directory of the CUSTOM TAG where CF_ tags are places to a directory of my choice????
thankxs |
| |
CF Custom Tag directory??? |
Author
vpl
Date
01/19/2001 5:45 PM |
You can edit the registry key HKEY_LOCAL_MACHINESOFTWAREAllaireColdFusionCurrentVersionCustomTagsCFMLTagSearchPath
And then restart the server.
/Ruben |
|
| |
dynamic queries |
Author
vpl
Date
01/03/2001 3:21 AM |
i want to rerieve the value from the database based upon the selection criteria that is out of ten text fields if the user select two values means,i should get the output based upon that value.the query should be a single query. |
| |
RE: dynamic queries |
Author
product
Date
01/03/2001 6:49 AM |
The Best Way is to write SQl Statement .
For Example
Select Empno,Ename from emp where empno = '1001' or Sal >100
if you can provide a code, will try to provide a solution. |
| |
what is this error... It works on my iis |
Author
feiyeung
Date
01/04/2001 5:02 AM |
keyword =url =comment = there is an error
Microsoft JET Database Engine error '80040e09'
Cannot update. Database or object is read-only.
/input.asp, line 39
it wokrs on my iis5.0 fine. It is because the db dir isn't set rite or what?
anyone has any ideaS
FELIX |
| |
error message!!! in DB MSG |
Author
seopo
Date
01/04/2001 11:28 AM |
I have a problem in DB MSG at brinkster
It is in a SQL statement...
'select * from tablename'--> It is well operated...
But 'delete from tablename' or 'update set No =1 where No=3...etc'----> It is not well operated....
There appears error message
It is.....
Query Results
ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.
/DatabaseManager.asp, line 473 ""
I want to find a way...
please! give me an answer.... |
| |
RE: error message!!! in DB MSG |
Author
nhsa
Date
01/04/2001 3:00 PM |
DELETE * FROM tablename WHERE stringfield='stringvalue'
UPDATE tablename SET stringfield='hello' WHERE numberfield=10
HTH
Nige - nhsa@yahoo.com |
| |
writing db results to multiple pages |
Author
shiaislamasp
Date
01/04/2001 7:56 PM |
how do i write say 10 db results, from a select statement, on a page, then link to another page, with the next 10, and so on..
I would be very grateful for any help
Thank you |
| |
RE: writing db results to multiple pages |
Author
adom
Date
01/05/2001 3:33 AM |
Asuming your database is sorted by a incrementing value you can use the BETWEEN statement in your querry.
That is on the first page you do:
SELECT * from Table WHERE OrderValue BETWEEN 1 and 10
Then you pass along the last value to the next page ""show_rewults?start=11"" for example and go from there
SELECT * from Table WHERE OrderValue BETWEEN 11 and 20
and so on? |
| |
RE: error message!!! in DB MSG |
Author
hiflyer
Date
01/05/2001 4:28 AM |
Nige is right with his SQL string examples, but the error you are getting is because you are trying to perform operations on a recordset which has been closed. If you look at your code you will probably find a line such as dbConn.close, or RS.close or Set RS = nothing somewhere before line 473.
HTH,
Bod.
www5.brinkster.com/hiflyer |
| |
CF Custom Tag directory??? |
Author
Michael
Date
01/19/2001 5:18 PM |
Hi,
how do i change the default directory of the CUSTOM TAG where CF_ tags are places to a directory of my choice????
thankxs |
| |
Pictures embeded in Email |
Author
Rocky Ang
Date
01/19/2001 5:37 PM |
I am trying to use the cfmail command to send HTML based emails. This can be easily done by referencing the pictures within the mail to download from an url.
However, this caused a problem when the recipient tries to read the mail offline. The pictures disappeared.
A way to solve this would be to embed the pictures and send the pictures with the mail. Is there any way to do this with cold fusion.
Any prompt help would be deeply appreciated by a desperate guy. |
| |
CF Custom Tag directory??? |
Author
vpl
Date
01/19/2001 5:45 PM |
You can edit the registry key HKEY_LOCAL_MACHINESOFTWAREAllaireColdFusionCurrentVersionCustomTagsCFMLTagSearchPath
And then restart the server.
/Ruben |
| |
relative |
Author
Glenn Channon
Date
01/19/2001 6:37 PM |
Try relative URL's http://www.domainname.com/images/imagename.gif |
| |
No Use |
Author
feiyeung
Date
01/19/2001 6:45 PM |
No use, when the user is offline and tries to read the mail
the pictures are missing.
The pictures are ok when the user is online |
|
|
