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!

  • Congratulations Mike Lewis 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: *

  1. JonathanC

    Customize

    You can actually modify some parts of the PHP codes if you really want to customize it.
  2. JonathanC

    How to save a Posted File to Text, Ntext in SQL?

    I have a problem with saving a posted file to the database as a text column. I know that array of bytes easily can be saved to an image field to the sql by using the sql parameter with type images. I tried this to a text file by just changing it to text and gives me an error... Public Sub...
  3. JonathanC

    Hello World Web Service problems

    That helped me a lot man! Thanks for this post!
  4. JonathanC

    "<INPUT TYPE=FILE>" How to assign a default file extension?

    When you use <INPUT TYPE=FILE> and open the FileOpen Dialoge Box through clicking Browse... how would you programatically set the default file type (eg. *.avi instead of All Documents)?
  5. JonathanC

    Hi every one I received a mail

    Tips: a)Make sure you collect your garbage at the end of a program or procedure. b) allocate resources late and deallocate as soon as you finish using them. c)avoid manipulating recordset after response.write, an sqlrs.getrows assigned to an array and manipulating that multidimensional array...
  6. JonathanC

    Hi every one I received a mail

    Check out the following link: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q175167 In this reading, I recommend using hidden variable to maintain state. Though its tedious to write, it would pretty work fine rather than using Session or Application variables.
  7. JonathanC

    Calling an ASP page from a HTML page

    You haven't even asked if they have IIS installed. :)
  8. JonathanC

    SQL warnings creating VB error objects.

    I have never used params in ADO, first of all its too much code.... how about this... set sqlrs = sqlcnn.execute(myconcatenated_sqlstring) where sqlrs is the recordset and sqlcnn is the connection
  9. JonathanC

    Data Environment Pros and Cons

    Data Environment is very good for tradition client/server applications. Data Environment strong point is ease of development of database applications using windows forms on a two-tier environment. Obviously you wouldn't use this for multi-tier development. Moreover, since our ado...
  10. JonathanC

    I don't know where to begin....

    Please don't use such kind of subject line again. Make it clearer so everybody can get hold of your problem immediately. Anyway, you may begin by creating an ActiveX DLL Project. Compile it and register it through COM+. Call your component using Server.CreateObject.
  11. JonathanC

    VB Dot-Nettiness - What does it mean?

    As a VBER... adding some more ingredients like UML new spices like XML and Web Services... collect your garbage using GD.Collect and wash your hands with SOAP finally cook your recipe with the CLR. you'll definitely sell like pancake!
  12. JonathanC

    How to create a Pegasus using VB.Net

    Can VB.Net create a Pegasus based on a Bird and a Horse? Is multiple Inheritance a .Net Limitation?
  13. JonathanC

    Installing Queue Server in two Domain Controllers on Same Domain.

    Is it possible to install MSMQ 2.0 on the a new domain controller when a MSMQ server is already installed on another domain controller in the same domain? I ask because I am having a problem installing MSMQ on the the new domain controller. It has an error 0xC00E0013. Unable to establish...
  14. JonathanC

    Identifying Columns with highest value

    Thanks TL, I knew this solution, I was just figuring out if there's a shorter way because I have 15 columns and, though possible, I somehow am thinking twice of doing it like that! But you're the great guy...I guess that's the only option I have so I'll do it that way!
  15. JonathanC

    Saving RS from a StoredProc

    on SP2...create a varchar string of your query using a variable tablename coming from SP1. Execute the string using sp_executesql.
  16. JonathanC

    Identifying Columns with highest value

    How would you identify the column with the highest value in a table? I have this table description matrix(name,vala,valb,valc,vald,vale,valf,valg,highestval) i need to somehow assign to highestval which among the columns has the highestvalue, like assigning 'A' if vala has the highest value.
  17. JonathanC

    SQL Server Service Pack 2000

    Be careful with installing any Service Pack specially when you previously installed some hotfixes. We had a lot of problems before in xp_sendmail that we even discovered a bug where Microsoft did a hotfix. We are not sure yet if the hotfix was included as part of SP2 so we're not taking the...
  18. JonathanC

    Difficult Data Manipulation

    I wouldn't say temp tables are inefficient. Using cursors when you can substitute it would temptables will far be more inefficient.
  19. JonathanC

    xp_SendMail Error

    That was very helpful!
  20. JonathanC

    xp_SendMail Error

    declare @file nvarchar(300) set @filename = ' \\'+@@servername+'\bi\acctTest\BofaPPay\' + convert(varchar(20), getdate(),12)+ substring(convert(varchar(10),getdate(),8),1,2) + substring(convert(varchar(10),getdate(),8),4,2) + substring(convert(varchar(10),getdate(),8),7,2) + '.txt' set...

Part and Inventory Search

Back
Top