Recent content by sgdragon78

Hi All, So what is the advantage of using XML in the situation i described in the earlier msg (above)?? I have read much about the advantages of using XML.. blah blah blah.. most of them are quotation from books. Is there a real situation here? Someone had convert their own system to an XML...

Hi all I read an example of a Transport application using XML (http://www.topxml.com/xml/articles/buildingxml/) In his situation, a user would fill in some order details and Submit to the server. The server would then convert the order detail into XML and forwards it to another server and...

typo error, in my previos postings, i meant, "there must be a way to work around this "Refresh" problem"

Ecobb, Like what you mentioned, Updates and Inserts will really create a whole lot of mess. Imagine a Delivery Order operation, if the user keeps refreshing, the stock on hand will keep reducing, that leads to data inaccuracy, which is a very serious problem in Inventory point of view. While...

GUJUm0deL, ========================== confirmDelete.cfm <cfif isdefined(&quot;cmdSubmit&quot;)> <cfquery name=&quot;delStock&quot; datasource=&quot;...&quot;> delete from tbl_stockOnHand where id ='#chk#' </cfquery> <cfset msg =&quot;Item(s) deleted&quot;> </cfif> <form...

Hi all I have an inventory system. If the user selects a few delete and hit the &quot;delete&quot; button. Logically, the database figure will be adjusted. But what is while the process is being run, he hits the reload button? Will the database figures be re-deleted again? If so, is there any...

Hi All. Anyone had experience developing an Inventory System (using CF of coz)? I'm currently doing 1 now. I'm just wondering what is the best database design to store the stock My table (mySQL) design: table name = TBL_STOCKMASTER PRODUCTCODE ADDVALUE MINUSVALUE BALANCE UPDATEDATE UPDATETIME...

Hi All This may not be the suitable forum, but i had nowhere to go. I'm currently managing an Intranet of my company. I was thinking to work things with the marketing dept to promote our intranet. I had this idea, everyday the intranet would have 10 special icons appearing at random page within...

Hi All.. i'm not a ASP programmer, just being assigned to maintain a site. Recently i move a folder (by accident) to another location, and realising the mistake i move it back. After that everything seems to go wrong First i cant do an insert or update query, it will gives me...

is there any free CF hosting services? Just quit my job~ need some developing spaces (other than my http://localhost)

You can try this method: <cfquery datasource=&quot;offdarock&quot; name=&quot;qViewThreads1&quot; dbtype=&quot;oledb&quot;> SELECT name, email, date, subject, messageId, updated FROM forums ORDER BY updated desc </cfquery> <cfquery datasource=&quot;offdarock&quot...

Hi nsukari, What's wrong with your query? Seems ok to me~ <CFQUERY NAME=&quot;updatedb&quot; DATASOURCE=&quot;K&quot;> UPDATE Newtable SET absorbed='#Absorbed#', NameN='#NameN#', Name2='#Name2#' Where ID=#ID# </CFQUERY>

<CFQUERY NAME=&quot;CountUser&quot; DATASOURCE=&quot;officeDB&quot; DBTYPE=&quot;ODBC&quot;> SELECT count(tblAdmins.User_ID) as NumCount From tblAdmins, Log WHERE tblAdmins.User_ID = Log.User_ID </CFQUERY> <CFQUERY NAME=&quot;LastDate&quot; DATASOURCE=&quot;officeDB&quot...

A easiest but kind of inefficient method its to use 2 queries~ ======== Get the number of log in============ SELECT count(tblAdmins.User_ID) From tblAdmins, Log WHERE tblAdmins.User_ID = Log.User_ID ============================================= ======== Get the latest date============ SELECT...

Hi All As PDF form allows user to enter data online. Does anyone knows how to insert the data(from the pdf) into a database? My initial logic is, - the pdf will submit form to a url, http://xxx.com/accept.cfm - the accept.cfm will read in a file from the pdf. - accept.cfm will insert into...