Jump to content
xisto Community

daf

Members
  • Content Count

    16
  • Joined

  • Last visited

Posts posted by daf


  1. wut is a database and wut is it used for?

    <{POST_SNAPBACK}>


    database means a way to storage, retrieve and manage data. Every sort of data.

     

    databases storage data following a well definied structure.

     

    That "structure" aids to mantain data in order and find data you desire.

     

    database means nowadays "computer-based database", but database is a generic term that represents every form of structured information. A file folder in an office is a "physical database", becasuse let you stock files and find speedly data you want, due to its subdivision of file in folders.

     

    Software databases follow the same approach. They let you cluster elementary information in "tables", collections of similar datas. A database can hold many tables linked each other to build a structured knowledge of a specific fact.


  2. Another approach to this problem is to "merge" week info into your drivers table, instead of spreading it all over 43 tables, requiring in this way a script language to manage it on an higher abstraction level.

    If you add and ID_WEEK column to gulfOwnerDrivers table, setting ID_WEEK from 1 to 43 for every set of drivers per week, you'll be able to store all your data in one table.

    All queries concerning this table will be constrained by a WHERE ID_WEEK = <week> clausole in order to select every time only one particular week results.

    prototype of query for gulfOwnerDrivers:

    SELECT ownerIndex,driverIndex1 int,driverIndex2 int,driverIndex3 int,driverIndex4 intFROM gulfOwnerDriversWHERE ID_WEEK = <week>
    <week> is an alias for a certain number of week.

  3. I am trying to run the following asp function:

    code:--------------------------------------------------------------------------------

    Private Function GetAbs(dThisDate, lPartID)

    sql_abs = "SELECT AbsCode FROM Absence WHERE AbsDate = '" & dThisDate & "' AND PartID = " & lPartID

    Set rs_abs = conn.Execute(sql_abs)

    GetAbs = rs_abs(0).Value

    Set rs_abs = Nothing

    End Function

    --------------------------------------------------------------------------------

    It works fine if it finds a record but returns an error if it doesn't. How can I avoid this error?

     

    Thanks!

    <{POST_SNAPBACK}>


    i'm not good skilled in ASP, but i suppose you have to test first if rs_abs is empty before trying to get its value.

  4. I think you're facing with character fields, where you have an empty string that is different from a NULL value of a character field.A NULL value represents the absence of a value for a record in a field (others softwares call it also a missing value).An empty value is a "field-formatted" value with no significant data in it.Why an "empty character string" is different from a null value? Cause you're comparing a string (with no characters inside) with a "cell" with no data type: they differ !In mySQL an empty string "" isnt' a null value, in Excel a blank (character) cell is filled with an empty string ( "" ).


  5. Ok here is the problem some people complain that they cant coonect to my game server casue they have the same ip is there any way that can be resolved ?? please let me know.

    <{POST_SNAPBACK}>


    I really don't think "same IPs" is your clients connection problem. It will be probably a firewall matter. You will need to open some ports to let data exchange. IPs on internet can't be the same, IP uniqueness is an internet fundamental feature.

  6. waterfall "trick" only works on win9x. win nt/2k/xp are "waterfalled" by their own.waterfall basically executes an HLT instruction to set CPU on a suspend mode.In Windows NT/2k/xp you can see an "idle process" running in task manager window, that takes 99% CPU usage in a system idle situation, that process has the only task to send HLT instruction to CPU.


  7. ...

    But like Opaque mention UDP has it's uses. Mainly these are for streaming live audio and video. For example on a phone conversation it really doesn't matter if every packet mades through, atleast if the alternative would be increased lag. One packet missing from speech doesn't affect much on how well the actual message is received, but if it was, say a zip file, transfered one inverted bit could mean loss of the entire data.  But that's why there are different protocols for different tasks.

    <{POST_SNAPBACK}>


    All the online gaming world is also based on UDP packets: it's necessary to send as quick as possible data from server to clients no matter if they receive all the packets.

  8. I use IPB, for my websites, and it's free to. The only thing you have to do is leave the copyright.

     

    PHP is good, it's easy, etc. but what some people don't understand with IPB for example is that it's not because they have installed a IPB that the can create a webpage. those peolple forget that the basic language of PHP is HTML. You have to know HTML before you begin with PHP.

    <{POST_SNAPBACK}>


    IMHO this not the correct point of view.

     

    HTML is the "natural" output of every CSM, of every server-side scripting language at all. But that's it only because HTML was (and is) the "hystorical partner" of internet, as we all know. HTML is far from every scripting language, but every scripting language is forced to face with it.

     

    An internet without HTML would be a better internet, but Internet as we all know is "made of" HTML. :)

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.