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

    ERROR: invalid byte sequence for encoding "UTF8": 0xe3a520 ' .. help?

    Using PHP 5.2 and PostgreSQL database server 8.1 I run the following query from a php script: insert into pager (PAG_ID,PAG_PARENT,PAG_NAME,PAG_ACTIVE) values(3000,0,'Aå cool site',1) Note the values has been entered in a UTF8 encoded HTML page and get this in return: ERROR: invalid byte...
  2. Tore

    Is there a md5 equivalent function in VBA

    I want to do a one way encryption on a string in VBA? How do I do that? Any suggestions to a function that do an md5 on a string etc..
  3. Tore

    How to prevent clients from linking to a back-end db?

    Hi. client - server - access - security Access 2000 The client computers in a local network have have access 2000 installed on their computers. I want to install an .MDE file on each client from where they can access data from an .mdb file on a server. The .MDE file are linked to the tables...
  4. Tore

    Uploading files Need some advise reg. $ENV{'CONTENT_LENGTH'}

    Hi.. I'm new to Perl. But it look like some magic can be done using perl compared to PHP when uploading files. I looked at the FAQ regarding uploading of files using CGI.pm module. In the example from the FAQ there was only one text field to enter the file to be uploaded. I added one text...
  5. Tore

    Need to search text for "code-*" and return all occurences of words

    Hi. I need to search some submitted text for "code-*" and return all unique occurences of whole words. Where the * part of the word can be any number and/or alphabetic letter and/or "-" and/or "_" Examples of valid words could be: Note: there can be multiple instances of the same word...
  6. Tore

    Is it possible to control link color in a DIV's inline style?

    I want to control link color in a DIV. Inline style in the DIV and not using class. And not by using inline style in each A tag either. Hopefully something like this: Obviously linkcolor does not work, but is there a way to implement it like the example below? <div style="linkcolor:#aaaaaa;">...
  7. Tore

    How do I group text layers as to change font for all in one go

    Hi. I want to be able to group several text layers toghether so I can adjust font, font-size, color etc for all text(s) at the same time. I do not want to merge down to one layer because I probably have to change text (letters) for some of the individual texts laiter. It would be nice to...
  8. Tore

    Have trouble with subqueries, help. ???

    I tried the subquery below. When I use explain it says that it uses the primary index on table1 byt by some reason it still does a full tablescan on that table. SELECT id1, id2 FROM table1 WHERE ( id1, id2 ) IN ( SELECT id1, id2 FROM table2 WHERE min >=20 AND min <=20 ) table1 primary: id1...
  9. Tore

    How do I InnoDB multiple tablespaces, on multiple disks?

    Hi. I want to use multiple tablespaces with InnoDB tables. And I also want to spread my InnoDB tables on two separate disks. I also want to control which disk each of the InnoDB tables are placed. Is this possible? How do I do it? Example config please
  10. Tore

    Performance when MANY tables in InnoDB database???

    Hi. InnoDB tables only. Today I have all my customers in 4 tables. All of my customers today can update, insert, delete records any time in these tables. Each of my customers have many visitors.... This makes use of query-cache inefficient. I'm considering putting each of my customers in...
  11. Tore

    Which is the most effective structure for tables/indexes????

    Hi. Have one table with FIXED row length. Table name: &quot;thetable&quot;. Field 1: MemID (mediumint). (relates to another table members) Field 2: TheID (smallint). Primary key: MemID, TheID. Lots of fields. Fixed table length. I want to make it possible for users to search for records...
  12. Tore

    Can I add Alias and Directory directives without restarting Apache

    Hi. Have installed Apache 1.3. Have a dynamic site where users can become members (either trial or full member) by paying online. After I receive the payment IPN-notification from PayPal I create some stuff automatically in my MySql database using PHP4. Have now tried to figure out how Apache...
  13. Tore

    Tool for exporting mySQL table structure to SQL statements

    Is there a tool out there I can use to generate all my Tables, fields and indexes to SQL statements that I can use to generate the mySQL database that I want to use at my host. The generation of SQL statements must work on windows98. One more: Can someone recommend me a tool to administer my...
  14. Tore

    PHP, mySQL.... MyISAM tables / InnoDB tables table/row locks

    PHP and mySQL on Linux. My host does not support the InnoDB table type. So I gues that I should use the MyISAM table type.. But in some pages I have to create and/or update from 2 to 4 tables. How do I make those row creations and updates as stable as possible. How to program so the risk of...
  15. Tore

    How to protect PHP, database on web and connection

    Hi. I'm about to launch a site on the www. Have wrote the intire site using ASP, VBScript and MAccessDB. Have decided to revrite into PHP-pages and use a mySQL database because of better speed and stability. I will have a lot of customers. And I would like to secure my code against hackers and...
  16. Tore

    HELP! Password &amp; Userid when client connects through my ASP-pages

    Hi. I'm new to mySql. Are about to launch a site i a month or so. I'm looking for a good and secure way to let my customers access the mySql database through my ASP-pages. They will have to be able to Select, Insert, Update and Delete records in the database through my ASP-pages. Have read...
  17. Tore

    Photoshop, 8 bit/ 16 bit pr. channel

    Are to submit images to an imagebureau. They want images scanned in highest possible bit depth. For me this mean scanning in 16 bit/channel. So far so good. When I want to do adjustments to the scanned image I cannot add a new adjustment layer. I have to convert to 8 bit/channel to be able to...

Part and Inventory Search

Back
Top