Wrox Programmer Forums
|
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Page 3 of 19 1 2 3 4 5 6 7 8 9 10 11 12 13 Last »
Showing results 51 to 75 of 463
Search took 0.04 seconds. Search: Posts Made By: madhukp
Forum: Classic ASP Basics February 15th, 2005, 06:53 AM
Replies: 1
Views: 1,067
Posted By madhukp
You can use the function formatnumber usage...

You can use the function formatnumber

usage : formatnumber(<number>, <number of decimal digits>)

example : formatnumber(7,2) will print 7.00
Forum: SQL Server ASP February 14th, 2005, 06:09 AM
Replies: 3
Views: 1,984
Posted By madhukp
You can make the column into an Identity column...

You can make the column into an Identity column with increment step as 1.

Use your enterprise manager for this.
Forum: Classic ASP Basics February 14th, 2005, 01:19 AM
Replies: 5
Views: 4,114
Posted By madhukp
here is my post. ...

here is my post.

http://p2p.wrox.com/topic.asp?TOPIC_ID=17981
Forum: Classic ASP Basics February 14th, 2005, 12:43 AM
Replies: 5
Views: 4,114
Posted By madhukp
Access does permit views (queries) and stored...

Access does permit views (queries) and stored procedures. I have posted some sample stored procedures for Access 2000 some time back in another issue.

Access is not thread safe, I think. It is not...
Forum: SQL Server ASP February 14th, 2005, 12:31 AM
Replies: 2
Views: 994
Posted By madhukp
The problem is with the query in sSQL. You may...

The problem is with the query in sSQL. You may print it to browser and check it. Could you please do it so that we can see the query ?
Forum: Classic ASP Basics February 11th, 2005, 01:25 AM
Replies: 5
Views: 2,874
Posted By madhukp
You cannot access files that are outside the...

You cannot access files that are outside the virtual directory using a link. Otherwise, it will be very easy for hackers to locate files of other sites on their web host.

You need to put PDF file...
Forum: SQL Server 2000 February 10th, 2005, 08:33 AM
Replies: 1
Views: 1,185
Posted By madhukp
You may use the following connection string. ...

You may use the following connection string.

Provider=SQLOLEDB;DATA SOURCE=<IP Address of server>;UID=<username>;PWD=<password>; DATABASE=<db name>

Where

IP Address - IP address of db server...
Forum: SQL Server 2000 February 10th, 2005, 12:32 AM
Replies: 10
Views: 1,806
Posted By madhukp
Ofcourse, possible. You can pass the other values...

Ofcourse, possible. You can pass the other values for the second table to the stored procedure.

Consider this SP. In this, @value3 and @value4 will go to second table.
...
Forum: Classic ASP Basics February 10th, 2005, 12:15 AM
Replies: 1
Views: 971
Posted By madhukp
I wonder what is the use of posting this much big...

I wonder what is the use of posting this much big invalid XML ? Could you please specify your problem ?
Forum: SQL Server 2000 February 9th, 2005, 12:58 AM
Replies: 10
Views: 1,806
Posted By madhukp
What Om Prakash told is correct. This method is...

What Om Prakash told is correct. This method is not thread safe. Not correct also. If last record is deleted, you will get back the id of that record in this method whereas the actual id will be one...
Forum: Classic ASP Basics February 9th, 2005, 12:44 AM
Replies: 4
Views: 2,340
Posted By madhukp
For access, it is similar. ...

For access, it is similar.

objHCDynamicConn.Open "DSN=DB1;UID=<username>;PWD=<password>"

If username and password are not set, you can simply use

objHCDynamicConn.Open "DSN=DB1"
Forum: Classic ASP Basics February 8th, 2005, 10:07 AM
Replies: 2
Views: 1,008
Posted By madhukp
Also, Response.Buffer has to be false for...

Also,

Response.Buffer has to be false for you to see intermediate results just before errors.
Forum: Classic ASP Basics February 8th, 2005, 10:04 AM
Replies: 4
Views: 2,340
Posted By madhukp
You have not mentioned which database you are...

You have not mentioned which database you are using. I am assuming SQL server.

It has to be like this.

