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

    Good T SQL stored procedure tutorial?

    Hi All, Overview: I am trying to automate remote admin on a db. I have a dev db where tables are added/altered etc. I need to sync the structures. So I create a text file with the templated structure and load that to a table. I then want to run a sql query to load another table with the current...
  2. bastienk

    Listing of table details

    Hi All, Is there an sp I can query to display / return the schema of an db? Bastien Cat, the other other white meat
  3. bastienk

    Need to run ASP thru IE with TaskScheduler

    Hi All Stuck here, have an asp file that needs to be run. Can't use VBS due to security concerns. How can I use TS to open IE and run a particular file? Well, I can figure out how to open IE, but how do i give a path to the file? Bastien Cat, the other other white meat
  4. bastienk

    Change column name

    is it possible? i am trying ALTER tester CHANGE COLUMN 'Blah' 'blah' Hints will be appreciated TIA Bastien Cat, the other other white meat
  5. bastienk

    nested functions ?

    Hi All trying to capture a portion of a cell where i need to split that cells data based on a comma tried using: =TRIM(LEFT(Z1729,SEARCH(Z1729,",")))3 and =TRIM(MID(Z1729,0,SEARCH(Z1729,","))) but it doesn't work... Any hints would be appreciated... TIA Bastien Cat, the other other...
  6. bastienk

    Damn CDONTS problem --> server error 500

    set myMail = Server.CreateObject("CDONTS.NewMail") with myMail .To = "me@hotmail.com" 'email 'other emails? .CC = "you@domain.com" .From = "DB Monitor" .Subject = "Notification of Database problem" strBody = myServer & " is having...
  7. bastienk

    Having some fun with ASP and XML

    I have the need to read the below XML file produced by a component that we use... <Report xmlns="urn:schemas-microsoft-com:xml-data" xmlns:dt="urn:schemas-microsoft-com:datatypes" UserID="{0}" ID="{1F461501-4D6F-432D-BBD0-CACD541DD1B6}" Type="Call" Status="Completed"> <SubReport...
  8. bastienk

    index listing question

    We have multiple DBs and need to replicate the index structure across the various instances. Is there a quick way to generate a list of all the indexes on a DB? For info: we have both MySQL CC and PhpMyAdmin as guis to the DB... TAI Bastien Cat, the other other white meat
  9. bastienk

    multi column index question

    Hi All, I have a table that uses 3 inner/outer joins to create some reports. I have been tasked to speed this up due to load on the system as the original query takes about 4 minutes to run. Will a mutli column index based on the columns in the where clause speed things up? Or should I look at...
  10. bastienk

    Configuring TAPI on win XP / Rockwell modem

    HI All, Hope this is the right forum for this. We are evaluating a TAPI component from Mint Components. The deafult install includes MS TTS (text to speech) APIs. We are having trouble configging the Rockwell (5699B) modem to work with the speech portion of the component. The component...
  11. bastienk

    sleep compliation problem

    Hi All, I am trying to create a sleep fucntion for an ASP app to use. Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) Sleep (5000) End Sub When I try to compile this into a .dll I get a compile error "Invalid outside procedure" How can I fix this? TIA Bastien...
  12. bastienk

    image from Db problems

    Hi All, Kinda stuck here. I am trying to pull an image out of the db and resize it, then stick it back into the db. (Its a bastard solution to an ASP app problem that I have to deal with. This is the only way to do it for now). Anyway, the code below is to take the image out, and does work...
  13. bastienk

    more image probs

    Trying to get an image out the db and into a file...is not saving/writing to the file...file is being created but not passed to the file...getting a Undefined variable: img in the page where $img is the db query result... $results = mysql_query($sql) or die ("Can't connect to DB because...
  14. bastienk

    image problem

    I have to take an image out of a mysql db (yeah, i know "don't!" but no choice as the app is mainly written in ASP and I am doing some post insertion processeing in php... Basically I need to extract the image from the DB, thumbnail it, and stick it back in...I am testing the extraction part...
  15. bastienk

    CreateRange in Excel with vbs/asp

    How do i create the range for a certain area in the excel spreadsheet? I can get the width and height of the range with intCols = xlsheet.UsedRange.Columns.Count lngNumRows = xlsheet.UsedRange.Rows.Count I am just unsure as to how to syntactically create the statement needed. TIA...
  16. bastienk

    ASP and excel help needed

    Hi All, I have a web app that calls an excel spreadsheet for manipulation. During testing I can apparently open th excel app and there my program hangs. I noticed that I have excel processes not terminated on the server. I would like to see if there is a way that I can loop thru the opened...
  17. bastienk

    enabling trans_sid

    I am working on a site where sessions are doing weird things - like dropping between pages. I want to see if, by enabling trans_sid, I can propogate the session id in the url and keep the sessions alive.... Having trouble getting the ini_set statement to work... //index.php...
  18. bastienk

    session dropping issues

    Hi All i am having some problems keeping my session vars alive. i have a user log-in form which sets a session before redirecting the user to another page. In this page I check for the existence of that session var and it seems to be loosing the session as it directs users back to the log in...
  19. bastienk

    mysql / php time issue

    Hi All I am using a mysql datetime field which I fill with : $last_accessed = date("Y-m-d H:m:s"); thru a sql statement. When the users are trying to view results using an order by on this field, the results are sometimes skewed where the most recent (and therefore first) record is not at...
  20. bastienk

    reg ex help please

    I have the following requirement and am not sure if the regex I have is correct: if (eregi("^[A-z0-9\.\?\s]$",$_POST['ad_text'])){ where the input string can be alphanumeric and include the period, question mark and spaces. Is the above correct? TIA

Part and Inventory Search

Back
Top