Search results for query: *

Good morning! I tried this but am not sure on the update piece of it. This is what I originally had: <cfquery datasource="shifts"> UPDATE tbl_Bid_Info SET BidNum='#(Form.BidNum)#' Where ID=#(Form.ID)# </cfquery> I've modified this to: SET BidNum='#(Form.BidNum_#avail.id#)#' and am getting...

Hi! Not sure I understand? There is not drop down box or list of choices, it's an open text field. I have the unique id number hidden so it is not displayed, but for each unique id number I need to update the text to the database field. Here is the first section of code: <!---Get agent...

I was running through it in the immediate window and would get that error, when I assigned a macro to the function and ran it worked fine. I really do appreciateit, you've been a great help!! Thank you!!!

This is great thanks!!! :-) Seems to be working with one exception, when I get to this step: Do While Not rs1.EOF I get a Do without Loop error? It seems that it's only doing the first and second SenNo's and not going through the rest of the list.

I was thinking this same table could be used (or a new one created) and a field added to it for shift assignement. For seniority 1, the shift assignment would be 1, sennum 2 the shift would be 3, sennum3, shift would be 8, etc...and each time it goes to the next sen num, it will look to...

Hello! I need help with an update query on my CF page. I am creating a shift bid process, each agent will see a list of available shifts and will be able to bid for these shifts based on number preference, 1 is first shift they want, 2 is 2nd choice, etc. When I enter the pick number in...

Hi! I am new to VB and really don't know that much about it. I need create a module that will assign agent schedules based on seniority numbers and shift bid choices. For example, 13 shifts are available, agent with seniority number 1 gets their first choice of shift #2. Agent with seniority...