objHCDynamicConn.Open "DSN=DB1;UID=<username>;PWD=<password>;DATABASE=<dbname>"
Forum: Classic ASP Basics February 8th, 2005, 09:52 AM
Replies: 2
Views: 1,008
Posted By madhukp
For this, you need to administer IIS. The steps...

For this, you need to administer IIS. The steps are

1) Open IIS Manager

2) Rightclick the site / virtual directory (listed on the left) and open properties.

3) Open custom errors tab.

4)...
Forum: VB How-To February 8th, 2005, 08:59 AM
Replies: 3
Views: 6,422
Posted By madhukp
You can use the shell command for this. (I am...

You can use the shell command for this. (I am assuming you are using vb 6.0).

shell("set IMODE=c:\tng0~2\bin mode -u=username -p=password -m=normal") will do this.

I don't remember the exact...
Forum: Classic ASP Basics February 8th, 2005, 07:39 AM
Replies: 2
Views: 39,588
Posted By madhukp
Sure you can. But you have to set the cursor type...

Sure you can. But you have to set the cursor type of the recordset as adOpenStatic. Then rst.RecordCount will give the number of records.

Sample :

Dim qry
qry="SELECT <Field list> FROM <from...
Forum: Classic ASP Basics February 8th, 2005, 12:58 AM
Replies: 1
Views: 2,407
Posted By madhukp
I could not understand it fully. However, if you...

I could not understand it fully. However, if you are looking for a grid based data entry, Dynamic tables will help you. The following article will give more information.

This will work in IE as...
Forum: Classic ASP Basics February 7th, 2005, 05:34 AM
Replies: 7
Views: 1,868
Posted By madhukp
OK, here is the sample SQL. table name :...

OK, here is the sample SQL.

table name : tbl_date_content

fields : dt_record_id primary key, auto number
sample_date datetime
other_field varchar(50)

Let dt_entry_date be the variable...
Forum: SQL Server 2000 February 7th, 2005, 12:58 AM
Replies: 2
Views: 651
Posted By madhukp
Yes, Vadivel you are correct. The fields of...

Yes, Vadivel you are correct. The fields of binary type has to be at the end of the fields list used in select statement.

In order to make them fast, I usually fetch binary fields in a seperate...
Forum: Classic ASP Basics February 4th, 2005, 04:18 AM
Replies: 7
Views: 1,868
Posted By madhukp
When you insert into database, you form a string...

When you insert into database, you form a string like

#MM/DD/YYYY# and then insert / update. You may be omitting the # delimiter.

Then While retrieving, you extract date, month and year parts...
Forum: Classic ASP Basics February 4th, 2005, 02:36 AM
Replies: 7
Views: 1,868
Posted By madhukp
Please go through this post. The comment will...

Please go through this post. The comment will help you fix this problem.

http://p2p.wrox.com/topic.asp?TOPIC_ID=20834

Madhu
Forum: Classic ASP Professional February 3rd, 2005, 07:11 AM
Replies: 1
Views: 879
Posted By madhukp
What kind of help you are expecting ? Do you...

What kind of help you are expecting ?

Do you want to know the features of a general discussion board ? (Research into the features of this forum itself. That will give you a good idea of a forum.)...
Forum: Classic ASP Professional February 2nd, 2005, 07:48 AM
Replies: 8
Views: 1,387
Posted By madhukp
You may use XML HTTP object for this. This is...

You may use XML HTTP object for this. This is built in windows 2000. If it is not there, you can download and install latest XML parser from MS and run on server.

Here are some sample scripts...
Forum: Classic ASP Basics February 2nd, 2005, 04:51 AM
Replies: 2
Views: 4,547
Posted By madhukp
Thanks. This works correctly.

Thanks.

This works correctly.
Forum: Classic ASP Basics February 2nd, 2005, 03:56 AM
Replies: 2
Views: 4,547
Posted By madhukp
script execution time

I want to show the execution time of scripts in a page. Just like

"This page was generated in 0.2 seconds."

shown in the pages of this forum.

For this, I am setting the current time at the...
Showing results 51 to 75 of 463
Page 3 of 19 1 2 3 4 5 6 7 8 9 10 11 12 13 Last »

 



Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.