Web Development

Dan Pomerchik4-Apr-02 0:57

Dan Pomerchik

4-Apr-02 0:57

mmm very weird, I've used the same code line and it worked fine. Are you sure that the server supports the Session object?

- Dan
"Intel inside - Idiot outside"

code dope4-Apr-02 1:40

4-Apr-02 1:40

thanks for your reply..

yes I think so, because if I give it a string literal:

e.g. <%Session("BufferValue") = "A string literal";%>

it works fine!

It gets used on a Form on another page, which, again, works fine if I give it the string but not the variable, as follows:

<FORM>
...other stuff
<input type=hidden name= FName value=<%=Session("BufferValue")%>>
</FORM>

Unfortunately though I can't give it a string.

thanks again for your help Smile | :)

code dope.

Paul Watson4-Apr-02 2:13

Paul Watson

4-Apr-02 2:13

code dope wrote:
can't store an Intrinsic Object in a Session variable"

Looks pretty good to me but perhaps I'm still in the C++ mindset!

Any help would be appreciated - thanks.

You cannot use buffer as a variable name as it is an "intrinsic object" (whatever that means.) Check out Response.Buffer

So just change buffer to something else, like strBuffer etc.

regards,
Paul Watson
Bluegrass
Cape Town, South Africa

The greatest thing you'll ever learn is just to love, and to be loved in return - Moulin Rouge

code dope4-Apr-02 2:25

4-Apr-02 2:25

thanks , Paul.

In fact, I wasn't using "Buffer" as my variable name - I just used that here because the actual names are not meaningful unless you know what the project is all about, and, for various reasons, I am not allowed to make that public knowledge.

However, I will try using various names just in case I have stumbled across something that is "Intrinsic!!" (whatever that is!)

thanks again - I'll let you know what happens.

code dope.

code dope4-Apr-02 2:40

4-Apr-02 2:40

No, it didn't work.

I tried this:

<%
var thingy;
thingy = Request.QueryString("A_Value")
Session("Batch")= thingy;
%>

and got this:

"An intrinsic object cannot be stored within the Session object."

By the way, the return from "Request.QueryString("A_Value")" is just a character string - actually it's a File name with nothing other than numbers and letters, so there shouldn't be a problem there.

any more ideas?

code dope.

Philip Patrick4-Apr-02 4:05

4-Apr-02 4:05

Maybe this is an array? For example if you have several INPUTs with same name attribute? Try to use like Request.QueryString("value")(1) (dunno exactly how in Javascript, maybe it starts from 0?)

Well, just another thought

Philip Patrick
Web-site: www.saintopatrick.com
"Two beer or not two beer?" Shakesbeer

Need Web-based database administrator? You already have it!

code dope4-Apr-02 4:33

4-Apr-02 4:33

i love you forever & want to have your babies!!!!

only kidding!

IT WORKED! I changed the code to:

<%
strValue = Request.QueryString("A_Value")(1);
Session("Batch")= strValue;
%>

Seriously though, thanks a lot for your suggestion. And everyone else who had a go. I was really getting ****ed off with it. It looked as though the assignment to the Session variable was the culprit, when it was actually not getting the value from the Query String. Strange, though, because I use that line to get the value from the Query string in several other places and it never fails. Oh well, who cares!!!

Thanks again. Smile | :)

code dope.

Philip Patrick4-Apr-02 4:39

Why cant I use RecordCount of recordset

4-Apr-02 4:39

Oh well, I'm glad it is working now Smile | :)

Wasn't sure because of differences between Javascript and VBScript (I'm using the last one to write ASP)

Philip Patrick
Web-site: www.saintopatrick.com
"Two beer or not two beer?" Shakesbeer

Need Web-based database administrator? You already have it!

Tili3-Apr-02 15:10

Tili

3-Apr-02 15:10

strOpen= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db10.mdb"

'cnn.Open = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db10.mdb"

Set rst = Server.CreateObject("ADODB.Recordset")
strSQL= "SELECT * FROM Students"

rst.Open strSQL,strOpen,adOpenKeyset ,adLockOptimistic

Response.Write rst.RecordCount & "
"

/// I always get record count as -1
// Why cant I just use RecordCount property
Confused | :confused:

In my dream, I was dorwning my §orrow§
But my §orrow§, they learned to §wim

Larry Antram3-Apr-02 16:05

Larry Antram

3-Apr-02 16:05

look up the CursorType property in MSDN and set it appropriately before doing the open. here's a link:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdprocursortype.asp

jscript would be something like this:

rs = Server.CreateObject( "ADODB.Recordset" );
rs.CursorType = 1; // <--- set this correct
rs.Open( sCmd, con );
// then rs.RecordCount should work

Tili3-Apr-02 16:25

Tili

3-Apr-02 16:25

adOpenKeyset

when i use this adOpenKeyset this is according to MSDN should allow me to count records. But OK I'll try using 1 instead adOpenKeyset

Thanks

In my dream, I was dorwning my §orrow§
But my §orrow§, they learned to §wim

Philip Patrick3-Apr-02 20:24

3-Apr-02 20:24

Right, but with client side cursor.:

rec.CursorLocation = adUseClient

and you don't have to use Keyset. The best way to boost performance is to use Client-side cursor (adUseClient) with forward-only and read-only recordset (adOpenForwardOnly, adLockReadOnly)

and RecordCount works fine with such Recordset

Philip Patrick
Web-site: www.saintopatrick.com
"Two beer or not two beer?" Shakesbeer

Need Web-based database administrator? You already have it!

Re: Excellent Free Technical eBooks

SimonS4-Apr-02 7:09

SimonS

4-Apr-02 7:09

It's a good plan to disconnect the recordset first, otherwise your page will have too much of a chatty relationship with the DB and your performance will be less than good.

Cheers,
Simon

X-5 452 rules.

Philip Patrick3-Apr-02 20:29