Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 25 of 25
Search took 0.01 seconds.
Search: Posts Made By: Dharam Pal Sikhwal
Forum: Classic ASP Databases October 3rd, 2007, 07:40 AM
Replies: 13
Views: 2,704
Posted By Dharam Pal Sikhwal
Hi, Please give update string. Give...

Hi,

Please give update string.

Give code where u store update string in strSQL variable.
Forum: SQL Language September 28th, 2007, 07:29 AM
Replies: 2
Views: 1,066
Posted By Dharam Pal Sikhwal
I think u have to add one more field to [table b]...

I think u have to add one more field to [table b] and[table c] to indicate the record no in particular employee in that table.

Now format of table b should be -

table b
-------
id EmpNo...
Forum: ASP.NET 2.0 Basics September 28th, 2007, 05:13 AM
Replies: 31
Views: 3,895
Posted By Dharam Pal Sikhwal
Hi Miko2, I have solutions for all your...

Hi Miko2,

I have solutions for all your problems. But first u think what u want to help from us.

If you want to learn someting then be positive. If u have negative attitute all time u cant...
Forum: ASP.NET 2.0 Basics September 27th, 2007, 03:37 AM
Replies: 31
Views: 3,895
Posted By Dharam Pal Sikhwal
Hi, Ubound() function is return upper bound...

Hi,

Ubound() function is return upper bound of array.

in this case arr holds two elements then Ubound() function returns 1.

Array is starting from 0 then arr(0) and arr(1) two are elements...
Forum: SQL Language September 27th, 2007, 02:17 AM
Replies: 9
Views: 9,852
Posted By Dharam Pal Sikhwal
u can also try by this one for mysql. select...

u can also try by this one for mysql.

select *
from usertable
where lastlogin >= DATE_SUB(CURDATE(), INTERVAL 90 DAY)

if DATE_SUB() function is running on your mysql u can make query by...
Forum: SQL Language September 27th, 2007, 02:11 AM
Replies: 9
Views: 9,852
Posted By Dharam Pal Sikhwal
Hi melkin, Actually i am using sql server. ...

Hi melkin,

Actually i am using sql server.

I think for mysql this will work-

Select UserId
From User_Master
Where (TO_DAYS(lastlogin)-TO_DAYS(curdate())) between 90 and 120
Forum: ASP.NET 2.0 Basics September 26th, 2007, 07:26 AM
Replies: 31
Views: 3,895
Posted By Dharam Pal Sikhwal
Hi all, There is no need to go back to...

Hi all,

There is no need to go back to Database.

Just split the string. Like this-

