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 strongm 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. whateveragain

    2nd call to form doesn't work

    I call formA which displays a table. FormA calls another formB, which allows me to make selections that calls 2 SPs and alters the table displayed in formA. When in formB, focus is no longer on formA. The changes in the tables are made correctly, but the original table still displays when I call...
  2. whateveragain

    Retrieving Data from a Stored Procedure

    I'm trying to retrieve a value from a stored procedure but the SP doesn't return the correct value. asp.net VB code: Sub ckselections() Dim sqlConn As New SqlConnection Dim sqlComm As New SqlCommand 'Create a SqlParameter object to hold the output parameter value...
  3. whateveragain

    Tables will not drop

    What reasons are there for a table not being dropped? I tried the following 3 ways and none of them work. If I run the SP outside the app, it works. The SP is being called and run because I created a junk table within the SP to see if it were being entered. None of these tables are being used in...
  4. whateveragain

    Stored procedure doesn't work 2nd time around

    I may have asked the wrong question in a previous post. I call a stored procedure twice. The first time it works. The second time, it seems that it's not even entered. What should I look for? Below is the process: 1. FormA = made selections calls stored procedureA to create tables 2. stored...
  5. whateveragain

    Microsoft JScript runtime error

    I upgraded my IE to version 9 and now when I run asp.net apps that were once working get javascript errors. I didn't write these scripts, it's the behind-the-screen code. I can hit ignore and continue, but it's annoying. I tried to look to uninstall this IE 9, but it seems that's no longer an...
  6. whateveragain

    Which Data source to use?

    FormA has a gridview and a SQLDataSource control which refers to a dynamic table which was created in the screen prior to FormA. On FormA there is a button that leads to FormB, which allows restrictions to the table displayed in FormA. Currently I drop the table and try to recreate it, then...
  7. whateveragain

    How can I resuse code

    How can I reuse code without using code snippets or cutting and pasting. I was hoping that I could use some sort of class, but it seems that classes are meant for the entire page or a portion of the page. I don't want to use snippets because if a change is needed, I'll need to go to each page...
  8. whateveragain

    Bulk load data conversion error (truncation) for row 7

    The following dynamic bulk insert works but gives an error on the last record. I checked the import and the data was in the file. What would cause this error? ERROR MSG: Bulk load data conversion error (truncation) for row 7, column 1 (dircode). [Note: Dircode is the name of the column of the...
  9. whateveragain

    Import data from text or XLS file to a table on the server

    I want users to be able to upload data from either a text file or XLS file. Below I'm using an example for XLS. Whether I write code to upload a text file or an Excel file. I keep getting the following error: " ErrorCode=-2146232060 LineNumber=1 Message="Incorrect syntax near 'c:'. in...
  10. whateveragain

    span question

    I have an online catalogue. I'm trying to get the pictures to float right of the text. I'm using the following code. Some of the items display the picture and some do not. All have the same code, but with different item #'s. What would cause Span code to sometimes work and sometimes not? What...
  11. whateveragain

    Need SQL 2008 Connection String Help

    I have been trying to get my connection string going for a couple of days and am getting nowhere. The following is my info. Can someone help me put together the proper connectionstring for SQL 2008 Server? I already tried http://www.connectionstrings.com/sql-server-2008 to no avail. server...
  12. whateveragain

    Error when opening SQLEXPRESS

    I just installed Developer SQL 2008 and the sp2 onto a Vista machine. When I open SQL 2008 via the following settings I get the following error. I even disabled the fire wall: Server type: Database Engine Server name: MYCOMPUTER-PC\SQLEXPRESS Authentication: Windows Authentication Error: A...
  13. whateveragain

    Graphic will not display on line

    Hello, I have a completed website all written in html. It works just fine on my machine and my client's machine. Once I put it on the server, all works except for the 1st graphic. I tried changing it to a png and a jpg. Neither work. Any suggestions?
  14. whateveragain

    VFP & Excel 2010

    VFP works fine with Excel 2010 on most machines except for one client. Unfortunately, I don't know what OS. She keeps geting a 'detail band is too large. I shrunk the report in question and she's still getting this error. I told her to try it on another printer. To my knowledge, she didn't have...
  15. whateveragain

    Dell Inspirion 5000e Internet Connection

    Hello all, I received an old Dell Inspiron hand-me-down laptop. It has a modem and a Linksys Wireless-B Notebook Adapter Model No. WPC11 Ver. 4. The Linksys adapter works fine and shows connected. The OS is Windows 2000. I don't know how to make a wireless connection to the Internet with...
  16. whateveragain

    Checking if a dynamic table exists

    Can anyone please tell me how to write code to check if a dynamic table exists? The code below only works if table exists otherwise I get error. @preseldma is a dynamic table. if exists(select * from dbo.sysobjects where id = object_id(N'[dbo].[@preseldma]') and OBJECTPROPERTY(id...
  17. whateveragain

    Find formulas of built in Excel functions

    I just placed a bid which requires taking an Excel application and re-writing it to a computer programming language in order to make an executable. How can I find the formulas behind the functions in Excel, such as the function payment()? Thanks
  18. whateveragain

    Import to SQL table from VFP table

    I'm trying to import from a free VFP table on my hard drive. 1) Do I have to be concerned about Ad Hoc Distributed Queries being turned off? 2) What is wrong with the syntax in the following code? I'm getting an error message: Msg 102, Incorrect syntax near ',' Code: use yeldata go Insert...
  19. whateveragain

    automated update of website

    A potential client was talking to me about how her web site is updated. She stated the following: "The big companies that I work with (Bla Bla Bla) allow you to download all of their products in either excel or cvs I then take their form and upload it on our site. I'm new to asp.net. I...
  20. whateveragain

    Speed Issue

    I have two VFP applications similar in functions but different formulas. One is 2 MB larger than the other. The larger one works fine on my client's computer, but the smaller one does not work well. It's very slow. Both applications work well and fast on two of my computers. What would make apps...

Part and Inventory Search

Back
Top