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
Showing results 201 to 225 of 463
Search took 0.03 seconds.
Search: Posts Made By: madhukp
Forum: SQL Server ASP October 21st, 2004, 03:01 AM
Replies: 1
Views: 708
Posted By madhukp
You can use the following query. SELECT...

You can use the following query.

SELECT (Lastname + ', ' + Firstname) AS [name] FROM tblSubscribers

Where tblSubscribers is the DB table where these two columns are defined.
Forum: Classic ASP Professional October 21st, 2004, 02:42 AM
Replies: 14
Views: 8,606
Posted By madhukp
AFAICU, your requirement is to get those events...

AFAICU, your requirement is to get those events whose month is chosen month. You can use the Month function of access for this. Here is a sample query.

SELECT EventName, EventDate FROM tblEvents...
Forum: SQL Server ASP October 21st, 2004, 12:54 AM
Replies: 7
Views: 2,708
Posted By madhukp
I think you need to extract the date, month and...

I think you need to extract the date, month and year parts of the value in textbox and pass it to query in the format MM/DD/YYYY. What comes from the textbox may not be in this format now.

IMO, a...
Forum: Classic ASP Basics October 21st, 2004, 12:00 AM
Replies: 25
Views: 14,227
Posted By madhukp
I had this date format problem for so long time....

I had this date format problem for so long time. Finally I could solve it by following this strategy.

1) The date to be stored in database is always formatted in MM/DD/YYYY format. Then proper...
Forum: Classic ASP Basics October 20th, 2004, 02:28 AM
Replies: 1
Views: 1,650
Posted By madhukp
Please have a look at the following thread. I...

Please have a look at the following thread. I have explained it fully in it.

http://p2p.wrox.com/topic.asp?TOPIC_ID=18956
Forum: Classic ASP Basics October 15th, 2004, 09:18 AM
Replies: 1
Views: 1,781
Posted By madhukp
IMO, Regular expressions are the best for you....

IMO, Regular expressions are the best for you. Here is a sample code.

Dim objRegExp
Set objRegExp=Server.CreateObject("VBScript.RegExp")
objRegExp.IgnoreCase=true
objRegExp.Global=True...
Forum: Classic ASP Professional October 15th, 2004, 08:05 AM
Replies: 1
Views: 1,936
Posted By madhukp
To give a correct answer, you should let us know...

To give a correct answer, you should let us know a bit more detail about your requirement. Do you want to create an HTML table with varying rows and columns ?
This code will do it.

<%
Dim...
Forum: Classic ASP Basics October 15th, 2004, 04:50 AM
Replies: 7
Views: 2,172
Posted By madhukp
Here is a sample script. The table name is...

Here is a sample script. The table name is TBLFILESTORAGE. The upload component used is ASPUpload.

'getting uploaded files
dim obj_upload
Set obj_upload = Server.CreateObject("Persits.Upload.1")...
Forum: Classic ASP Basics October 15th, 2004, 01:26 AM
Replies: 7
Views: 2,172
Posted By madhukp
You do not need to store the file in database....

You do not need to store the file in database. Actually the above code assumes that you are not storing it in database.

You need only store the name of the file in database. Store the file in a...
Forum: Classic ASP Basics October 15th, 2004, 12:59 AM
Replies: 7
Views: 2,172
Posted By madhukp
You are storing the image in a directory. Isn't...

You are storing the image in a directory. Isn't it ? let the relative path of that folder be \uploads (in relation to the folder of the page which deletes the user). You must store the file name in...
Forum: Classic ASP Basics October 15th, 2004, 12:37 AM
Replies: 1
Views: 2,144
Posted By madhukp
This question is more suited for JS forum. ...

This question is more suited for JS forum.

However, you can find a number of news ticker scripts ar www.dynamicdrive.com
Forum: Classic ASP Basics October 13th, 2004, 08:38 AM
Replies: 19
Views: 5,146
Posted By madhukp
Let me give you some more simplified explanation....

Let me give you some more simplified explanation.

