Anyone with asp experience?

I have a small application I need some help with. Willing to pay

ewww

ASP

*spit*

Magnus likes these odd-ball programs - maybe he can help

/DM

LOL.... It's a small app I use in my business for tracking violation tickets on cars. I just need a couple fields added.....

I'm a Linux user. 'Nuff said.

Hey there. I used to do all my stuff with ASP when i ran windows servers 10 years ago. But after 10 years my memory is gone on that. No time anyway even if i could remember.

Ok, Ok, I get it! Y'all think asp sucks!

This post started out as a request for someone who WOULD help me, not as a place to list those who WON'T, thank you very much!

Anyone? I just need to add a comment field and change another field from date to date and time. It's simple, even for the php crowd.

You should be asking this at the ASP web site (which includes a forum).

http://www.asp.net/

I don't know anyone there. Was trying to give a little paying work to someone here instead.

You're asking for ASP help in a forum for a PHP script.

I presume you have an mssql database?

if so you may need to change the database field type to accept datetime - It should be 'datetime', although it's not uncommon to see varchar used instead.

And then instead of using date() to add the value, you will need to use now()

Not enough info for the comment field to determine what you want.

HTH

/DM

Ahh yes - forgot to add - you may need to reformat the existing entries in the date field so that they can be stored as datetime - normally this is done automatically when you change the type - it simply gives you a 00:00:00 value for the time for any existing entries.

But....

it may not, and might throw an error (it's micro$oft after all)

in this case - export the values - manually update them, update the table, and re-import the values

/DM

The comment field is very basic. Just need to be able to store text comments about specific vehicles, nothing fancy. I do have a very small amount of experience with asp. Could probably figure some of it out with a little guidance.

I really don;t want to work on it. It would be worth a C-note to someone with exp could probably do it in an hr or less.

Its probably something along the lines of adding another field to the database table - make it a varchar - and make it long enough to store whaever comments you want - say 255

Then, you need to do 3 things

1/ Add the form field into the form for the data to be typed into - if you have another text field - copy this, but change the name of the textbox - this is the same as for normal html...

<textbox name="comment"/>

2/ Add a new handler to grab the new value - again look for how this is done on existing fields - simply copy the code and rename it to use the new field you created above

it will be something like...

Dim comment
comment= Request.QueryString("comment")

3/ update the sql statement to include the new info - this is practically the same as mysql...
db.execute("UPDATE table SET comment='" & comment & "' WHERE ID=1")

Of course your actual query will be different, but you get the idea.

/DM