516 Posted Topics
 | Your best bet is probably log shipping, where you restore the full database to the other server once, then at the interval you specify, the transaction log is backed up and restored to the other db. You'll need to be in full or bulk-logged recovery model for this. You'll also …  |
| | That's an Access database. This is the MS SQL Server forum. Repost in the Access forum: [url]http://www.daniweb.com/forums/forum128.html[/url] |
| | Open SQL Server Management Studio and right click the instance (probably "ServerName\SQLExpress"). Select properties. Select Connections. Verify that enable remote connections is checked. Open SQL Server Configuration Manager. On the left, click SQL Server Network Configuration -> Protocols for SQLEXPRESS. Enable TCP/IP and Named Pipes. Post back if you still … |
| | Re: Looping query Use a table variable and loop through it like an array: [code] DECLARE @ItemName VARCHAR(10) DECLARE @Address VARCHAR(100) DECLARE @Items TABLE (ItemName VARCHAR(10), Address VARCHAR(100)) INSERT @Items SELECT '95B046047' , '8 MALLORY GDNS' UNION ALL SELECT '95B045912' , '1157 OCONNOR DR' UNION ALL SELECT '95B045902' , '28 SENTINEL RD' UNION … |
 | This should be fine. You will require a little more disk space. Ability to audit is more important than disk space though. As long as you don't rewrite your application to query this column regularly, you probably won't notice a difference in performance. If you do, modify your indexes to … |
| | |
| | You are storing duplicate information. Both tables contain Date, TeamId, and MemberId. You need a table for member, team, and a teammemberlink table. |
| | Access based forms only work on the desktop. You need to make a web based form with a web development language (asp.net, asp, coldfusion, php, jsp, ror,...) |
| | Replace DateColumn with your actual date column [code] SELECT CAST(DateColumn AS DATE) AS DateOnly [/code] Also, if you are interested in formatting the date, there are many ways to do this. [URL="http://anubhavg.wordpress.com/2009/06/11/how-to-format-datetime-date-in-sql-server-2005/"]http://anubhavg.wordpress.com/2009/06/11/how-to-format-datetime-date-in-sql-server-2005/[/URL] |
| | Have you looked into merge replication? This is exactly what merge replication is designed for. |
 | Replace ColumnName and TableName with your column and table name: [code]SELECT SUBSTRING(HashBytes('MD5', ColumnName),1,19) [Hashed] FROM TableName[/code] |