Dim str As String = "Remy|remy@abcd.com"
Dim arr As Array
arr = str.Split("|")
MsgBox(UBound(arr))
Forum: SQL Server ASP September 26th, 2007, 06:11 AM
Replies: 7
Views: 2,203
Posted By Dharam Pal Sikhwal
Try This One - cmd = new SqlCommand("Select...

Try This One -

cmd = new SqlCommand("Select isnull( max(date),0) as dt, isnull(max(balance),0) as bal from chinnamaniaccounts where customerid='" + TextBox1.Text + "'", con);
Forum: SQL Server ASP September 26th, 2007, 05:22 AM
Replies: 1
Views: 1,145
Posted By Dharam Pal Sikhwal
Hi, You are Using Query outside the For...

Hi,

You are Using Query outside the For Loop. Please try this one-
Dim Rs

For Each objFile In bjFolder.Files
sql = "SELECT * FROM tblAangiften where FileName ="& objFile
Set...
Forum: SQL Server 2000 September 26th, 2007, 05:06 AM
Replies: 32
Views: 26,552
Posted By Dharam Pal Sikhwal
Hi all, I think u all are very intelligent...

Hi all,

I think u all are very intelligent persons, but why are u west time on a simple question about age calcualtion.

I think this query may be helpful for all u. and after it u have no dobt...
Forum: SQL Server 2000 September 26th, 2007, 04:07 AM
Replies: 4
Views: 770
Posted By Dharam Pal Sikhwal
Hi all, You can use this very simple query -...

Hi all,

You can use this very simple query -

Select [Date],
sum(case [Name] when 'Item A' then Qty else 0 end) as [Item A],
sum(case [Name] when 'Item B' then Qty else 0 end) as [Item B],...
Forum: Classic ASP Professional September 26th, 2007, 03:28 AM
Replies: 3
Views: 2,005
Posted By Dharam Pal Sikhwal
In your File Take four variables as- ...

In your File Take four variables as-
ODBC="DSN_Name" which store name of DSN for Live Database
DB="Live Database Name"
userid="Live Database Username"
password="Password of Live Database"
...
Forum: Classic ASP Databases September 26th, 2007, 02:23 AM
Replies: 6
Views: 2,671
Posted By Dharam Pal Sikhwal
In your code u have no explanation fro objResults...

In your code u have no explanation fro objResults variable.

Add this code before using objResults

Dim objResults
Set objResults=Server.CreateObject("ADODB.RecordSet")
Forum: Classic ASP Databases September 26th, 2007, 12:56 AM
Replies: 6
Views: 1,404
Posted By Dharam Pal Sikhwal
Hi, If till now u r getting problem with...

Hi,

If till now u r getting problem with access database.

Make the folder to Share which holds the database.
and try again.
Forum: Classic ASP Basics September 26th, 2007, 12:21 AM
Replies: 1
Views: 1,126
Posted By Dharam Pal Sikhwal
In your Parent Query Add PID field also like this...

In your Parent Query Add PID field also like this -

select PID,PName from tblproperty where level = 1

And in the Parent Loop use a variable to store value of PID. And in Inner Loop use this...
Forum: Classic ASP Basics September 25th, 2007, 05:31 AM
Replies: 1
Views: 1,188
Posted By Dharam Pal Sikhwal
Hi, U should use Global.asa file. in...

Hi,

U should use Global.asa file. in Session_Onstart() and Session_OnEnd()
Events.

In Session_OnStart() event use counter Session("id")=1 if no session id. otherwise give increment as ...
Forum: Classic ASP Basics September 25th, 2007, 05:21 AM
Replies: 1
Views: 1,088
Posted By Dharam Pal Sikhwal
Hi Guys, In your page u r using two arrays...

Hi Guys,

In your page u r using two arrays one is Company and another is Employee.

For Company u r using code :
...
Forum: Classic ASP Basics September 25th, 2007, 05:08 AM
Replies: 3
Views: 1,105
Posted By Dharam Pal Sikhwal
In this type of query u should use case. ...

In this type of query u should use case.

Select (case testing when 'Value1' then 'somecode' else 'anothercode' end) as Result
From Table

Try this.
Forum: Classic ASP Basics September 25th, 2007, 05:04 AM
Replies: 7
Views: 32,867
Posted By Dharam Pal Sikhwal
I think this error is coming b'coz u r using real...

I think this error is coming b'coz u r using real path of file.

Try this--

(1) In which virtual Directory (Folder) u r using for your website, Create a Folder named - Upload.

(2) At the...
Forum: SQL Language September 25th, 2007, 04:36 AM
Replies: 9
Views: 9,852
Posted By Dharam Pal Sikhwal
Hi Guys, I am giving a very Simple Method to...

Hi Guys,

I am giving a very Simple Method to write your query.

(1) To find the User's List that last login is more then 90 days old and less then 120 days.

Select UserId
From User_Master...
Forum: SQL Language September 22nd, 2007, 07:05 AM
Replies: 3
Views: 903
Posted By Dharam Pal Sikhwal
Hi Guys, Do Like this. Add two quotes...

Hi Guys,

Do Like this.

Add two quotes ('') insted of single quotes(') at each place in input
string. And this string will also take in single quoted.

Your original String is : ...
Forum: SQL Language September 22nd, 2007, 06:56 AM
Replies: 4
Views: 823
Posted By Dharam Pal Sikhwal
Hi Guys, Why r u doing a very simple query...

Hi Guys,

Why r u doing a very simple query in a very complicated manner.

This is good and simple query for your purpose.

select
company,
count(*) as Total,
sum(case status when 0 then 1...
Forum: VB Databases Basics December 5th, 2006, 03:36 PM
Replies: 4
Views: 1,245
Posted By Dharam Pal Sikhwal
If you want to connect your DATABASE throw DSN....

If you want to connect your DATABASE throw DSN. It is required that you first made DSN by ODBC in Control Panel.

Another way to connect to DATABASE in VB is to Add Reference of Microsoft ADODC in...
Forum: Beginning VB 6 December 3rd, 2006, 03:35 PM
Replies: 0
Views: 1,473
Posted By Dharam Pal Sikhwal
Transfer Recordset to Crystal Report

I am using Crystal Report 9 to Display Reports like Cash books etc.

We Provide the facility to Select the Date Range from VB Forms For Display Results by Crystal Report.

I have a Recordset like...
Forum: Beginning VB 6 December 3rd, 2006, 03:12 PM
Replies: 3
Views: 1,034
Posted By Dharam Pal Sikhwal
Because you use End If just before your bold...

Because you use End If just before your bold line.
Pls Remove the Upper line and take relex.
Showing results 1 to 25 of 25

 


All times are GMT -4. The time now is 03:51 PM.


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