Tag Archives: Sql Server

Web Discussion and Subscription

Relating to been working using Front Page 2002 plus redoing our businesses intranet site. We are supposed to get working web discussions and subscription. Etc the server WE put office server extensions on and was likely to configure them with all the web discussion databases (SQL Server 2000) plus subsciption stuff. Well I continue getting this same error after typing from the information about the internet discussion database. I cannot determine what I here’s doing wrong. So Relating to made a online discussion with Top Page 2002. I seems to be effective ok but the boss also would like the subsciption products on there in addition to Front Page doesn’t appear to support that, a minimum of I haven’t located any documentation upon it. If anyone is aware why my configuration from the discussion database failed please ok , i’ll know what can be wrong. Otherwise does any one know if you can find subsciption stuff using Front Page 2002 If all else isn’t able does anyone have some other ideas on what possible get for an internet discussion and subsciption Thanks Define " subscription"… Virtually any microsoft discussion program should tie towards ActiveDirectory, which is since good or much … Continue reading

Posted in Web Design | Tagged , , , , , , , , , , , , , , , , , , , | Leave a comment

More Database connection questions

I decided to try and give the databse/website job another go this morning and now have had some partial success. When I ran over the latest error I investigated it and them dawned on me which the Webserver has’nt had the ODBC link put togewther, so I promptly stress to do it, however whilst setting up this up this SQL server wouldn’t show in this drop down checklist. My question can be, with the webserver guiding the DMZ, just how do i allow the Webserver to get access to our SQL node All the best, Mitch…

Posted in Web Design | Tagged , , , , , , | Leave a comment

External link from Database ?

Hi there all, my website is definitely progressing and i have got data at display pulled in from a SQL server DB. What I’d like to do now is contain the links to other sites which are displayed in a table around the left of the particular page pulled in from your database also. Displaying the link (say internet. imdb. com) is no problem but learn how to get the connect to work I include created a table when using the fields ID Type (numerical to seperate state film links out of humour links) Link (The text they’re going to see, say for IMDB it’ll say ‘Movie Database’) URL (This could be the actual code.. which may be < A HREF=" http: //www. imdb. com" > < FONT size=" 1" face=" Verdana, Arial, Helvetica, sans-serif" > Video database< /font> < /A> < BR> can the URL arena tie in because the code for your page Thanks in advance, Mitch….

Posted in Web Design | Tagged , , , , , , , , , , , , , | Leave a comment

DWMX Checkboxes

Hi all, having problems getting some checkboxes to be able to display values from your sql server DB. I have 3 checkboxes on a form, and the best record has two analysts checked and the center one empty so Chk1 = 1 chk2 = 0 chk3 = A SINGLE but all of them display unchecked after i test the asp track. The particular checkbox properties are usually as below. chk1 checked out value = checkbox Dynamic – check if: < %= (rstConcept. Fields. Item(" chk1" ). Value) %> Equal to: 1 chk2 checked out value = checkbox Dynamic – check if: < %= (rstConcept. Fields. Item(" chk2" ). Value) %> Equal to: 1 chk3 checked out value = checkbox Dynamic – check if: < %= (rstConcept. Fields. Item(" chk3" ). Value) %> Equal to: 1.

Posted in Web Design | Tagged , , , , | Leave a comment

intranet how?

Hello, I’m working for just a company and they want to gain me to style and design an intranet. I’m quite capable at creating sites and am eager to discover ways to create ‘dynamic’ internet websites. What software would certainly I use I use dreamweaver in your own home, could I that and read ” up ” about asp. net to build database functionality to build a people seek out employees etc… We use a windows server that isn’t going to support PHP or MySQL i do believe. Every suggestions Visual Studio may be the tool of option for ASP. WEB. I don’t like the code that you receive, so I’d try to avoid the visual facet of things, but aside from that it’s a terrific tool. I guess you can actually really use anything at all though, it’s just a matter of figuring out how to placed it up. Consequently yeah, you should use Dreamweaver. It just can make more sense make use of the tool that’s made for a specific task/language, i. e. Visual Business. I know you know this kind of, but I’ll state: the software does not matter, it’s the end result. There’s not one little … Continue reading

Posted in Web Design | Tagged , , , , , , , , , , , , , , , , | Leave a comment

How do I set up a search for of database searching for 2 words in different orders

When will i search a database one example is, if someone applies in " shed foot", it would go back any instance belonging to the word foot considering the word loose. When they search loose feet, and foot loose is the database, may well show up within the search. Exactly where Field like ”%foot%’ and Field Like ‘%loose%’ The exact formatting within your where clause would depend your database, but this provides you with the general concept. You’d have to split your query having a server-side programming dialect, or in possible of SQL Server the easily available Split function, however it will work. I am just using php & MySQL I wouldn’t really be capable of help you rather than in concept, and then. You’d have to look for a PHP split function most likely and then file format your query keeping that in mind for MySQL. Ideally you’d use like a Lucene index for this kind of thing. However as TheGAME1264 suggests you possibly can perform searches similar to this with MySQL. Though this will have to match every word Something like this would work: (Not completely tested) Just put in a query stringed like s=this+is+a+test towards the page … Continue reading

Posted in Web Design | Tagged , , , , , , , , , , , , , , , , , | Leave a comment