| | Backup the db before you try this. You'll also need to add a unique ID column if there's not one already. [code]DELETE FROM MyTable WHERE ID NOT IN ( SELECT MAX(ID) FROM MyTable GROUP BY DuplicateColumn1, DuplicateColumn2, DuplicateColumn3)[/code] [url]http://blog.sqlauthority.com/2007/03/01/sql-server-delete-duplicate-records-rows/[/url] |
| | There are probably around 100 ways to do this. If you are new to SQL Server, the easiest way will probably be the export data task. From the Management Studio, right click on the database of the source table. Hover over "Tasks" and then select "Export Data..." Follow the instructions. … |
| | There are many ways to do this, but here's one way to do it from the Management Studio: Under the server, expand security and expand Logins. Create a new login. Under Server Roles, keep the login as Public. Under User mapping, check the database that you want the user to … |
| | Use an Application Role: [url]http://www.sqlservercentral.com/articles/Security/sqlserversecurityprosandconsofapplicationroles/1116/[/url] |
| | In SQL Server, you have 2 login options: 1.) Windows Authentication: No password allowed. The credentials used when logging in to the machine are pushed forward and verified by either the local machine or the Active Directory (if on a network) and then compared with credentials in the database to … |
| | See my post [URL="http://www.daniweb.com/forums/thread328978.html"]here[/URL]. The login can either be [list]Windows Authentication (network authenticates user)[/list] OR [list]SQL Server Authentication (password in sql server authenticates user)[/list] There is no mixed login. Mixed refers to the fact that SQL Server will authenticate either type of login. In the management studio, run the following … |
| | I've created (and automated) many html email based reports using just T-SQL and Database Mail. I like using For XML PATH to turn a result set into an html formatted table. Try the following: [code] DECLARE @Table TABLE ( Column1 VARCHAR(9) NULL, Column2 VARCHAR(9) NULL ) INSERT @Table SELECT 'Col1Value', … |
| | SQLBulkCopy is only handy when the source and destination schemas match up. It sounds like you are trying to pump varchar or char into an int column. [quote]I have no control over the format of the text file, as it is an export of data from a vendor application.[/quote] I'd … |
| | [URL="http://www.protware.com/"]This[/URL] site claims it can with something called the image gaurdian. Explanation copied from site: "Here comes the Image Guardian - it will split your images into pieces and will generate the appropriate code (which will be then encrypted by HTML Guardian) to display those pieces in your pages as … |
| | Make the exe in Visual Studio. Access is a desktop database platform, not a software developing platform. |
| | So are you saying that you already have an upload script but dont know how to implement? |
| | Use substr to get the first 20 characters of the string: [code=php] $first=substr($content,0,20); print $first; [/code] In this example, $content is the original paragraph, 0 is the starting point of the content to be returned, and 20 is the number of characters to be returned. |
| | Yeah I agree with Naveen. Do your redirect before any echo or print function, <doctype>, or <html> tag. This will also help keep the logic and design separate. |
| | With Linux, this will be very difficult. If your server was running Windows, you could use COM. Refer to this thread:[url]http://www.daniweb.com/forums/thread141038.html[/url] |
 | Absolutely. Try this. [code=html] <form action="whatever.php" method="POST" onsubmit="return confirm('Are you sure you want to submit this data?')"> [/code] Keep in mind, you'll still want to have some server side validation. |
 | What server language will you be using (php, asp, jsp, coldfusion...)? |
| | I'd guess that it would be [url]http://localhost/phpmyadmin[/url] |
| | Here is how to do it with CS3 Dreamweaver. I'm not sure if the wording will be exact for DW8 but it should be close. If you haven't done so in dreamweaver, create a new site. ([B]Site->New Site[/B]). Click [B]Advanced[/B] tab. Under [B]Local Info[/B], give it a [B]name[/B] of [B]localhost[/B] …  |
 | I'm guessing you are coming from a SQL 2000 environment. If you want to write a query, just click the New Query button. You can also analyze the query in the Database Engine Tuning Advisor (Tools->Database Engine Tuning Advisor). |
| | Each browser applies it's own default stylesheet to every page. The link below should point you in the right direction: [url]http://www.search-this.com/2007/03/12/no-margin-for-error/[/url]  |
| | Only center the contents of the body. The center tag should open after the body and close before the body is closed. No clue if this is going to fix your problem but it's invalid as is. Also note that the center tag has been deprecated. |
| | The Vertical Line (Vertical Bar, Pipe) key (|) is the key that looks similar to a colon, but uses two lines instead of two dots. Press (shift)+(\). The easiest way to do this in dreamweaver design mode would be to click common-> table on the insert window. Create a table …  |
| | This is supported in php. I'm not to sure if the keyword super is. Here's a simple example of this: [code=php] class Human { public $thirsty = 'Very thirsty!'; function drink($water) { $this->thirsty = 'Not thirsty!'; } } [/code] |
| | You are referencing your PC's C drive for the javascript and css sources: [icode] <script src="[B]file:///C[/B]|/Documents and Settings/Armand/My Documents/Kami's Webpage/SpryAssets/SpryMenuBar.js" type="text/javascript"></script> <link href="[B]file:///C[/B]|/Documents and Settings/Armand/My Documents/Kami's Webpage/SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" /> <link href="[B]file:///C[/B]|/Documents and Settings/Armand/My Documents/Kami's Webpage/SpryAssets/SpryMenuBarVertical.css" rel="stylesheet" type="text/css" /> [/icode] This will work fine when previewing locally, but once on … |
| | Re: Coldfusion It's unique to your area. Go to job sites like Monster.com or careerbuilder.com. Search different web development languages. Does coldfusion list 100 jobs? Does php? What about .net? If you are strictly learning a language for financial gain or employment security, this is what you should look into. Getting paid … |
| | Windows Server 2003 Standard Edition Service Pack 2 SQL Server 2005 Standard VS 2008 Hi everyone. I'm currently working on the following tutorial: [url]http://www.asp.net/Learn/Security/tutorial-04-cs.aspx[/url], but I get an error adding a SQL Server DB to the App_Data folder. I right click App_Data, click Add New Item, SQL Server Database I … |
 | [QUOTE]thanks for your reply... can i make these type of urls with out httpd.ini file...if so tel me how to do that??????[/QUOTE] You'll probably have to enable mod rewrite by uncommenting a line in the http.conf file located in apache/conf/ folder. You won't be able to mod rewrite without first … |
