JimmyCrackedCorn
Posts: 583
|
| Posted: 12/07/2008, 8:26 PM |
|
In my search panel I have a listbox where I want to combine LastName and FirstName in the text portion of the listbox. So, I set it up like this,
SELECT ID, LastName, LastName & ", " & FirstName AS FullName
FROM tblPersonnel
ORDER BY LastName
Then I set the Bound Column to ID and the Text Column to FullName.
It works perfectly inside CCS. When I hit F9 to publish and put it on my web server, the page will not load and I get the following error,
ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.
/systems/Classes.asp, line 3338
If I delete this,
LastName & ", " & FirstName AS FullName
and set the Bound Column to ID and the Text Column to LastName it works in CCS AND on my server.
Any ideas as to how this should be set up? And why it works in CCS but not on the server? Thanks!
CCS Version 3.1
ASP
_________________
Walter Kempees...you are dearly missed. |
 |
 |
mentecky
Posts: 321
|
| Posted: 12/07/2008, 11:34 PM |
|
JCC,
Have you tried
LastName + ", " + FirstName AS FullName
Rick
_________________
http://www.ccselite.com |
|
|
|
JimmyCrackedCorn
Posts: 583
|
| Posted: 12/07/2008, 11:45 PM |
|
yep. tried that. same error. thanks.
anyone have any other ideas?
_________________
Walter Kempees...you are dearly missed. |
|
|
|
mentecky
Posts: 321
|
| Posted: 12/08/2008, 12:06 AM |
|
Sorry, try:
LastName + ', ' + FirstName AS FullName (Single quotes)
Rick
_________________
http://www.ccselite.com |
|
|
|
JimmyCrackedCorn
Posts: 583
|
| Posted: 12/08/2008, 12:16 AM |
|
 it worked!
thank you!!! thank you!!! thank you!!!
any idea why the double quotes would not work on the server but would work locally in CCS?
_________________
Walter Kempees...you are dearly missed. |
|
|
|
mentecky
Posts: 321
|
| Posted: 12/08/2008, 12:21 AM |
|
JCC,
Great! Glad to help.
If you are using Access locally it is a bit looser on SQL syntax. Maybe that's the difference.
Rick
_________________
http://www.ccselite.com |
|
|
|
datadoit
|
| Posted: 12/08/2008, 6:04 AM |
|
I'm scratching my head as to why it worked at all for you...
Seems to me the SQL should be:
SELECT ID, LastName, CONCAT(LastName,', ',FirstName) AS FullName
What's the database?
|
|
|
|
JimmyCrackedCorn
Posts: 583
|
| Posted: 12/08/2008, 7:10 AM |
|
using Access locally and on the server
_________________
Walter Kempees...you are dearly missed. |
|
|
|
