- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 2
- Posts with Upvotes
- 2
- Upvoting Members
- 2
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
36 Posted Topics
 | Re: anti proxy Here's one, although the latest version is not yet available [url]http://whitefyre.com/poxy/[/url] |
| | If you wanted to use php functions to do the validation (say against database entries and such), then you might want to consider using an ajax library such as xajax, and make it look spiffy using something like scriptaculous (ok, maybe I'm going overboard, but it can be very slick). … |
| | Maybe use something in javascript along the lines of: [code] function validateImage(url){ var img = new Image(); img.src = url; return img.height>0; } [/code] which should return true if the image exists (i.e. height is greater than 0). This [I]might[/I] fail if the image takes time to load, so test … |
| | Re: PHP or ASP Slightly OT, one thing you might consider is that search engines don't tend to carry results like [URL="http://www.mystore.com/products.php?category=5&id=6"]http://www.example.com/products.php?category=5&id=6[/URL]. Instead, you might want to use something like mod_rewrite (if you use Apache) and have your links point to [URL="http://www.mystore.com/products/5/6"]http://www.example.com/products/5/6[/URL] instead, and have mod_rewrite re-write it to the original URL. That's a …  |
| | try: SELECT username, SUM(daily_units+rare_units) FROM table GROUP BY username ORDER BY SUM(daily_units+rare_units) desc the sum function works by summing rows, not separate fields (i.e. it takes a single argument, an expression to be summed over rows). That expression in your case is a sum itself, but it could be anything … |
| | |
| | How about something like: [code] select count(*) from students where total_raised > (select total_raised from students where uid=$uid) [/code] This should tell you how many students have total_raised greater than the student you're looking at on your individual page... which should be equal to the ranking. It should also handles … |
 | Just build each link like: <a href='editform.php?id=53'>John Doe</a> |
| | [quote=simpleton;300559]We are considering upgrading SQL 2000 to SQL 2005. I just love the idea of getting newer technology, But i'm hesitant to upgrade MS stuff, cause of bugs and licensing stuff... So here's what i'm wondering: 1. If we move to 2005, will we lose any databases/querys/dts packages/etc ?? or … |
 | Re: Data Replication I'm not too familiar with SQL Server's replication feature. For your import/export however, what error messages did you get while trying to move data from dbaseB to dbaseC? If it's the same schema, I'm not too sure why you wouldn't be getting the data. If there's referential integrity defined on … |
| | I think you're better off avoiding cursors where possible! It's much slower than a straight up statement, such as: [code] select name, substring(name,1,charindex(' ', actor_name)-1) FirstName, substring(name,charindex(' ', actor_name)+1,len(actor_name)) LastName from actors [/code] to do an update, you could do: [code] update actors set first_name = substring(name,1,charindex(' ', actor_name)-1), last_name … |
| | Valid theoretical question (I think it will error with overflow), but do you practically think you'll get there? bigint can go up to 9,223,372,036,854,775,807 That's pretty big... Just to try and put that into perspective, it would take ~292 years to break the bigint limit if you were to insert … |
| | have a look at the sp_executesql (or is it sp_execute -- can't remember). with this method, you build your string in SQL, then execute it with the SP above. BOL should have more info and examples |
| | [quote=Qmoto;285747]I'm getting the error [inlinecode]Incorrect syntax near '='.[/inlinecode] when I use the following case statement in a view. Obviously I'm not an expert on MS SQL, but I'm curious as to why I am allowed to use the '=' sign in a preceeding statement but not in the THEN section. … |
| | Smarty ([url]http://smarty.php.net[/url]) is a pretty good templating system that you can use as part of a flat file db system. You'll still need to store the editable data somewhere -- flat file or db -- and provide an edit style interface though. You'll somehow have to impose structure to it … |
| | see DBCC CHECKTABLE in BOL for more info... be careful about the repair, as it could invalidate.. but it should fix the table even if some of the data might be lost. Good luck! |
| | My approach would be something like the following, assuming the second data structure. (It's untested) select top 3 d1.num num1, d2.num num2 from data d1 inner join data d2 on (d1.date=d2.date) and (d1.num<d2.num) group by d1.num, d2.num having count(distinct d1.date)>1 order by count(*) |
| | Re: Php & Xhtml [quote=greywolf;282302]Thanks for you advice, I tried to force the server to parse the php by adding the <Files directive, but it breaks the XForm - I got just back from browser just name of the labels. I have tried various headers, but did not found the right one, none worked. …  |
| | [quote=went1180;280888]The PHP book i have been using lauds object-oriented php, yet provides poor details on how far the code it presents is supported in version 4. my server runs 4 and i have been having trouble trying out some code from the book on it. I simply don't know whether … |
| | What database software are you using? Some have full text search capabilities which are quite neat. You could search for "styles" or "styling", and it would match "Style", because they're related. Some even do "good", "better", "best" relations. Depends on your db software... There might also be a php module … |
| | Well, the bad way would be to do something like: select case color when 0 then 'black' when 1 then 'white' when 2 then 'red' when 4 then 'blue' end as color from myTable ideally, you would create a table with 2 columns, one an id {0,1,2,3} and another with … |
| | [quote=saurabh_kanwar;276357]Hi guys, I've got a database which frequently need to be sent over the internet so that other users can update their data. As the database is huge with more than 30,000 records, it's really hard for other people to download it as they are on dial up. Is there … |
| | [quote=cancer10;275328]How come MS SQl Server 2000 does not have an autonumber datatype as like MS Access does? Any alternative?[/quote] This belongs in the MSSQL forum, but the corresponding datatype is the more powerful identity data type. I don't think it supports 'random' like access, but you can start from any … |
| | [quote=logitech14;277645]Hello there, I need a help. I have a computer that has windows 2003 server installed and I have 9 clients in domain control that use SQL Active Directory, an aplications in Visual Basic. The problem is that whenever they try to use it is soooooooooooo slow and if I … |
| | I don't have my sql server readily available, but you could use the "create trigger" command, then use the logical tables "inserted" and "deleted" (which represent what is and what was, respectively) to determine if processed=false in deleted and processed=true in inserted (be sure to handle the case where you … |
| | If the user running the query has rights to select the table in the other database, you will be able to. the syntax is something like: [code]select * from tableA join otherDB.dbowner.tableB on tableA.x=tableB.y[/code] where otherDB = the other database (if it contains a space, enclose it in square brackets … |
| | [quote=digital-ether;271519] When I first thought of this problem, I thought it would be simple to add a new rating. It would be just one database entry for each Item being rated, and then each time there is a new rating, you just get the old average, and sum it with …  |
| | check out php's array_values function, which will essentially reindex the arrays |
| | Using Microsoft Fiddler (great program for some debugging and such!), I can see that your server is indeed doing what Puckdropper said .. no content type in the header. Your server's return headers: [code] HTTP/1.1 200 OK Server: Netscape-Enterprise/3.6 SP1 Date: Thu, 19 Oct 2006 03:25:29 GMT Connection: close [/code] … |
| | How are you moving the data? Through SQL statements? Through the EM Import Wizard? Anyhow, the answer is enabling "identity insert" in your target table B. This option can only be active for one table at any given moment, and is usually turned on, data copied, then turned off again. … |
| | ...or in php use setcookie ([URL]http://ca3.php.net/manual/en/function.setcookie.php[/URL]) I'm assuming you're looking for the PHP code =) |
| | Well, what would you like to do when the feed is not available? I'm assuming that there is something else that the page will display... You're on the right track, basically (without knowing more about your code), something like: [php] if ($fp = fopen($file, "r")) { //do whatever you want …  |
| | Re: Breaking strings First Issue: You can use: list($month,$day,$year)=preg_split("/[,\s]/",$date); // (untested!) or you can use the strtotime() function, which will convert it to a php datetime, and then do whatever you need to (maybe using date() to reformat or whatever) Second Issue: MySQL has a datetime format, which is probably the best to …  |
 | I think the standard way is to check the file extension, or to check the mime type. Of course, none of this guarantees that the uploaded file is a valid "audio" file. (What is an audio file for you? MP3, WAV, OGG, etc..????). Depending on your app, this may allow … |
| | [quote=Mych;258636]I have a form which for debugging I'm submitting as 'get' so that I can see the values of the inputs being passed. the url pass is AddMValidate.php?prodno=1682&isnew=on&special=on&title=Special&Mselect=SAM&FCKeditor1=dkja+sdfjasfd+adj+ashfkjdhaskj+fdh&submit=Submit In my AddValidate.php page I have the following [php] #Validate that Machine Type has been selected $Mselect = $_REQUEST["Mselect"]; if ($Mselect =="SAM") … |
| | Re: Download A file Actually, if you have [php] <?php header('Content-type: application/msword'); header('Content-Disposition: attachment; filename="file.doc"'); readfile('file.doc'); ?> [/php] then it will force the browser to save the file with the appropriate name. You can replace content-type with whatever mime type is appropriate You can view mimetypes by searching the net, or referencing the following: … |
The End.