No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
if a man can do then "noman" can do, like to share knowledge with every one and expect the same from others
- Interests
- Watching playing all kind of sports,Music, books,Development of software
- PC Specs
- Intel centrino 1.73 LG K1 express note book
 | Hi guys here is my working sql query Select MAX(Hits)'Hits', SUM(Hits)'Total', UserID From sf_articles Group By UserID My problem is, when I want to select other columns as well as the current ones. It gives me a lovely error: Server: Msg 8120, Level 16, State 1, Line 1 Column 'sf_articles.ArtID' …  |
 | [B]My web server is hacked and here is some info =, which may help in rectifying. as per my investigation, the port 80 data is corrupted. Please guide me how to secure and fix it the problem is.[/B] When i am trying to access my server through web browser from … |
| | Dear There I have one web application created in asp.net. i hosted the website on one american server. As the site was on american server so i did all scripting for date checks and conversion by keeping in mind the format mm/dd/yyyy. Now after one and half year i have …  |
| | anyone has an idea where i can setup the language (the dateformat) for my ms sql database?? Allways thought i can configure the DB user so that the DB accepts german datetime values- any ideas?? |
| | How can I send a Crystal Report to Email through Active Server Pages (ASP)? if some one can post a sample code for it, i will really thankful to him. i am using seagate 8.5 and asp 3.0. thankyou in advance regards  |
| | I'm working on a project that just needs to know that its 08:00 or 14:01. I dont need or want to store anything about date. When I store the time and then try to check it against the current time I'm runnig into problems. where (timeofevent = Convert(char(19),current_timestamp)) this doesnt … |
| | Have gotten the select statement and Update statement to work separatly, but need them to work on the same page and cannot seem to make it happen. Here is the current state of things. Any help would be appreciated. [code=asp] <% Dim conn,rs,strsql,sql_update,ssn,cps strsql = "Select SSN From CWCT07 where … |
| | I have a problem creating a ODBC connection. I am using MS SQL server 2000. Local access. I create it in System DSN. 1. I select the "With SQL Server authentication using a login ID and password entered by the user rather than Windows NT. But the error message occur … |
| | I hope someone can help me decide what is happening with this. It recognizes and carries out the select statement, will redirect to the proper place if entry is valid/invalid, but will not insert anything into the database. I first wanted an timestamp but am trying to troubleshoot backwards and … |
| | Hi there i have a page on which i have button to print the page but the problem is before printing user needs to change the print option manually to landscape. is there any wy tht user simply click print button and it got printed in portrait. as uer dont …  |
| | Hi, Please help me in passing the data from recorset to an array.. Thanks in advance.. |
| | Hi there i need sample code to change ODBC of reports at runtime. scenario: i have few clients using differnt DSN but sae set of ASP code, my all reorts have been designed in crystal8 and asp. now ther are two ways, ither create differnt sets of reports for differnt … |
| |
Re:
Sql In Does anyone know the exact query for IN in the following senario... I want to search for 2 columns for 1 mobile number (mobile, alternate mobile) I am using the following query [code]strSQL = "select * from tblcontest where bar_mob_no IN('" & sSQL &"') or bar_alt_mob in('" & sSQL &"')"[/code] … |
| | i m new to asp . i m try to send mail using CDO. my os is XP pro. i have install IIs and smtp also running. if i running my program , its doesn't throw any error. but my mail is not sent.. that is , if i m … |
| | Dear All i am totally confuse in how to explain the issue. i will try i am web master of one site [URL="http://www.makepakistanbetter.com/why_how_what_forum.asp?GroupID=5&Group_title=Pakistan&ArticleID=351&Article_Title=Burney’s%20concern%20for%20thousands%20underage%20missing%20jockeys%20in%20Dubai&ArticleFName=350-2-5.html"]www.makePakistanbetter.com [/URL] if you check this link,there is one issue you will be seeing there this txt 1 "Burney’s" but this is not what i entered. in the …  |
| | Dear All i m having very differnt problem i think i hve one page in which i am using ifram and rich text box for html WYSIWYIG but if i change the page extention to .asp instead of .html, every thing which was wrking before start giving errors and a … |
| | Hello Dear All i m having a unique problem , i m having laptops intel centrino, when laptop is connected to power suply it is getting connected to US robotics access points, but as soon as i take laptop off from Power and let it run on Battery , it … |
| | Hello have a good day is there a way to retrive top records by range , i mean like this "select top 15 to 20 record from Table name any condition" i dont mean top 15 or top 20, i mean records from 15-20 take care thanking u in advance …  |
| | Hello have a good day is there any way to retrieve record number with each record in simple sql qry? e.g select "REC_no",name from "table_name" the result should display like this 1 ,noman 2,imran 3,Jose etc take care thanking u in advance Bye |
| | Program- VB 6.0 Database- MS Access 2003 I'm build a database base on my household bills. And I have already the database connects to the program, but I am unable to get some of my functions to run correctly. These are the problems that I am having... 1. I am … |
| | [B][I]MSSQL Where Statement Problem[/I][/B] [COLOR=BLACK] [LEFT]I want to select all in a column if variable = null I am placing a php variable in there and i know how to do that so i no that is not the problem but i want a where statement to return all rows … |
| | PLs could somebody tell me how in MS SQL set the default value of a column as the sum of 2 columns column3=column1+column2 where column3 is bigint column1 and column2 are int column1 is primary key with identity incresed by 1 if posibble column2 is a column from another table … |
| | in some of my web pages, some links has to navigate through the directory access , not the pages reside in the same directory, every thing is workkign fine with my sys which is server2000, but when i deployed it on server 2003 it give me internel servre error 500 … |
| |
Re:
new in sql world hi all i wanna to use sql server 2005 but i never use it or any sql server before can any one help me what steps i should follow to learn it i will use jsp . as i used it before but with access thank u |
| | Hello, I have a software package for monitoring warehouse transactions. I have a need to share information across many users in several different locations.I don't want to network the pc's i can't afford that. i however notice that putting the information online saves a lot of cost for me. I … |
| | Hello i have a page which u can say abt 250col wide, and can grow in tht direction as well left to write when i go for print it cuts the remaining page is there any normal way to print it take care |
| | Hello I Was A Good Software Developer Just Migrated To Web Development I Want To Deploy A Site On Server2003 Standerd Edition This Site Is Sql Based When I Go To Aunhentication Pages It Gives Me This Error Http 500 -internal Server Error In Sql I Ahve Created Default User … |
| | I'm working with sql servre database I have two tables in the same database. thse are my tables, [code] CREATE TABLE [dbo].[Applicant] ( [UserID] [int] IDENTITY (1, 1) NOT NULL , [UserName] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [EducationDetails1] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [EducationDetails2] [varchar] (50) COLLATE Latin1_General_CI_AS … |
| |
Re:
How to send mail I did some reaserach and found out that [B]CDONTS.NewMail[/B] is been replaced with [B]CDO.Message[/B], and I implemented [B]CDO.Message[/B] on my code but it gives me an error on the folowing line : Mail.Body= MyBody it says it does not recognise the 'Body' object, but this works on [B]CDONTS.NewMail[/B] so can … |
| | hello i m using MSDE version with the web site i have developed for ASP but i m unable to create guest user for internet access, which is defult builtin account by windows plz help me this is very urgent issue for me take care bye |