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

    Error 'ASP 0115', Trappable error (C0000005) occurred in an external object

    Hi all I've got quite a heavy traffic classic ASP site (I know it needs converting to .Net at some point) which runs fine 90% of the time but occasionally I get an error 'ASP 0115' Unexpected Error. A trappable error (C0000005) occurred in an external object. The script cannot continue running...
  2. sugarflux

    Could not allocate space for object [INDEX]

    Hi all Hoping someone may be able to help me out as I'm stumped with this one... I have a 'hosted' MS SQL Server (meaning I can't access the DB directly in Management Studio, I use RazorSQL and/or MyLittleAdmin). There is a size restriction on the DB of 2GB - currently my DB stands at 1500 MB...
  3. sugarflux

    Help! Importing large number from csv file...

    Hello all. Hoping someone may be able to help me with this one... I've had an ASP/VBScript import routine setup for a long time which [enormously simplified] collects a csv file from a server and imports the contents into an Access table. There are usually approx 14 columns and around 640k...
  4. sugarflux

    Any RegEx experts out there?

    Hi First off apologies if this question is in the wrong place... There is no dedicated RegEx forum and since I'm working in JS and in my experience RegEx is most commonly used in JS - here lies my problem :) I have a number of search strings that I would like to split into an array. The search...
  5. sugarflux

    Help Writing a complicated query

    I've been wrestling with this for quite some time now and decided it was time to ask for some help!! I'm basically trying to get a list of Users who have joined a specified group within the last 7 days (Imports). Whilst this sounds easy, my data is not laid out easily for this purpose...
  6. sugarflux

    Insert into SQL Server Database from ADO Access connection

    Hi So first off I wasn't quite sure whether I should post this in Access, SQL Server, ASP or another forum! I hope this is the right place... I'm trying to do an automated daily import of around 640k records (originally in a csv file) into a SQL Server Database. Unfortunately the SQL DB is...
  7. sugarflux

    Download a file with a redirect using VBScript

    Hi Guys Hoping someone may be able to help me. I'm trying to write a script to automatically download a file once a day from a site. It's a zipped csv file, usually around 6mb. The site is slow! When i first hit the URL from my script a 303 response is returned which seems to be redirecting to...
  8. sugarflux

    Class with Array of object - assigning methods to the array?

    Hi All I'm a brand spanking noobie to PHP but here's what I'm up to... I have a class that contains an array of instances of another class and I'm wondering whether it's possible to convert this array into a further class that contains methods. Example: Class Topping{ private $sID...
  9. sugarflux

    Owner -Drawn Controls - Complete n00b

    Hi all Hoping someone can help me - I'm totally new to c# so need it spelt out really clearly if possible please! I want to change the look of various controls, for example, radio buttons. I've experimented with putting a background image within the associated label but have read about...
  10. sugarflux

    Add onclick to radiobutton within a repeater

    Hi Guys I've been struggling with this for days! I have a radiobutton, label and a panel within a repeater and I'd simply like to add a javascript onclick to the radiobutton. <rendering:RepeatTable ID="QuestionValues" runat="server" CssClass="myControl"> <asp:RadioButton...
  11. sugarflux

    Max of a sub-query within another sub-query

    Hi All This should be easy enough for a pro sql guru.. Normally i could rise to the challenge but i seem to be stuck with this one. I have Three tables which i've greatly simplified below: Customers CustID | CustName | Group | 1 | Mr Brown | G1 | 2 | Mr Black | G2 | 3 |...
  12. sugarflux

    FILLIN or ASK Fields with carriage return

    Hi guys Can anyone help me with this one? We have FILLIN and ASK Word Field Codes in documents and want to add a line feed or character return into the prompt Does anyone know anyway of doing this please? (Even if the workaround is long winded!!) Thanks sugarflux
  13. sugarflux

    Get hwnd of Controls on a form

    Hi guys I need to get the handle of controls on one of my forms. I'm returning the form hWnd with the FindWindow function and i've attempted using the enumchildwindows procedure to no avail. I'm sure this must be an easy thing to accomplish using an api call - but which one !? As i'm working...
  14. sugarflux

    Connecting to MSAccess DB from ASP (DSN-less)

    Hi all Been programming with VB for years but fairly new to ASP. I have created a MSAccess database in the root of my webspace (lets call it DB1.mdb) and a table called P with fields PID, PForename, PSurname. I've created the following as QueryDB.html: <html> <body> <%...
  15. sugarflux

    Connecting to Access DB via ASP (DSN-Less)

    Hi all Been programming with VB for years but fairly new to ASP. I have created a MSAccess database in the root of my webspace (lets call it DB1.mdb) and a table called P with fields PID, PForename, PSurname. I've created the following as QueryDB.html: <html> <body> <%...
  16. sugarflux

    Read Remote Folder from IP Address

    Hi Guys Another tricky one i'm afraid! Hopefully someone can help? I have a textbox and an 'Open Folder' button on a form. When user clicks the button i call the BrowseForFolder dialog (as found here: http://www.developerfusion.co.uk/show/2127/). User selects a local folder and clicks OK and...
  17. sugarflux

    Turn Excels 'New Database Query' into VBA

    Hi Guys Having some problems with connecting to an oracle database with VBA. Can run queries against the database using Excels 'New Database Query' without a problem. Can also simulate this in VBA with the following: With ActiveSheet.QueryTables.Add(Connection:= _...
  18. sugarflux

    Excel / MSQuery / VBScript Crashes when connecting to data source

    Please help!!!!! Any advice or suggestions at all gratefully welcomed! I'm attempting to connect to an oracle database using Excel (New Database Query - have also tried vbscript, vba, msquery) and it crashes when i try to connect to the data source. I get the Window: Program Error MSQRY32.exe...
  19. sugarflux

    Think .dll may be corrupt. Any ideas?

    Hi guys Complete n00b to oracle i'm afraid. I don't even know if this is the right place to post this query so any advice (even to post elsewhere) appreciated. We have an oracle database which i'm trying to connect to from Excel / MSQuery / Access / VB - pretty much anything really using...
  20. sugarflux

    Running a VBA form as a seperate process from Excel or workaround

    Hi guys Long shot but hoping there might be an API genius out there somewhere or an imaginative vba-er with a workaround! I'm writing an app in vba (Excel 2000) running purely off of userforms (i.e. no excel functionality whatsoever). Would have written it in VB but don't have access to this...

Part and Inventory Search

Back
Top