Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: aalmeida
  • Content: Threads
  • Order by date
  1. aalmeida

    Cannot instantiate abstract class system\database\ORM

    I'm trying to learn MVC and need to query a MySQL database using PDO and ORM but I can't seem to get it right, here is the code: use system\database\ORM as ORM; class Product extends ORM { private $prod_data; private $con; private $data; public function Product(){...
  2. aalmeida

    Need Help getting value in\out of variable

    I'm using VS 2008 SP1 trying to create a SSIS package but hit a wall. String DBName = (Dts.Variables["User::DBNames"].Value).ToString(); This code should return a string with the DB name but instead returns the variable data type System.__ComObject. Any ideas? AL Almeida CIO...
  3. aalmeida

    Ajax to fill in two form text fiels

    The issue with this, is the onclick behavior that does not cause the result to be selected and subsequently fill in the "id" and "find" text fields. Bellow the javascript part: // Ajax Functions $('document').ready(function(){ $('#loading').hide(); $('#find').click(function(){...
  4. aalmeida

    Help needed with Ajax using JQuery to return 2 values to 2 form fields

    I'm having an issue with Ajax using a JQuery (to query MSSQL 2K8) to populate 2 text fields as you can see in the code below I have two PHP pages. The main page that have a form with 2 text fields that need to be field with the selected result from the second page Ajax JQuery query. I'm not...
  5. aalmeida

    Help needed with an Ajax using JQuery to return to values to a form

    I'm having an issue with Ajax using a JQuery to populate 2text fields as you can see in the cold below I have two PHP pages. The main page that have a form with 2 text fields that need to be field with the selected result from the second page Ajax JQuery query. I'm not being able to make the...
  6. aalmeida

    Help with: System.Runtime.InteropServices.COMException

    System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {58968145-CF05-4341-995F-2EE093F6ABA3} failed due to the following error: 80040154. I made a program with Visual C# 2008. There are 2 forms in the program. The program works well...
  7. aalmeida

    Help with: Unable to cast object

    Unable to cast object of type 'System.Data.Linq.Binary' to type 'System.Byte[]'. Another C# Linq to SQL issue this time with Image datatype conversion. The situation is this: I add an image to a database table to a column that is type Image using the folowing process: /// <summary> ///...
  8. aalmeida

    Help Going back to Form1

    I'm new to C# and am trying to create a WFA where I have the need to go from form 1 to Form2 and back. My problem is coming back from form2 to form one.Bellow is the code on form2: public partial class form2 : Form { public Object CallingForm; public Form frm2...
  9. aalmeida

    How can I upload a file and it's description together, in one shot?

    All, I'm able to upload a file and latter insert a description to this file in my database but when I attempt to upload the file and it's description on the same form it fails to send the file posting only the description. Is there a way to make it possible for the same form to post the file...
  10. aalmeida

    Windows forms VB 2008 Linq Question

    I'm building this WF app and am trying to insert new data to my table (tbl_registro) but am not able to commit the insert to the database. I'm using a local database file (SQLExpress). This insert seems to stay in memory until I close the debug but it does not make into the database. Here is the...
  11. aalmeida

    PHP MySQL query to identify company URL

    There is a table that matches URL to a specific company the problem lies when a company has more than one URL. Table tbl_company Comp_Id Comp_Name Comp_URL 10 CompA www.compa.com 20 compB www.compb.com, www.compb1.net Initially I thought I could identify the company by the URL the user came to...
  12. aalmeida

    PHP 5.2.8 Array issue

    This is really odd and it seems to affect the Win32 version of PHP5.2.8 running on Windows 2003 and IIS6. require_once('Connections/MySQLDb.php'); if (!isset($_SESSION)) { session_start(); session_register($_compname); session_register($_compID); } $MM_Company_rs_company =...
  13. aalmeida

    Another SSIS issue

    I have a SSIS package that is giving me a weird error message: Error Message: Executed as user: DEV\SQLAgent. Microsoft (R) SQL Server Execute Package Utility Version 10.0.1600.22 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Option " /SERVER" is not valid. The...
  14. aalmeida

    Another SSIS question

    I have a SSIS package that is giving me a weird error message: Error Message: Executed as user: DEV\SQLAgent. Microsoft (R) SQL Server Execute Package Utility Version 10.0.1600.22 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Option " /SERVER" is not valid. The...
  15. aalmeida

    How to determine which Stored Procedures are not used?

    All, I came across the need to clean up some databases, and I'm in need of a Stored Procedure or process that would determine which stored procedures have not been used since the last restart of the server. Does anyone have anything like this? AL Almeida Senior DBA http://www.ajmedia.net/...
  16. aalmeida

    How to find the tables a FK references?

    I've been trying to create a query that would return me the drop and create Foreing Key constraints on every table of a database I was able to create the Script to drop constraint but I've not been able to create the script to recreate the constaint because I cannot find the table and column...
  17. aalmeida

    help with Script to DROP and CREATE all Foreign Key constraints

    I've been trying to create a query that would return me the drop and create Foreing Key constraints on every table of a database I was able to create the Script to drop constraint but I've not been able to create the script to recreate the constaint because I cannot find the table and column...
  18. aalmeida

    SQL Server Error 15234 Object is stored in sysprocedures and has no sp

    I have a sproc that goes to all DBs in the server and makes a list of all objects, but recently it started to fail with (Error 15234) Object is stored in sysprocedures and has no space allocated directly. [SQLSTATE 42000] (Error 15234). Does anyone have seen this before? and how can it be...
  19. aalmeida

    SQL Srvr 2k on Win2003 upgrade to SP4

    Folks, we upgraded some of our servers to SQL SP4 and noticed some increase in the CPU ussage. Does any one know how to fix this issue? did anyone else found any other issues with SP4? AL Almeida Senior DBA http://www.saxotech.com/ &quot;May all those that come behind us, find us faithfull&quot;
  20. aalmeida

    No Replicated Transactions are available on a Snapshot Replication

    I set up a Snapshot Replication and added 9 subscribers and the snapshot worked great on 7. On 2 however the Agent History shows 'No Replicated Transactions are available' even though data have been changed on the tables. It appears to be firing on schedule, but that is the message every time it...

Part and Inventory Search

Back
Top