|
Dear All,
I'm facing problem while accessing my web application through IE5.0 in Windows 98. I've a combo box in page and whenever I change the option a frameset is created with two frames through "document.write()" of Javascript.
While creating the frames two seperate requests from two frames goes to server, but somehow whenever the lower frame request is send IE crashes.
PS: this doesn't happen in WinNT and Win2K.
please help.
thanks
Gaurav
Gaurav
|
|
|
|
|
I created a connection using Visual Studio´s 'Connect to a Database' tool,
from the Tools menu and the connection seems to be OK.
Then I created an aspx page to connect using the connection string that was
created by VS and an error msg occurs :
private void Page_Load(object sender, System.EventArgs e)
{
OleDbConnection myCon = new OleDbConnection();
myCon.ConnectionString = "Provider=SQLOLEDB.1;Integrated
Security=SSPI;Persist Security Info=False;User ID=KA;Initial
Catalog=Northwind;Data Source=KA;Use Procedure for Prepare=1;Auto
Translate=True;Packet Size=4096;Workstation ID=KA;Use Encryption for
Data=False;Tag with column collation when possible=False";
myCon.Open();
}
The error msg is : Login failed for user 'KA\ASPNET'.
==Help! Ken.
|
|
|
|
|
It is very possible that you didn't give ASPNET, the account that is created for ASP.NET worker processes, access to your Northwind database. I would just look to see if you have granted access to this first.
HTH
Nick Parker
|
|
|
|
|
I re-installed SQL Server and used a non-blank password. It´s alright now
|
|
|
|
|
Hi,
I have a created a treeview based form which displays the files on the server. I want to be able to display the contents of files (for eg. notepad text) in a textarea and edit and save it to its location. Any ideas or insight will be very helpful.
Thanks.
|
|
|
|
|
|
I made a COM object and using it in my ASP. Now I want to use a typelib, like with ADO for example. How to do that? I remember I saw an article here about this thingy, but couldn't find it now
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
Need Web-based database administrator? You already have it!
|
|
|
|
|
Philip Patrick wrote:
Now I want to use a typelib, like with ADO for example
Are you looking for a way to include a file like the ADOVBS.INC in a particular page?
Nick Parker
|
|
|
|
|
Not exactly. The problem is that the COM object can be used by C++ application also, so itself contains several enams, and I want to access them from ASP.
Like if you inlcude this code before using ADO:
<!-- METADATA TYPE="typelib" uuid="00000205-0000-0010-8000-00AA006D2EA4" -->
You will be able to use adLockReadOnly for example (and other constants) without using additional INC file.
INC file won't very useful in my case, since every change in enam in COM object, I need to update the INC file also. And the second, INC file will be compiled with ASP file itself, so it can slow and overload the Server.
That's why I'm looking for the second way
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
Need Web-based database administrator? You already have it!
|
|
|
|
|
Hi
how can i programmatically add rows to a displayed html table ?
Bryce
|
|
|
|
|
Using Classic ASP you would just build your SQL command as per normal, but instead of doing a SELECT command you would do an INSERT command.
Or you can use the .AddNew and .Fields methods of the recordset object to add it to an updateable recordset and then use .Update to push the new entry up to the database. You can use .UpdateBatch if you want to do a bunch of entries at once.
Personally I use stored procedures instead. Gets all that nasty SQL code out of your ASP page and you can pass data to a stored procedure using its parameters. All this adds up to never needing anything but the firehose cursor and a read-only lock type. This can be a dramatic performance increase. Of course, you do have to have acess to your DB server to do this.
Jason Jystad Cito Technologies Sonork ID: Ogami(100.9918)
An object is simply a referenced thingy. --Larry Wall (Programming Perl)
|
|
|
|
|
oh hell
i meant a table onthe displayed page
not in a database
sorry about the confusion
Bryce
|
|
|
|
|
|
|
how to create crystal report at runtime in vb.net???
|
|
|
|
|
I need to trap the up and down arrows on the keyboard in both IE and Netscape. I don't beleive this is possible, if it is could someone lead me in the right direction. Thanks in advance.
Nick Parker
|
|
|
|
|
Maybe you will say that you knew that, but I was hunting this bug a half day...
In VBScript (I think same in VB then) Null is different from any other value and I don't quite understand the logic behind this. Here is a simple code. You can place it in some ASP file and look what you'll get.
<%
dim intNull, intTwelve
intNull = Null
intTwelve = 12
if intNull <> intTwelve then Response.Write "They are different!<br>"
if intNull = intTwelve then Response.Write "They are same!<br>"
%>
Which "if" you think will be True ? I'll tell ya - None of them!
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
Need Web-based database administrator? You already have it!
|
|
|
|
|
In VB you shouldn't use the keyword Null. Instead you are should use the keyword Nothing. Since Null (or Nothing) has no value it can't be compared to a value. You're sample would then look like this:
<%
dim intNull, intTwelve
intNull = Nothing
intTwelve = 12
If (intNull Is Nothing) Then
Response.Write("intNull is NULL!<br>")
ElseIf intNull <> intTwelve Then
Response.Write("They are different!<br>")
ElseIf intNull = intTwelve Then
Response.Write("They are same!<br>")
Else
Response.Write("How'd I get here?!<br>")
End If
%>
Kelly Herald
Software Developer
Micronpc, LLC
|
|
|
|
|
Well, the problem was, that I'm fetching data from database and sometimes it is Null, not Nothing.
So the simple "if a <> b" will look like:
If a <> b or (IsNull(a) and not IsNull(b)) or (not IsNull(a) and IsNull(b))
And this is nonsence. How can one say that "Null <> 12" is false? Ok, I heard from someone that Null is not nothing, but everything. But in such case the statement "Null = 12" should be true. But it is not.
I know, I know, I found a documentation on this. It says that comparing to Null always returns False. For example Oracle uses same comparision as VB. But why?... as I said, it doesn't make sence at all.
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
Need Web-based database administrator? You already have it!
|
|
|
|
|
Oh and forgot.
Why it cannot be compared? Maybe I'm looking at VB from my C++ position, but still... The computer has only 1 or 0, ON or OFF, that's all. No third part. Suddenly I see that VB, Oracle and maybe some other products pushes out a new state... what is that? 1.5? A half turned ON? ROTFL
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
Need Web-based database administrator? You already have it!
|
|
|
|
|
Philip Patrick wrote:
The computer has only 1 or 0
When things don't work right it makes you question if it's writing a 2 between the 1 and 0's sometimes huh.
If you are at all concerned that you may possess a Null value in one of your variables you should use the isnull([YourVariableHere]) built-in function to check, don't say <> to some other variable.
Nick Parker
|
|
|
|
|
Nick Parker wrote:
you should use the isnull
But look my previous post, what kind of "If" I'm getting because of this.
Guys, C++ rulez
In VB, Oracle (SQL Server also, I checked it) developers made a phylosophy, but this is a world of Mathematics, there is no place of thought what is "null" or "nothing". I'm really disapointed
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
Need Web-based database administrator? You already have it!
|
|
|
|
|
Its got nothing to do with VB, its to do with databases. If a database field has no value it is NULL. You can setup database rules to allow or disallow this. That is different from saying that the field has an empty string, or a 0.
To get around the problem, either make the field not allow nulls (if that is okay by your schema), or for strings, you can use Trim(rs("a") & " ") which will return an empty string if the field is null, or if its an empty string.
--
David Wengier
Sonork ID: 100.14177 - Ch00k
|
|
|
|
|
I know, I know. I already found a solution in my code. But still don't understand why simple "Null <> 12" returns false. Just don't see logic behind this
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
Need Web-based database administrator? You already have it!
|
|
|
|
|
Philip Patrick wrote:
I'm really disapointed
Sorry to upset but there are only so many ways that you can check something, in VB or C++. Good Luck.
Nick Parker
|
|
|
|