Is it possible to build a pop up calender using dreamweaver? I have a text box where user need to type a date format. I want to a calender to display when the user double click on the text box so that the user can choose a date and then the date must be appear in the text box.
View RepliesI am developing a simple calender in ASP which will display the next upcoming birthday of my member. Just like some forum have.
I have a table which has 2 column
cname | dob
-------------------
Joe | 9/12/1982
Mathew | 2/17/1997
Pat | 8/23/1880
-------------------
What SQL Query should I use to get the name of that person?
Some basic information:
Database = Access (may be I can upgrade it into SQL Server 2000)
Date Format in database = mm/dd/yyyy
I'am currently coding a page using .asp/c# but have run into a obstacle that I can not overcome.I set up a calender that displays the current date ie:
date.SelectedDate = DateTime.Now;
The calender show the current date unless the viewer wants to know the date/time of the next computer club meeting date. In my case they will click the next meeting button, which will find the next meeting date and display it in labels below the button. The club meets at 7pm on every first and third Wednesday of the month.Now iam trying to write the code that find the next meeting date in relation to the current date.
I wanted to embedd a calender from where the user selects the date and that date then shows up in the text box and then the form gets submitted.I want to use the calender to reduce the errors while the user is filling the form.
give me some references to some good calender components or may be how i can go about doing this.Any site names where there are such components already desinged.I went through a few calender components but dint fit into what i want to do.
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 want to develop and application that has a calender in form. this will a. A user will search on the calender and on a particular day, he/she should be able to add entries to it so it is visible to others or for next visits in the mean time it should add information to the database... similar to outlook calenders which is the best way to implement it? Code:
View Replies View Relatedi need to build a booking system which relies on a calender. basically i have a db of clinics thar offer allotted times for appointments on certain dates. eg: a clinic may offer five 20 minutes slots 2 days a week.
so i need to get the data out of the db and display that in a calender form which the user can then select the time/date convenient to them. my question is (apart from how do i build this!?!?!?!) does anyone know a good calender that would fit my purpose? Code:
is there any free components available that I can use on my HelpDesk, where
the employees can select a date and fill in data if they are out of the
office for the day, everyone will be able access it and see where who is
Anyone got a good tutorial on how to build a CMS with ASP?
View Replies View RelatedI have the following piece of code:If RS.EOF or RS.BOF Then
Session("Authenticated") = False
Response.Write "Sorry, your userid or password did not match"
Response.Write "<BR>"
Response.Write " or you have not registerd yet, please register"
Response.Write <a href="default.asp">Clik here
Response.End
Here, I need to build the line (Response.Write <a href="default.asp">Clik
here)
dynamically, so that the html output from asp page
gives us <a href="default.asp">Clik here
I have a situation where I have to update a single table with information from a bunch of fields. So I can explain better this is a sample table with some data... Code:
I am having trouble with structuring my query for searching using "LIKE". I
return no records with my current SQL statement.
Here is the string I am sending through ASP using VBScript as my language.
Other piece:
strClass = Request("SiteLOCCode")
String from ASP page:
"SELECT * FROM LDSWSNames WHERE WSName LIKE '" & strClass & "' "
Output string from ASP:
SELECT * FROM LDSWSNames WHERE WSName LIKE 'KYLEXAD01'
I want to make a dropdown using a column from my table in the list of the dropdown.
What's wrong with this?
<form>
<select size="1" name="D1">
<option VALUE="0" SELECTED>chapter</option><br>
<%Do while not RS.eof
ResponseWrite "<option VALUE="" & chapter & "">chapter</option><br>"
rs.movenext
loop
' Exit the loop when reaching the end of the recordset
'If rs.EOF Then Exit For end if
'next
'end if%>
</select></form>
I want to make a dropdown using a column from my table in the list of the dropdown. What's wrong with this? Code:
<form>
<select size="1" name="D1">
<option VALUE="0" SELECTED>chapter</option><br>
<%Do while not RS.eof
ResponseWrite "<option VALUE="" & chapter & "">chapter</option><br>"
rs.movenext
loop
' Exit the loop when reaching the end of the recordset
'If rs.EOF Then Exit For end if
'next
'end if%>
</select></form>
I'm facing a crazy problem:
<%
spc = "<abcd"
response.write spc
%>
will not work, spc is empty.When I replace <abcd with ab<cd, then spc contains only ab.
Where do I make the mistake ?
I want to make a dropdown using a column from my table in the list of the dropdown. What's wrong with this? Code:
<form>
<select size="1" name="D1">
<option VALUE="0" SELECTED>chapter</option><br>
<%Do while not RS.eof
ResponseWrite "<option VALUE="" & chapter & "">chapter</option><br>"
rs.movenext
loop
' Exit the loop when reaching the end of the recordset
'If rs.EOF Then Exit For end if
'next
'end if%>
</select></form>
I need to get my name value "MenuSubCat" to act as athird level menu. This is a dynamic menu and it only does Code:
View Replies View RelatedI am creating a search page and need help writing the code to build the sql
string.
I have 3 fields on the main page which a user can choose to enter search
terms in any of the 3 fields. My question is how do I write the logic so it
only includes the fields in the search criteria where the user has entered
anything.
Fields are
Production No
Production Title
Synopsis
The user may enter any, all or some of the search teams in the fields.
On the search page I am using lots of if conditions to build my sql string
like
strSQL = "Select * from Productions where "
now after where there are lots of permutations and combination like
production no could be empty or it could be filled in and the other fields
might be empty or filled in as well.
Does someone has a simple logic to build the correct sql String?
I'm about to start building a website which has a MS SQL back-end database. The host annoyingly won't allow me to connect to the database through Enterprise Manager, so he's advised that the database be created entirely though scripts.
I'm not particuarly good with T-SQL, so is there a tool I can use to generate the scripts from a database I have built? Can Enterprise Manager output the source code to build a database once it has been built? Could I set up and test the database on a different MS SQL server, then export the entire script and contents into a SQL query which could then be run through an ASP script to build the same database on a different server?
Basically I need to create a recruitment website whereby the recruitment company can post up new jobs and create new categories. On the home page it must display all the categories in boxes with each job that relates to that particular category displayed underneath it. For example: Code:
View Replies View Relatedanyone has any program or tool or code which builds a shopping cart easily?
View Replies View RelatedI'm trying to build a details page that is reachable when a user clicks on the ID of a query that's returned multiple rows of data. The first piece of code is the querytest.asp page, and the second is the details.asp page. However, how do I get the user_id passed to the details page? Code:
View Replies View RelatedI'm interested in building a graphical timeline for a series of tasks that are stored in a SQL Server 2000 database. The tasks reside within a table. We also have a table to track the history and date of status changes. Some of the status flags are as follows:
1 - In Progress.
2 - Awaiting Info.
3 - On review server.
For each task, using ASP or ASP.Net, I would like to be able to display a graphical timeline for each task, with the status changes denoted for a given date range.
Does anyone have any ideas on the best approach for this task?
I need to build an UPDATE statement that copies the values of roughly 40 fields from a table that stores standard or default values into a table of specific contracts. There are 8 or so fields in the source table that are not in the destination table. The remaining field names are identical in both tables.
How do I create a recordset of the field names I am interested in so that I can loop through it to build my UPDATE statement?
I have spent the past several weeks building an ASP.NET 2.0 Application that has a Users.xml file where all user information is stored. I am now designing the administrator tools and want to be able to sort through the records in the XML file. Essentially, I want to be able to build this:
http://beta.asp.net/QuickStartv20/aspnet/samples/data/GridViewSorting_vb.aspx
It seems that every example i hit is a sqlserver example and there doesn't seem to be very good sorting capabilities for XML. is this true? how do i acheive the above link? I would really appreciate any code examples or code links if you know/have them.
I want to build a website who handle 3 different countries (english, german, french). The changes between the countries is the text on the website. I know that i can put the text in a database to change it dynamic. But i wonder if i can do it on another way?
View Replies View RelatedI seem to have a very good library for PHP, XML, Cold Fusion, Flash, JavaScript, and Java..but Im wanting to begin building some helpful references for ASP.net. I got one book called "Designing ASP.net Applications" from Microsoft, but it, sadly, wasnt very good for someone like me thats starting out.
Can we use this thread to possibly suggest good books on ASP.net, VB.net, C#, etc that have helped you, and perhaps others can benefit from it, as well as me?
I've been following the building an FAQ tutorial and have uploaded all my files to the server but get a message saying the page cannot be displayed when I try to access it.
Can anyone tell me what obvious mistakes I might have made? I've checked the code over and over again but the only thing I'm not sure about is the connection to the database. How do I know the path to my database?
i want to build simple chat system for fun. but i dont know where should i start. i know asp and little JS , AJAX .
i think these are enough for that kind of target. actually most important question is where should i store messages? and how can i send incoming messages to users "AT THE SAME MOMENT" . i mean how can i make continuous connection or is it possible?
i have a project for school and i have to build a shopping cart can anyone tell me how to do this thank you?
View Replies View Relatedi'm trying to build a simple re-usable function which lets me connect to a database, using whatever parameters i pass through, and which i can then call from inside other functions in my page which use the data.
e.g. this is the kind of thing i'm trying so far, but at the moment it's throwing up an "Object required: 'rs'" error. Code:
I am currently putting together an eCommerce site. I have almost everything
in place, but I am not happy with the category system for our products.
There are around 2500 products in a SQL Sever db, each assigned 1 of 300 odd
categories. Currently, I have statically built the category tree but wish to
automate this task as it is becoming increasingly difficult to manage.
I have googled plenty of info, specifically for ADO data shaping. Is this
the right route to take, especially considering each branch of the category
tree may differ in depth of categories? How exactly do other eCommerce sites
automate this task?
I would also want to be able to copy the category system that provides links
to previously selected categories i.e.
Category 1 > Sub Category 2 > Sub Category 3 > etc etc
Is this possible with the SHAPE command? Are there other methods of
performing this task?
I am particularly concerned about the database taking a major performance
hit from all of these SHAPE queries, which would be required on every
category page. Could I use a stored procedure, and how much would it improve
performance? Considering I will be hosting on a shared server, I want to
make this as efficient as possible.
what is the correct way to dynamically build a call to a function in asp? i have the name of the function i want to call in a dictionary object, this works to execute the function but the output_value variable does not get set.
functionString = d.Item("create_contract_function_name") 'set variable for
the create contract function name that was retrieved
functionString = "output_value = " & functionString & "(param1, param2)"
Execute functionString