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 Rhinorhino 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: b00gieman
  • Content: Threads
  • Order by date
  1. b00gieman

    Variables value

    Hi, I have the following code: ID=Request.QueryString("ID_No") .... if(....) then ....... if ID>0 then ........ else ....... end if end if My problem is the following:in the if condition , the ID variable has lost its value.Am I doing something wrong?
  2. b00gieman

    Newb Question on asp:Image

    Hi, I want to insert an image into my site.My problem is I cannot see the image when running the site.The code I'm using is: <asp:Image ID="img1" ImageUrl="~/App_Data/image1.jpg" runat="server"/> How can I fix this problem? Thanks!
  3. b00gieman

    access SQL server 2005 database from SQL server 2000

    Hi, Is it possible to access a MS SQL Server 2005 database using MS SQL Server 2000 using Enterprise Manager? Thanks in advance!
  4. b00gieman

    DTS 'Execute SQL task' with parameters

    Hi, Is it possible to have a 'Execute SQL task' with parameters like: if 'input_parameter'='value' 'sql_query' else 'sql query' ? Thanks in advance!
  5. b00gieman

    Alternative to sp_OACreate?

    Since I cannot use xp_sendmail(in MS SQL Server 2000) , I've created my own stored procedure for sending emails.The problem is I get error messages regarding the usage of sp_OACreate , sp_OAGetErrorInfo , sp_OASetProperty , sp_OAMethod.It seems I cannot use the stored procedures from the master...
  6. b00gieman

    xp_sendmail as different user

    Hi! I want to use the xp_sendmail procedure for my database.The problem is I don't have the rights to run the procedure. Instead , I recieved a name that I should run the procedure under.From what I read , I should call the procedure like this: EXEC master.dbo.xp_sendmail...
  7. b00gieman

    cast function

    Hi! Is it possible to update the content of a column from a table(smalldatetime) with nvarchar data using CAST? The nvarchar string is mm/dd/yyyy and so is the date format
  8. b00gieman

    authentication in cdo.message

    Hi! Could someone pls tell me what's the difference between Basic authentication and NTLM authentication in cod message? Thanks in advance!
  9. b00gieman

    delete files

    Hi! I developed a com+ component for sending emails with multiple attachments.The uploaded files are stored on a directory and after the email is send, they are supposed to be deleted.The only problem is that the files aren't deleted.The code looks like this: Set oFolder =...
  10. b00gieman

    Triggered action

    Hi! Can some sort of a trigger be made,so when a users saves a file to the disk,this trigger activates? Thanks!
  11. b00gieman

    loop in ms sql 2000

    Hi! Is there a possible way for looping through the records of a table(like using foreach - oracle)?
  12. b00gieman

    Create a dll using VB6 Working model

    Hi! Can you make a dll using VB6 Working model edition(an ActiveX dll)? thx!
  13. b00gieman

    'Continue to message' email component

    Hi! I have recently added the option of attaching files to my email component.I have a question:what should I use so that after the user attaches the files he can contnue to write the message.What should I do to retain the text?
  14. b00gieman

    MoveFile problem

    Hi! I have to move a file from a server to another.I tried to use the MoveFile method for this , but I'm getting the following error: Microsoft VBScript runtime error '800a0035' File not found the command looks like this: fs.MoveFile Server.MapPath("upload/tmb.xls")...
  15. b00gieman

    Openrowset problem

    Hi! I developed an application for importing data from an excel file to a sql table using openrowset.My problem is that some values are 'truncated' somehow. For example,a value from the excel file like: 87987845 will appear in the sql table like: 8.79878e+007.Can somebody help me with this...
  16. b00gieman

    Upload files to a different folder

    Hi! I have an application that uploads files.The files are uploaded in a folder(called upload) where the asp script is.The code: objUpload.File(x).SaveToDisk(Server.MapPath("upload"), "") Could I save the files to a different server?(different than the one running the asp script)
  17. b00gieman

    Copy files from a server to another

    Hi! I have a script that uploads files to a server.However,I need to copy the uploaded files to another server.How do I do this? Thanks!
  18. b00gieman

    excel to csv

    Hi! Dunno if this is the right place to ask,but....can somebody recommend a good script for transforming excel files into csv files? Thanks in advance!
  19. b00gieman

    Bulk insert

    Hi! I want to import data from an excel file into a ms sql table.I tried to use openrowset for this,but i ended up recieving this error: [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005...
  20. b00gieman

    MS SQL problem

    Hi! Can somebody tell me what's wrong in this SQL command: SELECT * INTO dbo.shopping_TSR FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database='c:\inetpub\wwwroot\fileuploader\upload\tmb2.xls'', 'SELECT * FROM [Sheet1$]') because I'm getting this error: Incorrect syntax near 'c:'

Part and Inventory Search

Back
Top