Search results for query: *

I have a query that looks something like this: <cfquery name="AFX" datasource="xxx"> Select #form.selectA#, #form.select1#, #form.select2# from TblUniforms Where (#form.selectA# like '%#form.text#%') </cfquery> The form variables come from the previous page and are submitted by the user. The...

Thank you, Yes that is what I meant. I don't have a password because the file share server uses nt authentication. I tried putting the username in like you told me but I still haven't got it to work yet.

I have a hyperlink to a file on a fileserver. In the path I need to add the username, How do I do this? I this is an elementary question but thanks in advance for your response.

how do I trap a datasource error in a page. I have several different datasources in the same page but I want the page to still run even if one of the datasources is down. Just skip over that field.

How do I select the first 5 records in a table with 10 thousand records?

Thank you Lespaul and PHV, I can take this and run with it. Thanks again.

Actually I am using coldfusion, but I often write my queries in access to get the logic and then work them into coldfusion. So if you tell me what you would have to do in Access then I can figure it out the rest.

I am inserting multiple records. And you are correct that all of the information I am trying to insert does not exist in the proper tables. How do I check for that first?

Okay, here is my problem, I have a systems table with systems, category, type and designation fields about 500 records. The category, type and designation are just a number like 01, 02, 03. Then we have a category, type and designation table with addition fields holding descriptions and such...

Shannon, I have seen this happen before. My last boss was put into the same position. She worked alot of overtime and continued building her case for help. I really think they were testing her and if you quit you certainly won't pass the test. However, if there are other reason's you can't...

Thank you.

I need to have 4 different submit buttons submit the same form to 4 different process pages. How do I do this? Or should I submit all the buttons to the same process page and then check in the page to see which button was pushed. Can I do it that way?