|
Brendan Vogt wrote:
If I have an empty textbox, and the related field in the database table does not require a value, is better to write the value as '', or should I enter a NULL value?
That depends on your datamodel. A NULL value is typically defined as meaning an absence of data. Whereas an empty string could mean that there is data and it was an empty string.
I read recently, although I've not tested this myself, that adding NULL values to a database slows it down and so should be only used where necessary. In other words you should only use it if you genuinely have a need to represent a gap in the data.
There is a System.DBNull[^] class in the .NET Framework to represent Null values in a database.
When you create your SQL Command you assign DBNull.Value to the relevant parameter. When you read data from the database you need to check the object being returned to see whethere it is a DBNull.Value before doing anything else with it. This adds extra steps to the process when you read and write data to the database.
If you still can't decide one way or the other: I would say that for a description field, an empty string would be better than a null value.
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
Not getting the response you want from a question asked in an online forum: How to Ask Questions the Smart Way!
|
|
|
|
|
|
I'm still using plain ASP, and not ASP.NET
|
|
|
|
|
Sorry, I'm not familiar with SQL Server/ASP.
|
|
|
|
|
I use the GetRows() method to work with my fields retrieved from a table query in ASP.
After I open the recordset, I do the following:
If Not objRs.EOF Then
arr = objRs.GetRows()
End If
I have 3 questions with regards to using the GetRows() method:
1. arr is used as an array. I don't have much experience with arrays. Must they be set to nothing when I have finished using it? Something like Set arr = Nothing
2. I was told to do what is necessary with the recordset and to close it ASAP. If I return one row from the table, can I use the recordset to populate my fields, or should I rather assign it to an array like I did above? I just need to know when is it most appropriate to use the GetRows() method, only when many rows are returned, or for a few rows as well?
3. How would I do this same thing in Visual Basic 6? I don't know how to declare an array in VB6.
Your help and time is appreciated!!!
Thanks
BRENDAN VOGT
|
|
|
|
|
We have an on-line computer support site that resides on our server and is accessed via our Intranet. Our employees use it to submit computer related problems to our IT personnel. One of the required fields they must input is their local computer name. Unfortunately, most of our employees have NO idea how to obtain this information.
I would like to have a script that will automatically pull thier local computer name and input it into the "computer name" field on said page.
I've been unsuccessful scouring the web for such a beast, if anyone has the complete code and is willing to share, I would appreciate it very much.
Thank you!
|
|
|
|
|
|
See the Win32 API function GetComputerName(LPSTR ComputerName, DWORD *dwpSize);
You can write a module around this function (Browser Helper Obj, COM component, ActiveX, etc.) and have it installed on the client's computer.
onwards and upwards...
|
|
|
|
|
|
I have an error:
Microsoft JScript runtime error '800a01b6'
Object doesn't support this property or method
/aspforum/onetimesetup.asp, line 4
--------
<%@ Language=JavaScript %>
<%
// create the database
Server.Execute("createdatabase.asp"); //<--- line 4
// createdatabase.asp is same directory with current asp file.
OS:win98, install PWS
|
|
|
|
|
I just upgraded from XP Home to Pro and I installed IIS but there is no shortcut to it in Admin. tools. My localhost is up and IIS Admin is running as a service. Anyone know how get my shortcut so I can open the IIS snap-in?
"Half this game is ninety percent mental."
- Yogi Berra
|
|
|
|
|
Hello, I am interested in
creating a standard cookie file from
a .exe application, that will later
be consumed by a intranet
application via the ie browser.
(I'd like to be able to generate
client side cookie files without without actually
running the ie browser).
is this possible from a client side only app (.exe)?
any help is appreciated.
sas
|
|
|
|
|
I received a suggestion from another forum
to look at InternetSetCookie() et al..
looks good so far. fyi.
sas
|
|
|
|
|
Hello
Does anybody know an efficient solution for logging in ASP-WebApplications? - Means i want to log the method-call -> method-name and the time in a file.
Thanks in advance for your tipps.
Regards
pat
|
|
|
|
|
Hello,
I have written a Web-Service and an ASP.NET Client and i wanted to use the SoapLogger from . I do all the tasks quoted in this paper. (for instance copy the quoted code from this paper in my class-file.).
But when i then execute my ASP.Net Client and call a Web-Service Method, where i add the SoapLogger Attrribute in the WebService-Directive the following error occurs:
Server Error in '/ReservationClient' Application.
--------------------------------------------------------------------------------
Client found response content type of '', but expected 'text/xml'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: Client found response content type of '', but expected 'text/xml'.
Source Error:
Line 515: [System.Web.Services.Protocols.SoapDocumentMethodAttribute("http://unet.univie.ac.at/~a0106514/webservices/PersonLogin", RequestNamespace="http://unet.univie.ac.at/~a0106514/webservices/", ResponseNamespace="http://unet.univie.ac.at/~a0106514/webservices/", Use=System.Web.Services.Description.SoapBindingUse.Literal, ParameterStyle=System.Web.Services.Protocols.SoapParameterStyle.Wrapped)]
Line 516: public string PersonLogin(string sEmailAddress, string sPassword) {
Line 517: object[] results = this.Invoke("PersonLogin", new object[] {
Line 518: sEmailAddress,
Line 519: sPassword});
Source File: C:\Inetpub\wwwroot\ReservationClient\Web References\WebService\Reference.cs Line: 517
Stack Trace:
[InvalidOperationException: Client found response content type of '', but expected 'text/xml'.
]
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) +1488
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) +218
ReservationClient.WebService.Reservation.PersonLogin(String sEmailAddress, String sPassword) in C:\Inetpub\wwwroot\ReservationClient\Web References\WebService\Reference.cs:517
ReservationClient.Login.ImageButton1_Click(Object sender, ImageClickEventArgs e) in C:\Inetpub\wwwroot\ReservationClient\Login.aspx.cs:90
System.Web.UI.WebControls.ImageButton.onclick(ImageClickEventArgs e) +109
System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +69
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1258
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
Can please anybody help me and is able to say me what went wrong??
Regards
Patrick
|
|
|
|
|
In the application, I am using two windows (parent and child). On session expiry, the child window which is the current one is redirecting the user to the login page by using the following code.
if (session("UserName") = "") then
Response.Redirect("expire.asp")
end if
At this time, I want to close the parent window. How can I do this. Please help !!
|
|
|
|
|
You can't from the server side
|
|
|
|
|
Mark is right - you'll have to have some client side javascript to take care of that parent window. A simple parent.close() should do it. (Taking that from memory - probably won't work  Make sure to check if the parent window is there, otherwise you'll get an error from the login page when first going to it.
|
|
|
|
|
i'm asp developer , i recently turn into asp.net,
i face many prblems such as
on asp i can write
<%sub example(param)%>
<h1> <%=param%> </h1>
<%end sub%>
then i can use it as follows
<body>
<%example("ashraf")%>
</body>
so that it will apply the sub, can i do something like that with asp.net??
i'm using vb.net
thanx all
|
|
|
|
|
Hi,
I'm writing a credit card application and one of the things that I need to determine is if the credit card is a corporate card or a purchase card. If it is, I need to display the user another screen to capture additional information. I have a database that contains card ranges that are cards that fall into this category.
Since I've never written a Web Service, I'm not exactly sure what they are for. But I'm thinking that this is a perfect Web Service. I can load the card ranges into a table in memory and then issue a request to the Web Service to determine if this card is a corporate card. This would save a trip out to the database for every card authorization.
Is this what you use a Web Service for?
Thanks,
Glenn
|
|
|
|
|
|
I wish to test out my website using IIS.
Problem is, being that the website is normally hosted online, I use the following virtural include(s) quite a bit.
Obviously this is generating an error when I try and run the website on my computer using IIS.
Is there a simple way around this with out having to go through the whole website changing all the includes from virtual to file...
I eagerly await any reply’s!!
---
Peter M
|
|
|
|
|
Just to update this issue....
The error received is:
________________________________________
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
Technical Information (for support personnel)
• Error Type:
Active Server Pages, ASP 0126 (0x80004005)
The include file '/Includes/Admin/MetaTags.asp' was not found.
/cullyonline/Default.asp, line 7
• Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
• Page:
GET /cullyonline/Default.asp
• Time:
24 August 2004, 17:28:00
• More information:
Microsoft Support
________________________________________
The line it’s referring to is
Line 7:
I’m using IIS Version 5.1
This site does work online, and has been so for the last couple of years. Its just now I wanted to see it working using IIS. Its basically the first include file in the html, and if I remove this line, it will have the same fault on the next virtual include
---
Peter M
|
|
|
|
|
iam new in programming field.i want to knw whether it is possible to create
Two CSS in a single ASP page.
if so ,plz i want to know how it works,plzzzzzzzzzzzzzzz itz very urgent
UMA
|
|
|
|
|
Need to be a bit more specific.
If it's for a skin like app then try this tutorial
-> Skin'n your site with ASP/CSS [ForgetFoo.com]
If you want two style sheets in one page then simply do this with a single CSS tag:
<br />
<style type="text/css" media="screen"><br />
@import "sheet1.css";<br />
@import "sheet2.css";<br />
</style> <br />
Wolfie-o
« WolfWeb.zero13 | Wolf.Studio »
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
