noman78

hello i got the same problem when i convert Access DB to SQL, in Access we have first function to do the job, in sql only option is to use MAX(fldname) for all those u want to display only, like this only one rec will be filter, in the case …

[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 …

SQL take the datesettings from the windows, the default settings for SQL is american settings with MM/DD/YYYY so in the control pannel in the regional settings u ahve to cahnge it to wht u want

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

u can use combination of SubString and instr function and can extract time from the date-time stamp if is wht u wnat get back to me, i will give u the example

try to update the record fter making rs=nothing as may be when u open the recordset it is making it read only for further assistance u can get back to me

are u using server 2003? go to regedit and change permissions to odbc to everyone, i hope it will work [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\

hi there it seems u r new to asp here is ur mistake instead of this set sql_insert = conn.Execute (sql_insert) use this conn.Execute (sql_insert) it will work

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 …

information u provided is very less, but hope this will help lets consider "Con" is ur dbase cnnection Dim Array1() --->keep it open for dynamic use then set Rs=con.execute("select * from tablename") --> it is ur table recordet linecount=0 while not Rs.eof linecount=linecount+1 redim preserve Array1(LineCount) Array(1)=rs.fields("fieldname") Rs.movenext wend now …

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 …

he syntax should be this "select * from tbl_name where mobile_no in ('firstvalue','secondvalue')" what i think the expression which you are creating for search criteria, i mean,"SSql" should contain single quotes and you should remove ingle uotes from query i mean instead of strSQL = "select * from tblcontest where …

hi there i tried this long before but dont know abt current udates regarding winxp. but last time when i tried this, i found that there are certain librries not present in XP, s these kind of fatures are not supported. you first try to use your code in windws2000 …

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

abt ur first two points, i need to see the code u r using, are u suing access forms to retrieve and save or its some other programming language abt third point, the default dateformat for access is mm/dd/yyyy so db alwasy save in this format, so for this u …

i think all four replies are wrong for u if u r s=using SQL then u cant comapre null as u r doing the real statment is "select * from <table name> where isnull(<fldname>,'comparevalue')='comparevalue' the scenario is , in sql to comapre with null , u have to fill tht …

[QUOTE=gymanual]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 …

[QUOTE=maya_cs]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[/QUOTE] hello it is …

[QUOTE=iketunde]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 …

HERE IS THE SAMPLE FOR CREATE AN UPDATE QUERY USING COMPARISON IN TWO TABLES <sAMPLE qUERY< UPDATE Table1 SET t.field1 = t.field3 + s.field2 FROM table1 t, table2 s WHERE t.field4 = s.field1 AND s.ord_date = (SELECT MAX(field5) FROM table3) <end query> this is the best and most efficient way

Hello cdonts is server component and not avilable in XP, so thts why in xp there is cdo so if u r deploying on server then no need to change but if u r deploying on xp machine then u need to change it

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