Search results

  1. Kodo

    can anyone help?

    ok, the big problem here is that your database is not normalized. By this I mean that there is repetetive data in your cards table. I'm assume your table is something like: cardid (Primary Key) cardtype (string) producttype (string) ProductGroup (string) description (string) All of those can...
  2. Kodo

    ASP Server

    something like Nero will be able to burn that to a disc for you.
  3. Kodo

    Passing CSV to Stored procedure

    Quotes(") are invalid characters SELECT dbo.tblClient.Country, dbo.tblClient.cName, dbo.tblClient.clientID, dbo.tblClient.Wholename, dbo.tblClient.TelNumberG, dbo.tblClient.TelNumberD, dbo.tblClient.City FROM dbo.tblOrders INNER JOIN dbo.tblClient ON...
  4. Kodo

    IIf in view

    for the null replacement you can do ISNULL(FieldName,ReplacementValue)
  5. Kodo

    Transfer Text across Textareas

    Rock with this and see if you can get it to work with your code. <html> <head> <script language="javascript" type="text/javascript"> function addtext() { var newtext = document.getElementById("mymenu").options[document.getElementById("mymenu").selectedIndex].value...
  6. Kodo

    Transfer Text across Textareas

    This can be done with Javascript. You'll need to make a function that grabs the current listbox item and appends it to the the text area. In that function you will replace the markers with the appropriate text. I would recommend something like [STUDENT_NAME] and [STUDENT_SEX] as example markers...
  7. Kodo

    Transfer Text across Textareas

    would this be a list selection type scenario? Teacher has dropdown list of generic comments. Teacher clicks item in list.. blank comment box gets filled in dynamically without posting a form. Is that the type of scenario are you shooting for?
  8. Kodo

    Both a Peon AND a King

    to expand on what Pat is saying: You'll need a bridge entity. table1: People ID person name ... table2: Type ID type name ... table3: Person_Type(this is the bridge) PersonID TypeID this will allow you to have unlimited people with unlimited types and many people of different types all...
  9. Kodo

    Epitaph

    :D couldn't resist.
  10. Kodo

    Closed Source and Open Source: Can they co-exist?

    They're not even in the same ball-park. MySQL is not a portable database like MS Access is. MySQL is a database server and is more like MSSQL than MSAccess. MySQL 5 supports triggers and sprocs now... it's superior to Access with regards to functionality, But you can tell me how vBulletin...
  11. Kodo

    Please help me with SQL...

    I have to ask.. why are you not putting these into queries??
  12. Kodo

    Closed Source and Open Source: Can they co-exist?

    Here's a laugh for you guys. My boss was in a meeting today and the client asked how good MySQL is. My boss tells him that it's just a bit better than MS Access. HAHAHAHH!!! I am going to quit this job soon because I hate liars.. :D
  13. Kodo

    Cast Not Valid Exception

    ah..v1.1 in the tool box it's DataGrid. The hook up should be the same.
  14. Kodo

    Trigger Question: select from deleted

    yes, I did. I tried emailing you but the address you pm'd me bounced. In any case, I ended up resolving this by making a further normalization to my db and running the deletes on the table while leaving the parent record intact which is was I wanted to simulate .. alas, that night I had a brain...
  15. Kodo

    Get final part of current URL

    split on the / strCurrentURL=split(request.servervariables("URL"),"/") ThisFolder=strCurrentURL(ubound(strCurrentURL)-1)
  16. Kodo

    Cast Not Valid Exception

    Yup! The gridview is a control that display data in table structure for you. You have to do very little to make this happen. Drag a gridView onto your page from the toolbox and on page load you can grab the data from the databaes and bind it to the gridView. Public Function GetMembers()as...
  17. Kodo

    Setting a default column value using SQL

    everything you'll need to know is here http://msdn2.microsoft.com/en-us/library/ms190273.aspx
  18. Kodo

    Notes field in a Database

    think of it this way. The notes table is going to hold the policy id of the policy the note is placed on right? so your data might look like this policy ID note 1 lorem ipsum for policy 1 2 lorem ipsum for policy 2 1 lorem ipsum for policy 1 1...
  19. Kodo

    Cast Not Valid Exception

    why not just load this data into a gridview?
  20. Kodo

    time calculation

    sdate=formatdatetime(sdate,4)
Back
Top Bottom