Suppose you have a form with two text boxes. If both of them happens to have same name, say txtName, then when the form is submitted, in the...
Forum: Classic ASP Basics October 13th, 2004, 08:28 AM
Replies: 19
Views: 5,146
Posted By madhukp
Hello Mateen, If I am correct, you are...

Hello Mateen,

If I am correct, you are trying to add a set of dates to a field with data type datetime. This is not possible.

As far as I could understand, you are trying to store the...
Forum: Classic ASP Basics October 13th, 2004, 06:19 AM
Replies: 19
Views: 5,146
Posted By madhukp
Hello Mateen, Sorry for the confusion. ...

Hello Mateen,

Sorry for the confusion.

Just have Response.Write(sql) at line 50 (instead of cn.Execute sql). It will print the query creating problem.

Please post that query. This will help...
Forum: Classic ASP Basics October 13th, 2004, 05:14 AM
Replies: 19
Views: 5,146
Posted By madhukp
No, I mean the runtime query which creates the...

No, I mean the runtime query which creates the problem. Instead of executing the problem creating query, please print it to browser and post it here.
Forum: Classic ASP Basics October 13th, 2004, 04:31 AM
Replies: 19
Views: 5,146
Posted By madhukp
Could you please print the query (sql) and post...

Could you please print the query (sql) and post it ?
Forum: Classic ASP Basics October 13th, 2004, 03:15 AM
Replies: 19
Views: 5,146
Posted By madhukp
You are taking astrdate and aenddate from a form....

You are taking astrdate and aenddate from a form. isn't it? You are using textboxes to take these values.

In a textbox one can enter date in any fashion he wants. You have to impose some format...
Forum: VB How-To October 12th, 2004, 11:36 PM
Replies: 3
Views: 895
Posted By madhukp
Really. That was a mistake made by me. Sorry.

Really. That was a mistake made by me. Sorry.
Forum: Classic ASP Basics October 12th, 2004, 02:03 AM
Replies: 19
Views: 5,146
Posted By madhukp
I also find you have omitted some number of " in...

I also find you have omitted some number of " in the following line. Please check that also.

sql = sql & "'" & Request.Form("empno").Item(x) & "','" & aposit & "',' & astrdate & ',' & aenddate &...
Forum: Classic ASP Basics October 12th, 2004, 02:00 AM
Replies: 19
Views: 5,146
Posted By madhukp
How you are getting astrdate and aenddate values?...

How you are getting astrdate and aenddate values? Are they some values taken from db ?

While inserting date into SQL server, you have to take month, date and year parts of date (to be inserted)...
Forum: VB How-To October 11th, 2004, 11:58 PM
Replies: 3
Views: 895
Posted By madhukp
You can use a public variable for this purpose. ...

You can use a public variable for this purpose.

You can define the public variable with module (form) scope as below.

option explicit
dim gbliNumLoginAttempts as integer

You have to put...
Forum: VB How-To October 9th, 2004, 12:32 AM
Replies: 4
Views: 2,093
Posted By madhukp
Integrating a serial number

I am developing a VB application which the client wants to distribute to many persons. They want to have some restrictions for the distribution of it. The application is meant for individual PCs and...
Forum: ASP.NET 1.1 October 8th, 2004, 05:37 AM
Replies: 1
Views: 1,744
Posted By madhukp
Internet printing

May I know how can I do internet printing through ASP.Net ?

Essentially the situation is this. There is a printer which is connected to a machine where internet printing protocol is installed and...
Forum: SQL Server 2000 October 8th, 2004, 03:00 AM
Replies: 11
Views: 28,728
Posted By madhukp
What do you mean by this delimiter ' ' ' ' ' ? ...

What do you mean by this delimiter ' ' ' ' ' ?

AFAIK, you need only use ' and ' with any possible escape character while using openquery.

I have not used the arguments passed to the query like...
Forum: Classic ASP Basics October 8th, 2004, 12:37 AM
Replies: 12
Views: 5,978
Posted By madhukp
The link is working correctly. $299 is for...

The link is working correctly.

$299 is for purchasing the source code of this component. To get the component, it will cost you only $20.

I have not used this component. But I have used...
Showing results 201 to 225 of 463

 




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