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

    MySQL IN() Clause with Sub Select

    I have a Table with the follwing, +----+------+-----------+ | id | type | vendor | +----+------+-----------+ | 1 | ppc | google | | 2 | ppc | quigo | | 3 | ppc | quigo-aol | | 4 | ppc | pulse360 | | 5 | ppc | yahoo | | 6 | ppc | msn | +----+------+-----------+...
  2. Korizon67

    Pound (#) sign in SQL

    I have a query i use in access that looks like this, DateAdd("s",dbo.scheduling_timerange.begintime/1000,#1/1/1970#) when i use it in MSSQL it throws and error at the # what i am attempting to do is convert a bigint to a date time in MS ACCESS i run the query on 1210164900000 and i get...
  3. Korizon67

    Nesting queries inside a "While Loop" (only returns 1 result)

    I have a query I am attempting that allows a manager to hover on an icon and see who the last assigned user to a patient was, I am nesting a loop inside a loop, it works but only on the first result... I have done this in the past and had it work fine but cant seem to see my mistake here. the...
  4. Korizon67

    Php/Mysql array for google charts

    Hi all, i am trying to make an array that looks like this ... 40,55,40,55,56,122,652,37 i can create 40,55,40,55,56,122,652,37, with an echo. I have always echoed for html, now i need to store the 40,55,40,55,56,122,652,37, then i was going to use sub_str() to remove the last comma. the...
  5. Korizon67

    MySql Stored Procedures DB to DB Question

    Hello, I am trying to come up with a way in Mysql to use a stored procedure to connect to our web database and update table in our internal database. I have php script that does it now once a day What i would like to accomplish is sweeping our WEB DB every Five minutes to grab new leads. Is...
  6. Korizon67

    Problem with sin() math function

    I am not very fluent in VB, I have the following macro for drawing points in the cam program I use to program wire EDMs Sub cdb() 'Macro Recorder 8/31/2007 by Mike On Error Resume Next 'Declare the variables Dim App As Esprit.Application Dim doc As Esprit.Document Dim...
  7. Korizon67

    Question on .htpasswd and Intranet/Internet security

    What I was wondering was, Is there a way to use the .htpasswd and not effect internal connection? I want to make some of our Intranet available so folks can work from home. I already use php with a login system, but I was hoping for a little extra security when coming from the outside by adding...
  8. Korizon67

    Question about a nested select query using RIGHT and REPLACE

    I have a database that grabs input from a website. The form on the website has poor validation so I get various types of entries for phone number. some of these formats.. 1 (222) 333-4444, 12223334444 1.222.333.4444 1/222/333/4444 .. you know... That Ol' chestnut!! I have even seen...
  9. Korizon67

    Drop Table IF EXISTS in MS access

    I have seen many ways to do this, but am not fluent in functions, can someone step me thru how to do this? I want to check and see if the Table leads and leads_ImportErrors exists and if so drop them Thank you for any help Mike
  10. Korizon67

    backslash stripped quotations

    I have a CSV file that has always worked but recently the file we were getting was changed to have " " around the text fields, Now its also adding \"data|\" in some places... access is ignoring anything after the first "\. I cant seem to find anything in access to get around this, Any ideas...
  11. Korizon67

    Combe multiple php files into one?

    Is there a way to combine multiple php files into one file and then call the functions from a main page? I have some menus embedded in a layered form, As it is I have a menu_layer1.php.. menu_layer2_.php and so on... I was sure there was a way to call the file something like include...
  12. Korizon67

    Qforms

    Has anyone used Qforms at all? its a very nice form app that will allow posting multiple layered forms, but I am a java newb and was wondering if anyone has dealt with it. regards mike

Part and Inventory Search

Back
Top