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 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: *

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

    Line 1: Incorrect syntax near ','. Unclosed quotation mark before the

    Can someone please review my code and see where I can be missing information. I get the following error: Line 1: Incorrect syntax near ','. Unclosed quotation mark before the character string ' )'. at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection)...
  2. dougancil

    Operating system error code 3(The system cannot find the path ...)

    I have a page that I've built that does a bulk insert from a file that is stored on a web server. When the user clicks on the submit button, they receive the following error: Operating system error code 3(The system cannot find the path specified.). I have made sure that the SQL server has...
  3. dougancil

    File not being uploaded but also not receiving any errors

    I have a site that I've almost completed and while testing it today noticed that it's not uploading any files or doing the bulk insert in SQL that I need it to. Here is my codebehind: Imports System.IO Imports System.Data Imports System.Data.SqlClient Partial Class _Default Inherits...
  4. dougancil

    Database connection string attached to an upload onclick

    I have a simple browse and upload web page that users can upload a .csv file to a server and then a bulk insert is ran after the user clicks the "upload" button. Here is my default.aspx code: @ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>...
  5. dougancil

    SQL Server Bulk Insert

    I have the following SQL Bulk Insert query: BULK INSERT [dialerresults] FROM [C:\IVR Test\csvtest.txt] WITH (FIELDTERMINATOR = ',' ROWTERMINATOR = '/n') and here is the sample data: 1,512 206 1293,rob stevens,doctor alexander,1 5 10,12:30, null 2,512 555 1212,jason reed,doctor smith,5 5...
  6. dougancil

    Multiple checkbox validation using javascript

    I am trying to write a page that requires a Pass/Fail for conditions that are done everyday and then posting them to a database. The problem I'm having is the validation of the checkboxes. Find the code below: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"...
  7. dougancil

    Stored procedure

    Everyone, I'm trying to run a stored procedure to give me more than a single result using the following line: SELECT TOP 1 @FirstListing = FirstListing, @Comment = Comment, @oc_start = oc_start, @oc_end = oc_end Granted there is much more to the stored procedure than this but this is a snip...

Part and Inventory Search

Back
Top