User Profile

Collapse

Profile Sidebar

Collapse
NarutoFanatic
NarutoFanatic
Last Activity: Apr 3 '08, 02:43 AM
Joined: Mar 21 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • NarutoFanatic
    replied to ROLLBACK ALTER column statement
    in SQL Server
    Thank you for the help on this!
    See more | Go to post

      Leave a comment:

    • NarutoFanatic
      started a topic ROLLBACK ALTER column statement
      in SQL Server

      ROLLBACK ALTER column statement

      Hello,

      I'm having trouble using a transaction - rollback statement in sql. I can't seem to have the rollback executed during an error when i've altered a table to add a column with the same name (run the alter script twice on purpose to test the rollback). Somehow i got an error of the column should be unique (since the column already added during the 1st execution of the script). I want the sql execution to display the Failed instead...
      See more | Go to post
      • NarutoFanatic
        started a topic SQL 2005 Activex conversion help
        in SQL Server

        SQL 2005 Activex conversion help

        hello,

        can someone help me converting the following sql 2000 activex script we've used in our dts package to sql 2005 activex language:

        Code:
        Function Main()
	DTSGlobalVariables("WithError").Value = True
	Main = DTSTaskExecResult_Success
End Function
        and here's another one:
        Code:
        Function Main()
	If DTSGlobalVariables("WithError").Value = True then
		Main
        ...
        See more | Go to post
        • NarutoFanatic
          started a topic Type Mismatch: Session error
          in ASP Classic

          Type Mismatch: Session error

          Hi,

          Im currently updating our email sending functionality of our application. The website is written in classic asp and all codes are really a mess. anyway my problem is that our current process is to use the URL to pass variables from page to page, but i've found out that the max limit is about 2000 characters, and one value we need to pass is the text found in a text area. But the value to be pass is more than 2000 characters which...
          See more | Go to post
          • NarutoFanatic
            replied to excel vb macro - Row Count Filter
            in Visual Basic
            Thanks for the help. Now I have a new problem hehe.. I need to select just the content of one column after filtered. Is there a way to change the selected to be limited to a certain column?
            See more | Go to post

              Leave a comment:

            • NarutoFanatic
              started a topic excel vb macro - Row Count Filter
              in Visual Basic

              excel vb macro - Row Count Filter

              Hi, I need help. i'm having trouble with selecting the row counts using the vb macro. I need to select the row count of records with a given criteria in one column in excel. I've tried using filter criteria but somehow i got the total row counts including the hidden rows filtered by the criteria.

              Sample SQL:
              Select Count(*) From Sheet1 Where Column1 = 'Resident'

              Somehow i can't make this simple code in VB......
              See more | Go to post
              • NarutoFanatic
                replied to MS ACCESS concatenation - move different row into another column in the one row
                in Access
                Hi Mary!

                Thanks for the help! I've finally done it! hehehe!

                Here's my code hope this help to others:
                Code:
                Function SepSchool(Num As String, DRow As Integer) As Variant
Dim MyDB As Database
Dim rst As Recordset
Dim strOut As String
Dim strSql As String
Dim lngLen As Long
Dim i As Integer

Set MyDB = CurrentDb()

'Select All University Per Personnel
                ...
                See more | Go to post

                  Leave a comment:

                • NarutoFanatic
                  replied to MS ACCESS concatenation - move different row into another column in the one row
                  in Access
                  Hi Mary,

                  The data im using is about .5 million rows and its not advisable to use IIF since it would just make the query to take longer. Im trying to use the vba (modules) in the access.. and i think i could get the result only if i could select a certain row number (row 0, 1, 2, 3, and so on...) is there a way to select certain row number based on the query.

                  Sample:

                  Select * from table.

                  ...
                  See more | Go to post

                    Leave a comment:

                  • NarutoFanatic
                    replied to MS ACCESS concatenation - move different row into another column in the one row
                    in Access
                    Hi Mary,

                    I need this to avoid multiple rows with the same student#. i want to elimanate this rows and contain them into one row for each student. I tried using concatenate (using modules) and it works fine although all concatenated fields are in one column see sample below.

                    ex.
                    Std# School Degree YrGrad
                    00001 ABC, ROC Science, Math ...
                    See more | Go to post

                      Leave a comment:

                    • NarutoFanatic
                      started a topic MS ACCESS concatenation - move different row into another column in the one row
                      in Access

                      MS ACCESS concatenation - move different row into another column in the one row

                      Hi!

                      I need help in MS ACCESS, I need to create a query that could move different rows into another column. More like concatenation but in a different column rather than in one column. Example:

                      OLD TABLE

                      Stud# School Major YrGrad
                      00001 ABC Science 1996
                      00001 ROC Math 2000
                      00002 SAR Biology ...
                      See more | Go to post
                      No activity results to display
                      Show More
                      Working...