Search results for query: *

Hi, I would like to add a subreport at the end of the main report. But I don't want the subreport to have the page - report header/ page - report footer. How can I accomplish this? Thank you

Hi guys, anybody knows what the nl file extension stands for? I have seen this extension on websites before like app/site/backend/setshoppercurrency.nl but I don;t know for what programming language or OS stands for. Thx a lot

hi all, i need to write a query to change a column type from int to int identity (1,1) How do I do that? Thx

Hi, I have a parameter for a report, that is actually the paramter that I sent to the stored procedure that will bring the data in CR. In the SP I declared the parameter as integer but When I run the report in the windows box the parameter has 4 decimals (4 zero's). How can I remove the default...

Hi, I have a formula with this underlying code: if isnull({sp_not_expired.QTY}) then formula = "" else formula = CStr({sp_not_expired.QTY}) end if where sp_not_expired is a stored procedure and QTY a numeric field, which I don't want to display if it's null. Now when I display the...

Hi everybody, I'm populating a radiobutton list through C# code. for (int i = 1; i <= 40; i++) { rbnlstep2.Items.Add(new ListItem(i.ToString())); } The issue that I have is that the radiobuttons are displayed in this format: 1 radiobutton 2 radiobutton ... 40...

Hi guys, anybody knows to which edition is the educational edition VS 2005 similar? To Standard / Professional? What are the difference? I tried to find it on the web with no luck. Thanks, TMRO

Hi, I need to create a job in SQL 2000 that will copy a specified file in a specified directory. If that directory doens't exist then it should create it. Is this possible in SQL? Thanks, TMRO

Hi guys, anybody knows a function to calculate how many saturdays or any other day are in a time interval? I need to find out the number of working days in a variable time interval. Thank you, TMRO

Hi guys, I trying to return a lot of records (the table holds 30,000,000 records) from the MS SQL. The lines to call the stored procedure are as follow: set conn = Server.CreateObject("ADODB.Connection") conn.ConnectionTimeout = 0 conn.CommandTimeout = 0 set objrs =...

Hi, I'm using xp_sendmail to send automatically emails from SQL Server 2000, regarding different status from the main database. Is there a way to format the email body so that it looks more friendly? Like breaklines / hyperlinks / bold ??? Thank you

Hi guys, I'm calling in my asp page a stored procedure with 2 parameters. Here is the code set cn = Server.CreateObject("ADODB.Connection") cn.CursorLocation = adUseClient cn.Open "Provider=SQLOLEDB;Server=servername;Database=DB;UID=user;PWD=password" set rsresults =...

Hi, We are using web applications in our intranet where in order to access them, users have to authenticate themselves. So, when they access the internet address, they have to enter username & password. (integrated windows authentication from IIS). They have the option to remember password...

Hi everybody, I have 2 fields in my report. (actually there are more, just for explanation is easier to use only 2) The top one has to option "can grow" checked. Underneath is the 2nd field. If the top field grows (10 rows), this field is overlapping the 2nd field that was underneath it...

Hi everybody, I need to declare a cursor but depending on the current day the select statement is different (the where condition actually is different). declare cursorname cursor for if @day = '1' begin select a, b, c from table where ... end if @day = '2' begin...

Hi everybody, I created a new user in the SQL 2000 in the Security --> Logins area and I assign that user to be db_owner to a specific database. Now, if I go to any table from the above mentioned database and view the permission for that table, you notice that the newly created user doesn't...

Hi guys, Anybody of you knows a software that will transcribe a .wav file into a word document? Thank you TMRO

Hi everybody, I have designed a shopping basket. The Order ID is stored in a session variable. What I noticed is that if users right click on a link while they browse my application and choose "open link in a new window" the Order ID will stay the same in the new opened window. So to say...

Hi everybody, I have a problem here (kind of strange) and I don't know if it's possible. When you open a contact card in Outlook under the general tab bellow the full name field there is another field called: job title. Is there a way to remove this field and put another one like "shoe...

Hi guys, I'm looking for a software that should resize / reduce partitions on a Windows 2000 Server. I noticed that PArtition Magic 8.0 doens't support Windows 2000 Server or Windows NT Server. Any ideas? Thx, TMRO