Search results for query: *

I am really stuck now. I have 2 tables. A user table and Hardware table. user table (User_ID,First_name,Last_Name,Email) hardware table(Hardware_ID, User_ID, DateRequired, Description) A User comes in a fills out a form and then clicks submit. On submit (this is where I am stuck) I...

Tarwyn, Thank you very much! this is perfect, it was exactly what I was looking for. Thanks so much for the explanation.

My Apologies John, I meant to reply to another thread but posted another. Again sorry for this. The threat I meant to reply or post to was thread333-1359237. Could you have a look at that for me? Thanks again

Hello again experts, Has anyone had a chance to review my code. I think I may have gotten my asp page to return the id by modifying the stored procedure and using it as a call in my asp page. But now what do I do with the query string? Thanks again.

Thanks for the responses everyone. For the life of me I have never ever used request.querystring. I have always used the form method "post" and not "get". I really don't know how to make the change to my page and thought maybe you could give me a hand. Tarwin you mentioned to return the id...

Hello experts, I have a classic asp form with oracle 9.2 backend, in which the user fills in information and then hits submit. When he/she hits submit, 2 things happen. Firstly, the information gets inserted into a database table (this is working) and 2ndly there manager receives an email...

This is exactly what I needed. I wanted to use my existing code but this will do. Thanks Dashley.

Monksnake, Thanks for the reply. I really was just giving you the gist of the code. I understand that I did not execute the sql statements but I response.write them. I'm a bit confused as to what you are saying. I have my checkboxes that all have the same name(check) and then my drop...

Hi Dashley, Thanks for the response. I should have mentioned that I definitely know how to loop thorugh the checkboxes to get there values but I think the issue is much greater. I guess I am not sure if it has to do with my database structure. I only have one table and in that table I have...

Hello experts, I need a hand. On my asp submit page I have the following code: for i = 1 to 5 ' 5 question form' Question = Request.Form("Q" & i) Answer = Request.Form("A" & i) Comment = Request.Form("C" & i ) ValComment = Replace(Comment, "'", "''") ValAnswer = Replace(Answer...

Dagon, That is exactly what I am looking for. I should have mentioned that I thought I should use the rank but decided to go with First_value. Thanks so much for this. Saved me some valuable time.

Willif, yes I did based on the other posters. Thanks for your help and follow up. Now I need some help with a post I submitted yesterday:) Thanks again.

Dagon, Thanks for your response. Sorry for not being clear. Maybe if I show you some data it would make more sense. Say I have the following Name State Listinggr Count Lou Exit BBB 0 Chris Not Done BBB 0 John Done BBB 1 Fred Not Done XXX...

Hello all, I am using oracle 9.2 and using Oracle SQL Developer I have a case statement as such (CASE WHEN a.name= first_value(a.name IGNORE NULLS) OVER (Partition by a.date order by a.ID) and a.state= 'done' and a.listinggr IN ('XXX', 'BBB') then 1 WHEN a.name=...

Willif thanks so much for helping out. Really appreciate this. Ok to answer your question what I mean by first.... is if you look at the sample data I gave you for SRT 123 Jim C would be considered first and for 456 Sal M would be considered first. So I guess to try and describe this to you...

Wow now I am stumped with the requirments. I have a subset of data using oracle 9.2 Date name SRT Status ValueINT 03-Jun-05 Jim C 123 WIP 0 03-Jun-05 Dino B 123 WIP 0 03-Jun-05 Jim C 123 Closed 1 03-Jun-05 Sal M...

Wow now I am stumped with the requirments. I have a subset of data using oracle 9.2 Date name SRT Status ValueINT 03-Jun-05 Jim C 123 WIP 0 03-Jun-05 Dino B 123 WIP 0 03-Jun-05 Jim C 123 Closed 1 03-Jun-05 Sal M...

Sorry for the late response. Thanks so much for everyone's help. I removed the to_date and all is well. Thanks again.

Hello once again experts, I am really crunched for time and I know this will be an easy on for you guys I just can;t seem to get my head around it. I have the following query select ID, to_char(Function_Convert(SDate,'EDT'), 'MON DD, YYYY HH24:MI:SS AM') AS SDATE, from Table A...

Gunjan14 I really appreciate your help. I have tried Beilstwh suggestion and it works great. I'm not sure on the benefits of running one over the other but if there is could someone please let me know. My query seems to run fine. Thanks Beilstwh.