Search results for query: *

Hello. :) I am creating some ASP pages to add, change and delete. In my change pages, I need to check to see if they have entered a value in a specific text box. Then, I need to check to see if they have changed the value that was already in the text box when it was loaded up. If it was...

Hello. :) I am creating some asp pages. On one of the pages, a modification page, I am trying to perform a date validation function. I know the function works, but I have been unsuccessful at getting it to work on multiple fields. For example, if one of the text boxes is empty, it says that...

Hello. :) I have been looking through this forum to find a possible solution to a problem I have been having with a delete query. I would like to be able to delete from two tables joined together by a field in one of the tables. I have tried several statements but none of them seem to work...

Hello. :) I am trying to create a view using fields in a table. I need to pad spaces with zeros after the field. For example, if the field is: 1234 and the length of the field must be ten digits long, I need it to appear like this: 1234000000. I am able to pad zeros before the field by...

Hello. I am trying to check if a record already exists before I insert it into a table in SQL using ASP. Here is the code that I added: SQL = SQL + " IF EXISTS(SELECT 'True' From department WHERE DeptName = '" & inputDeptName & "')" SQL = sQL + " BEGIN " SQL =...

Hello. :) I am creating some pages in Dreamweaver UltraDev to allow users to be able to add, modify and delete records in a database. I would like the user to be able to add records to a database (such as name, location, etc.), but I need to check whether the name already exists in the...

Hello. :) I am creating some pages in Dreamweaver UltraDev to allow users to be able to add, modify and delete records in a database. I would like the user to be able to add records to a database (such as name, location, etc.), but I need to check whether the name already exists in the...

Hello. :) I am writing some ASP pages where I would like the user to be able to enter in a subject and description. Then, I would like to insert the subject and description into a SQL Server 2000 table. However, if the user enters an apostrophe or single quote in the subject or description...

Hello. :) I am creating a cl program to send a break message, pause for 5 minutes, end all jobs and then run a program. I was able to locate some code that is supposed to end jobs. However, when the code gets to this statement, it errors out: CPYSPLF FILE(QPDSPSBJ) TOFILE(QGPL/QINTERJOBS) +...

Hello. :) I would like to check for active jobs in a specific subsystem and then use the endjob command to end those jobs that are currently active using CL. I am unsure of how to go about this since I am new at CL programming. I would greatly appreciate any help or suggestions. :) Thank you. :)

Hello. :) I was wondering if there is a way to signoff the active users on an AS/400 using CL? If so, I would greatly appreciate some suggestions or help. :) Thank you. :)

Hello. :) I am creating a CL program to send a break message to active users, get a listing of the active users, pause for 5 minutes and then begin a program. I have figured out how to send a break message to active users, but have been unable to find any information on how to display a...

Hello. :) I am modifying a form in Delphi, so that a splash screen will appear, show another form, and then have the splash screen go away. Currently the splash screen appears, then the second form displays, but the splash screen never disappears from behind the second form. Here is the code...

Hello. :) I am modifying some forms in Delphi. I need to close the splash screen that appears at the beginning when it is first loaded when the next form appears. Here is the code that I am currently trying: procedure Tfsplash.FormShow(Sender: TObject); const InfoNum = 1; InfoStr...

Hello. :) I am building some asp pages. On one page I allow the user to select a date in this format (6/26/2002). I, then, pass this value on to another pages where I want to insert it into a SQL table field that is defined as datetime. However, before I insert this field, I need to add the...

Hello. :) I am creating an asp page where I would like the user to be able to pick a date through a datetime picker. I created the page and am able to use the datetime picker when I run it from my page on my computer. However, when I try to upload the page to our intranet, the datetime picker...

Hello. :) I am building an asp page where I am trying to insert values into a database table. I believe that I may be having difficulty inserting NOW() into a field. I was wondering if that is how I should be inserting the current date and time into a field. Secondly, I am getting the...

Hello. :) I am creating some asp pages, and I would like to pass some text information from one page to another. I am able to pass the information that resides in text boxes that the user types in. However, I am unable to pass the text that I put on the form that the user is unable to change...

Hello. :) I am working on an ASP page that I want to be able to display some information from a SQL Server database table. I check for a record counter, and if there is more than one record, I want to redirect it to a different page. The most current code that I have tried is: If NOT rs.eof...

Hello. :) I am having great difficulty in figuring out how to create a drop down box (or menu) by concatinating two database fields, and then trying to pass the selection to another ASP page. Here is the code I use to create the drop down: if NOT rs.eof then rs.movefirst nameArea =...