Search results for query: *

Thank you for your responses and help! I will try both of the methods you two provided!

dhulbert, Your links doesn't work.

Thank you for your reply. I should have mention that birth_date and death_date isn't really the field names we are dealing with it. I am using birth_dates and death_dates as an example. We need to keep track of the of the date and current time of the data that was enter from the user. The...

Hello, I have a program connected to SQL. There are two date fields, Birth_Date and a Death_Date. We have a program that enters information with these two fields and other numerous fields. When a user enters a Birth_Date, the value shows (for example) is "03/20/2012 12:00:00 AM". The Date is...

Works perfectly!! Thanks so much!

Thanks for your suggestion. But it is still giving me the same database error. Yes, thank you again for your suggestion, although, this window application is only a test application and we will not be using this publicly. But I still need this piece of code fix. Thanks!

Hello, I am having a trouble getting this piece of code to work. When users click on the "New" button, they enter the information into the text boxes and click "save". The data is suppose to be saved in SEQUEL. But once the user execute, there is a database error. I believe it is in the sql...

Nevermind, I figured it out!

I am attempting SQL. Yes I know the statement is in Oracle, but I seem to can;t figure the SQL syntax.

I am getting an Execution fail. I believe it is this string because when I comment it out, it works fine.

Hi, I need a little help on this Sql Statement. The below function won't run in C#. I think and know my date function is wrong, can someone please correct the error? Thanks in advance! string dataSQL = ""; dataSQL += " , Confirm_Date = to_date('" + DateTime.Now + "', 'MM/DD/YYYY...

Thanks for the reply. Could you be a little more specific?

Hi, I need some help on controlling a label. I have an application where data is pulling from an access database and it is using the sqldatasource as the connection. In the application, address information is being displayed as the user chooses a LastName. I need help on controlling a label...

Thank for your help. Everything is showing up on the datalist, but it is still pulling all the data once I debug the page. I need it to pull data when a user selects a last name.

Thank you so much, the duplicates aren't showing anymore. Yes, the auto-generation is off. But this: select firstname, lastname, ... from table where lastname = @parameter order by firstname .. isn't working. It is still pull all the data despite selecting any LastName from the dropdownlist. My...

Hi there, I am trying to create a webpage where the user selects a last name from a dropdownlist then the information is display in the datalist. I have done this before (twice) but this time, it's stomping me. There's really no programming involved, just data bounding the fields. But here's my...

It works! thanks so much lb!

I'm sorry, correction again, Date_Created is updated by system automatically upon record creation and month data (1-12) is already recorded, this means, the Date_created needs to show date and time if fees were paid within a month's period.

Just enter this? if {fees.month} = 9 then 1 Opps -- had to check with the dba, the month field is already enter in database (1-12)

The count list people is 2140, there won't be any new person unless the dba manually adds it in the database, and all other fields are left blank (month, fees_paid) only names, and contact information is entered.) The only permission users have is to enter how much of the fees clients pay each...