Search results for query: *

Hi all, here is my query, a seemingly very simple one, but it doesn't work SELECT [f1], [f1Total], FROM [t1] where (( [f1]/[f1Total])<=0.8); The error is "The expression is typed incorrectly or is too complex to be evaluated........" Works fine if I remove the division check. What am I...

The subject line is ambiguous, I apologize, didn't know how to put it better. I have a coldfusion application, say a very simple one, where users can login. The application will be hosted on the client machine as wellas the database. Meaning once sold we have no control over it. As part of...

I have a simple question. ------------------------------------------------------ var temp=""; temp=temp+'<?xml version="1.0"?><menus>blah blah</menus>' useTemp(temp); ------------------------------------------------------ ABOVE WORKS FINE. INSTEAD OF HARDCODING temp, NOW I DO A var...

I have a q.. How does microsoft htc fit into coldfusion ? say I have a htc component that I am using in a coldfusion page, is there a way I can embed coldfusion tags in a htc file? say I want to populate the component with values from the database or something like that. any pointers on how to...

hi, I am new to serverside javascript, being a coldfusion developer. Can anyone please point me to a complete example where I can use javascript to connect to a database and query and thereby manipulate the result set? regards, Brian

didn't know how to make the subject more specific, but this is what I am looking for.. a right click on an icon should popup a menu and clicking on one ofhte menu items should execute a coldfusion page, in background. I should be able to basically do a http post in javascript and then handle the...

I have on a button a simple onclick="location.href='<cfoutput>#CGI.SCRIPT_NAME#</cfoutput>?&add=yes'" (the cfoutput tags are coldfusion, just ignore them) and the onclick doesn't work.. :( thinking it is a coldfusion problem I tried with http://www.yahoo.com and it doesn't work either...

Hi, I have a date field which if user inputs a date should be inserted into the table, and a blank value if not. I do a cfif cfelse with the else part as default ''(empty). and the date being stored in the db is 1/1/1900 in case of empty. So when I retrieve it, it brings 1/1/1900 which I don't...

Hi'll, I have an access application which when clicked on, doesn't show me the tables,queries etc. How do I open it in editable mode? I remember I have to do a ctrl+click or something like that, I tried some combinations, but couldn't figure it out. Can someone please help? regards, Brian

don't know if I should ask this here, but is there anything I can do with onmouseover or something on input fields in a html form to show "alt" msgs like we show for images? I want to give some description of each field on a mouseover. any ideas?? regards, Brian

I am testing a single digit number for the regular expression re1=/^\d+\.?\d{2}$/ and it fails. any thing greater than 2 digits, it works. Why is that? Basically thisis supposed to be a check for a positive decimal number. I want it to consider just integers too. What should I change it to...

I have a text field with onchange function. in the function I check if it is valid if not I say field.focus. like var f1=theform.f1; if (f1.value blah blah) alert f1.focus return when I enter invalid data and select next field, it alerts me about the invalid data but focus goes to the...

I have an access application, one of the reports runs a query which itself triggers a series of queries with one as input to another etc. Now, say there is Qry1 as select f1 as Expr1, f2 as Expr2,f3 as Expr3 from t1 and Qry2 as select [Qry1].[f1],[Qry1].[f2],[Qry1].[f3]from [Qry1] Should...

Is there anyway in ms sql where I canprint the table structure? I have tables with like 160 fields, don't have the queries that created them and am having a hard time to constantly shift windows to look at the required fields while coding. How can I print a hardcopy of the table structure...

Hi all, I have an odd problem. I run a scheduled page which reads records from a visual foxpro database table (using odbc dsn) and populates sqlserver table. This page runs every 20 min to keep the sqlserver db table up to date. Now, every now and then, the reading from the foxpro db fails due...

Hi, not exactly a cf question, but how can I have a form "select" field which goes multiple lines. which I later store in a database table field. When I cfoutput it, how do I retain the new lines?

hi all, here is my situation. User types xx in a field, yy in another field, and I have to create a new record in the table with a field having unique value xx-yy-nnnn. nnnn is a number, 1 more than the last record with xx-yy-(nnnn-1) I hope I didn't make it clumsy. basically if there is a...

I have an issue..:( Over the network, I have a server with vfp free table directory. I created a odbc dsn to access this directory. THen I use coldfusion to access this odbc dsn and connect and read some data from one of the tables (this particular table has a million and half records)...

I have a basic question. we have a table with one and half million records. unfortunately, users have to do search on this table on various fields. For faster search, how do I create indices? Should I just create individual indices for each search field? In the search form user can selectively...

I can't believe this. How can I loopover characters in a string? Is there any function for this??? regards, Teja