Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sgdragon78

    Typical XML architecture

    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...
  2. sgdragon78

    Typical XML architecture

    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...
  3. sgdragon78

    refresh problem

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

    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...
  5. sgdragon78

    refresh problem

    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...
  6. sgdragon78

    refresh problem

    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...
  7. sgdragon78

    inventory system

    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...
  8. sgdragon78

    random floating image appearing in an Intranet

    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...
  9. sgdragon78

    Hi All.. i'm not a ASP programmer,

    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...
  10. sgdragon78

    Anyone Recommend Good Coldfusion Hosting Service?

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

    Compare value from one table to another table

    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...
  12. sgdragon78

    Updating more than one record at a time

    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>
  13. sgdragon78

    Record Count with most Recent Date

    <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...
  14. sgdragon78

    Record Count with most Recent Date

    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...
  15. sgdragon78

    Submit PDF Form into database

    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...
  16. sgdragon78

    Month list between 2 dates!

    Not sure is this the easier and shortest way. And you may need to run the script to check for errors. :> <Cfoutput> <Cfset numMonths = DateDiff(&quot;m&quot;, date1, date2) <cfloop index=&quot;a&quot; from = &quot;1&quot; to =&quot;#numMonths#&quot;> #monthasstring(DateAdd(&quot;m&quot;, 1...
  17. sgdragon78

    What if there is no picture, how to not show broken window?

    Hi All, First time posting here. Is it possible to use solve by this method: ============== in application.cfm ======================= <cfset thisPath = ExpandPath(&quot;*.*&quot;)> <cfset thisDirectory = GetDirectoryFromPath(thisPath)> =========================================================...

Part and Inventory Search

Back
Top