Search results for query: *

Thanks Bill, that works. Who needs scalar functions, eh!!!!??

I've tried a few variations, but it's the scalar function it doesn't like. If i do away with the scalar and the CF UCase() function and enter the form.clientname in the correct case, then it works!!

I'm having trouble understanding scalar functions. Can anyone tell me why this doesn't work.... SELECT * FROM LiveClient WHERE {fn UCASE(customer) } LIKE '%#UCase(form.clientname)#%' It produces a 'Data type mismatch in criteria expression' error. The field (customer) and form var...

There's no error. If someone is modifying a record, i want to deny someone else from modifying the same record simultaneously. I thought setting the default record lock to 'edited record' in Access would do this for me, but it doesn't??

I am developing an Intranet using coldfusion with MS Access for the database. How do i detect if a record is currently being edited, thus denying a second user from editing it. I have turned on default locking in the database hoping it would return an error that i could cfcatch, but it doesn't...

Anyone know where i can get a list of available CGI variables? Have tried RTFM, can't find diddly squat!!

Wasn't the answer i was looking for Russ but thanks anyway. It is the client's computer i need to read from. Someone in another forum said to look at the VBscript environ() function. I'm not familiar with VBscript but i can't find any trace of this funtion. Do you know anything about it?

Can anyone out there help me??!?!?! In other forums people are coming back saying what's an environment variable, so i'll explain: They are parameters set by the operating system or installed programs, for example; PATH, TEMP. You can view them by typing SET at a DOS prompt. My question is...

Does anyone know if it is possible to use environment variables with coldfusion (or Javascript). I need a way to find out if the user is logged into the company network and if so, who they are logged in as. I've tried using CFREGISTRY, only to dicover it works server-side.

I have since found an answer. Use Javascript ie. location.href=&quot;maintainNotices.cfm&quot; instead of <CFlocation>. I don't know why, but it does work??

Did you ever resolve this problem. I have a similar one.

Can anyone tell me if it is possible to extract document property information from word/excel/powerpoint files (ie the info you can get by right clicking on a file and choosing properties) and return it to a web page using VBscript (or any other scripting language for that matter).<br><br>I'm...

I'm fairly new to CF so it took me quite some time to work this one out. This particular section uses Combo boxes (I don't know if that's how you wanted to do it).It works by using the CFWDDX cfml2js Action tag to output the query results into a javascript array. Javascript can then be used to...