User Profile

Collapse

Profile Sidebar

Collapse
IamMacro
IamMacro
Last Activity: May 18 '07, 11:32 AM
Joined: Apr 2 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • IamMacro
    replied to Datetime in Where clause.
    in SQL Server
    I tried this and i can get the Date now . but i want the other dates to be the way they are...

    selectcommand.C ommandText = "SELECT convert(nvarcha r(10),datum,101 ),convert(nvarc har(10),beginuu r,100),convert( nvarchar(10),ei nduur,100) from geenwerkdag where datum='" & dtewerk & "'"
    See more | Go to post

      Leave a comment:

    • IamMacro
      started a topic Datetime in Where clause.
      in SQL Server

      Datetime in Where clause.

      Hi i know this has been asked alot but i couldnt find anything that worked.

      My query looks like this :
      My dates in the SQL CE = "2007-05-11 15:25:40"


      "Select * from table where Workdate='" & dtework & "'"


      Ive tried to use "Like dtework "%" ""

      Now i cant seem to just select on a date "2007/05/11"...
      See more | Go to post
      • IamMacro
        started a topic Sql query , Date time problem.
        in MySQL

        Sql query , Date time problem.

        Code:
        hulp5 = "02-02-2006"
timesynced = Date.Parse(hulp5)
Dim msqlDA As New MySqlDataAdapter("select * from Work where DateCreated <' " & timesynced & " ' ", myconnection)
        I cant seem to get the "timesynced "
        when i do every date smaller than my Timesynced it returns all the values that have
        <Datumcreated>0 001-01-01T00:00:00-08:00</datecreated>...
        See more | Go to post
        • IamMacro
          replied to how to transfer data from XML file to MySql database
          in XML
          Im looking for a similar solution to this.

          Im not entirely new to XML but im still a bit puzzled.
          Im using a Vb.net program on a Pocket PC to create a xml file which should be uploaded to a PHP mysql server , how should i create my XML file that users can just click a button and the xml files get uploaded to the server (using HTTP)
          The server's IP in the internal netwerk = 192.168.25.120

          I'll Be sending...
          See more | Go to post

            Leave a comment:

          • IamMacro
            replied to Xml merging , updating
            in XML
            Yeah im able to use XMLdocument.
            See more | Go to post

              Leave a comment:

            • IamMacro
              replied to Xml merging , updating
              in XML
              I forgot to mention im using the compact framework to develop in. And ive looked through the forum and someone was programming with CF , and couldnt get XSL to work.
              See more | Go to post

                Leave a comment:

              • IamMacro
                replied to Xml merging , updating
                in XML
                Sorry about that , i pressed tab some times and pressed enter.


                Code:
                    <client diffgr:id="klant1" msdata:rowOrder="0">
      <ClientID>1</KlantID>
      <clientName>E</KlantNaam>
      <Street>HEI</Straat>
-2
-3
-4
-5
-6
-7
(number 8 is this , its a duplicate)
     <client diffgr:id="klant1"
                ...
                See more | Go to post

                  Leave a comment:

                • IamMacro
                  started a topic Xml merging , updating
                  in XML

                  Xml merging , updating

                  Code:
                        
<Klant diffgr:id="Klant13" msdata:rowOrder="12">
      <KlantID>13</KlantID>
      <Klantnaam>PEETERS STOOPS</Klantnaam>
      <Straat />
    </Klant>
                  See more | Go to post
                  Last edited by dorinbogdan; Apr 2 '07, 12:06 PM. Reason: updated title
                  No activity results to display
                  Show More
                  Working...