| | Right now you only have 1 radio group with only 1 possible value. Split them up by renaming from mainloop to mainloopH and mainloopA like below: [code=coldfusion] <td><div class="content_black"><cfinput type="radio" name="mainloopH" value="1" required="yes" message="Please select the right option">#Home_team# </td> <td><div class="content_black"><cfinput type="radio" name="mainloopA" value="0" required="yes" message="Please select the right option">#Away_team# </td> [/code] |
| | Re: CFQUERY So you want to add a static row after the query output? Post some code to give an idea of what you are trying to accomplish. |
| | The lock is written into the query. You'll need to check into the correct syntax for your specific database. |
 | Might as well, after the failure of Vista to win fans over. Maybe this is some surrender tactic with future hopes of a WAMP buyout. Surrender your source code, if you want it to run on Windows. Apache will always dominate the web. We don't need a fancy gui, an … |
 | [url]http://www.sitepoint.com/article/guide-url-rewriting/[/url] |
 | In flash you should have a dynamic text box. It should be assigned a Var name. Let's say the Var name is box. In php, you'll need to assign the output to a variable. I'll assign it to the variable $box. Then just echo it like so: [code=php] echo "&box=$box"; … |
| | [icode]<a href="\inventory.php?id=" . $id . "\"><?php echo $row_rsAllListings['element_1_1']; ?></a>[/icode] Why do you echo [noparse]$row_rsAllListings['element_1_1'][/noparse] but you don't echo [noparse]$id[/noparse]? Check the link href value after the page is loaded. I'm sure you'll spot the problem. |
| | Numeric datatypes will never have leading zeros. You could add a dummy number to the front and just remove with substr when outputting it. [code=php] $new_id1="12"; $new_id2="345"; $zero="0"; $id="1{$zero}{$zero}{$new_id1}{$new_id2}"; settype($id,"float"); echo $id; // outputs 10012345 echo"<br>"; $id = substr($id,1);//remove dummy number echo $id; // outputs 0012345 [/code]  |
| | Well, if the page is .htm and the server is not set up to parse php in .htm files, just use a meta refresh: [code=html] <html> <head> <meta http-equiv="refresh" content="2;url=http://www.yoursite.com/newpage.htm" /> <title>Page has moved</title> </head> [/code] |
| | Why do you need regex for this? Can you not use basic string functions like LEFT, MID, and RIGHT? |
| | You haven't specified an image: [icode]"<img src=/em/tutor/images/". [/icode] only specifies the folder that the image should be located. |
| | Re: Form to Excel [url]http://www.dreamincode.net/forums/showtopic10132.htm[/url] This tutorial is easy to follow and will teach you how to write a tab delimited text file with a xls extension in php. It uses basic php text file functions such as fopen and fwrite. |
The End.