Search results

  1. 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...
  2. 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...
  3. 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?
  4. 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...
  5. Kodo

    Epitaph

    :D couldn't resist.
  6. 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...
  7. Kodo

    Please help me with SQL...

    I have to ask.. why are you not putting these into queries??
  8. 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
  9. Kodo

    Cast Not Valid Exception

    ah..v1.1 in the tool box it's DataGrid. The hook up should be the same.
  10. 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...
  11. Kodo

    Get final part of current URL

    split on the / strCurrentURL=split(request.servervariables("URL"),"/") ThisFolder=strCurrentURL(ubound(strCurrentURL)-1)
  12. 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...
  13. 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
  14. 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...
  15. Kodo

    Cast Not Valid Exception

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

    time calculation

    sdate=formatdatetime(sdate,4)
  17. Kodo

    Notes field in a Database

    make another table called policy_notes. In that table make three fields note_id of type autonumber: (unique record ident) policy_id of type number: this is the foreign key and will hold primary key value of the particular policy. note_note of type memo: this will hold the note information...
  18. Kodo

    Auto Sort Anyone

    make a query for the sub form that pulls out the data you need and have the query sort on the field(s) you want.
  19. Kodo

    Access skills - HOT or NOT??

    I had forgotten about that. I built an Access app about 2 years ago for a few users and the db grew huge really quick and I ran into this problem. I never did get a chance to move it to at least the MSDE.
  20. Kodo

    Access skills - HOT or NOT??

    I agree, but you didn't give me any limitations :p
Back
Top Bottom