I have a system that works on line without any problems. Problem is i need something in place that blends on line information with offline. i want to do something similar to the following if it is possible.User saves to an offline database using a dsn-less connection When the user goes on the web site, they have the option to upload their database contents.
It then copies the information from the offline version of the database to the online version of the database.Then it deletes the information off the offline version, (to prevent same information being uploaded, probably use sql to do this)The user also has the option to download a zipped copy of the main database so they are up-to-dateIs this possible?
I have a table in my DB called members. In that table, I have 2 tables I will be using "username" and "points"
Now, I also have a table called all_matches. This table contains every match report. Over 25,000 of them. I have a "username" field an "outcome" field an "username1" field and "extra_match" field.
What I need to do, is make a query that takes the username from table "members" and find :
using the "username" field in the members table, i need to obtain stats that give me the following. Code:
I need to basically transfer an existing site to my personal pc, when i copy everything to my wwwroot folder then preview it, I get errors such as:
-- Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified -- Microsoft VBScript runtime (0x800A01A8) Object required -- Microsoft VBScript runtime (0x800A000D) Type mismatch: '[string: ""]' -- Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data. --
I know the site uses mysql, I've transfered every database/table/data to my localhost database.
One thing I don't understand is the ODBC (DSN) setup. The cpanel on the site lists 4 data sources with databases, I can't seem to find the mdb databases in the directory specified in the ODBC info panel (perhaps the mdb files are linked with mysql?)
First Table Player tbl_player (fld_id, fld_dor, fld_tname, fld_tpass, fld_name, fld_email, fld_mobile)
Second Table Attempt tbl_attempt (fld_attempt_id, fld_dop, fld_tname, fld_pid, fld_pscore)
Relation of First Table with Second Table is fld_tname and fld_pid of tbl_attempt with fld_id of tbl_player
Basically this is a 2-player game in which tbl_player contains both player a and player b details (they are identified by same Team Name). Table Attempt (tbl_attempt) holds individual scores which again can be grouped as a team score by the field fld_tname. Code:
Developing a community website, and want to be able to maintain a database of members currently online on the site. I can save their ID as they log onto the site, but dont know how to tell when they leave it??
Any ideas please?
Also, anyone know of an asp Instant Messaging script that can interface with the on-line database I will be maintaining??
i need to view a list of logged in users... now i got loginlogout thing going on...but if the user will not logout he will be still logged on for the system... the only rule i want (on this code that i don't know how to wrote) is how to set timeout of 1 hour...that id the user had not moved or did nothing for 1 hour he automaticly will be offline for the system.
I am lookign for an indepth FSO tutorial not something i can copy and paste but something i can actually learn from. I have found things that do some of the stuff that i need it to do but i know down the line somewhere i will come up with problems if i dont write the code myself.
Want to create a web page that asks users certain questions and then when clicking the submit button the info get sent via email.
Obviously will create a form and then will have text boxes for each question. Correct me if I am wrong but the aspmail object is limited to a few fields.
Is anybody aware of an ASP-based online CSS editor? I'd like to be able to manage my site's CSS files online. Ideally, I'd like to be able to change the colors and such online, then have ASP write the changes to the styles.css file. I know I could have dynamic asp tags throughout my site that would pull the styles from a database, but I'd like to just write to the text file. I haven't seen anything in aspin or hotscripts, so I was wondering if anybody has seen something out there.
I am having a go at building an online calender and I am using icons to display events on a certain date. I would like to show 1 icon for events that are in the future (for example blue square) but another icon for events that have passed (example grey square). All I have in the DB is the actual date of the event.
I am looking for some ASP - SQL server 2000 online store application that i can buy for my company. This store is completely internal for the company and will be on our intranet server and will be utilized by the company employees to buy company merchantdize.
Also at this time there will be no credit card processing as the amount of purchase will be deducted from the payrol. I will be needing the shopping cart and product view. Later if we provide the credit card processing, we have already installed PayFlowPro from verisign and do creadit card procesing on our main site.
Does any one know such application that i can integrate with our style sheets and general layout?
I plan to setup a website which will give help guides on DIY. I want to allow people to submit their own guides while allowing them to have a link to thier own site to help promote thier company. I want to be able to have a directory of all the guides with a nice simple layout. Does anybody know of any good free or cheap scripts that will allow this?
If anyone is familiar with Camtasia, they should know that it can output files in various formats... SWH, WMV, AVI, Quicktime, etc.
I would like to output the files in SWH format since it includes a Flash interface with player controls, etc. There are limitations on the size of the video with this format. I'm not sure what they are right now.
Anyway, I would like to begin publishing the videos to my website that is written in ASP.
Can anyone give me any points in the best way to handle this or if there are any online tutorials or third party components for managing online content in this way.
I realize I could create a table and assign various fields and simply put the content into the database. This is likely the best approach, but then I have to deal with an admin page because our end users won't have the ability to use Enterprise Manager or Query Analyzer to update the table using raw SQL. Code:
Has anyone ever set up code samples for using UPS online tools I need it for international shipping. I've been trying to setup the tools myself. Some countries work fine, others produce validation errors. Other errors include no shipping solutions between origin and destination. When I manually check on the UPS site, they resolve without problems
I have a login script and everything, I just have one problem. The thing is, is that I want to check how many users are online. It is very simple to do that, but is there a way to check when their user-session ends, or something? In the database all it is is a simple yes or no under "online" and if they are logged in it goes to "yes" and if they access a page while logged out, there is no way to check if they are online or not. How should I go about doing this?
And if you give me a code, can you please tell me how it works so I can easily modify it(It's just that it'd take a lot less time with you explaining it, than me figuring it out All I need is a simple wording
I want to build an online questionnaire, and i dont know where to begin. whats the best way to go about this? sessions?process:user fills up questions/survey user can go back to previous pages to recheck answers then when user is done, when he clicks on submit, the answers are emailed to me.do i need a db for this?
i want to check if a user is online or not,i mean the user use http protocol to access my site,if he close his browser ,how can i know it IMMEDIATELY? so the session can be used here? i found some chatroom using this technology, if possible, give me the java answer also?
i need to count visitors and on line users, but I’m having some problems with this global.asa counter witch should use correctly those application and session variables and session onStart and onEnd procedures.
Some how it doesn’t work well. Is there any other way to count visitors and users online?
I have a forum and I would like to have a ASP-page where the visitors can see who's online and where they are. ( as http://www.sitepointforums.com/online.php?s= ) It's easy to list up the members. But how should I make the same thing to guestes? But the problem is that I would also have guest in the list. For example:
I am making a website for people losing weight to give their slimmed out of clothes to others that need their old size. What I'm trying to do is make a form (which I did get that part) to fill out what type of clothes they have to give or need.
The problem is I'm wanting to make an online database that everyone can view to see what's been submitted into the form. I made a view.asp and another asp file and a mdb file. I read a buncha stuff and finally found a wizard thingy that helped me with all that but it doesn't work.
Need some advice/pointer on how to develop an online shop using ASP.
I have some experience developing with ASP having previously designed a web based IP & Hardware tracking site using an Access 97 database to store the data.
I have been asked to develop a pilot web site in the form of an online shop with possibly a shopping cart feature and web based admin to update the site as and when required.
I am quite comfortable about setting up the initial site however I need more information and examples of how to set up the E-Commerce side of the site, how a shopping cart feature can be implemented using ASP and user registration and account management.
Is it possible (and if so how), to show a 'users online' counter on my site(VB ASP)?I have seen lots of site that say, xxx members online and xxx guests online. How can I do this?
I intend to make an online shop for a few web sites.
I would like to build it myself from scratch in ASP.NET using VB.
I don't want to buy any software etc because I would like to gain the experience of building it myself.
Can anyone recommend any good books / web sites / articles that will guide me through the process. I like WROX Press but don't know which books will suit me best.
I am creating an application for online test in ASP.While taking test i want functionality as on brainbench when we take any test there. Only difference i want is that there will be 5 questions in my test to be solved in 10 minutes.And all 5 will appear on one page. I am done with other parts.but i am unable to find the logic for restricting time.And dont know what logic should i implement so that timer should not start again even when he goes back and returns to the page again.I have used javascript timer.
I try to make my page http://tudef.jezz.dk show the online users ip numbers, but i only get my own ip, even if more users are online. I use request.server.variables and remote_addr
