inserting a 0 in front of a number? i dont think i can do it with data type "int" so i changed to "nvarchar" and for some reason upon inserting it still takes the 0 away
inserting - "0600" for example.. only 600 is inserted.. but if i manually input it it works.. errrr
I have a text field in a web page I am working on that seems to be calculating phone numbers before inserting them into an Access database. i.e., 867-5309 will result as -4442 in the Access text field. My guess is that the webserver or client is processing it before inserting it. Is there any way to stop this other than using a validation script?
View Replies View Relatediis runs on win2k3. i need to have a web-based app that among others does something like this:
1. login - validate against the local user database.
2. user must belong to a certain group (say backup operators group).
3. create a web-based front end to the task scheduler. create, modify, delete schedules.
i dont have a starting point with regards to the three requirements.
Currently working on transferring site to a new host. Site uploaded, but we are unable to browse asp pages ?
View Replies View RelatedWe've recently rebuilt our entire website with a normalized database
structure (previous structure was horrific). The structure is great now,
but we also recoded approximately 5000 ASP pages. Site went up today with
minimal difficulty (probably 10 minor problems). Then, at about 4pm, the
entire web server locked up and we weren't able to access it. I couldn't
get into it via remote desktop, explorer or any other means and the site
locked up entirely. Any idea what could be causing this (outside of a
fluke)?
I always heard people saying IIS ASP front end, and MS-SQL back end. ASP is
for server side programming and dynamic content generation, how could it is
called front end? Because I thought it is executed in the server, which is
back end? I think I am confused with the term front end and back end here.
iis runs on win2k3.i need to have a web-based app that among others does something like this:
1. login - validate against the local user database.
2. user must belong to a certain group (say backup operators group).
3. create a web-based front end to the task scheduler. create, modify, delete schedules.
i dont have a starting point with regards to the three requirements
I have a website using ASP. All the codes are written in Front Page (Microsoft Office for Windows XP).
I want to use Front Page 2003 and Microsoft Office 2003.The website codes are going to transfer to the Front Page 2003.
Would it going to be a problem since all the codes were originally created in Office for windows XP?
I've been charged with coming up with an application that would allow a user to type in a social security number, have a page retrieve the person's information from a SQL Server DB and then convert that information to an XML file. Has anyone had any kind of experience.
View Replies View RelatedI have my database created and i need to do the front end of it on the website but i have no idea how to get the information from the database to the website.
View Replies View RelatedI am trying to run an update statement to show a value on a front end ASP page. What I would like to see is if the value from the update statement in null I want to display a zero on the front end.
I wrote this statement and thought it would do that but it still doesnt appear as a zero it just shows nothing because null cannot be displayed. Code:
I have created a workorder form on Front Page that employees use to send in computer and other maintenance problems. In the form properties, I can choose to send the data to a database OR send it in an email, but can not choose both. We have it going to a database so we can better manage the data. But we would also like to send an email notification when a new record is added to the database.
I've tried this in Access on the database end but came up emptyhanded. The Access gurus have suggested it's something I need to do in html on the form. My html is very limited so I'm hoping someone can tell me if this is possible, and how I would go about doing it. The HTML gurus suggested it was an ASP issue.
Why is it when I enter a date in a date field and update, sometimes it will be displayed in US format (month, day) and sometimes in English (day, month) and is there any way around this?
View Replies View RelatedOur application launches a webbrowser window with a command to (more than
one) asp's on the host. The window is reused for subsequent commands.
Unfortunately, the old window is usually underneath some other window and
unaccessable from the application.
Is there (preferably) a browser-independant method to command the window to
front from the asp?
my site (which I am currently redeveloping) has 3 different sections to the site. All which well contain different information.
What I want to know is how can I make the starting page of the site display information which the users is looking for.
eg. if the user always go to one section of the site the main page well show information relevant to that section. (I hope you know what I mean)
So I was thinking about how to do this and this is what I came up with.
Set a cookie for the site and each section has there own number value (eg. 1 to 10)
When the user hits the main page it gets the values of all 3 sections from the cookies and checks which has the most value (eg 3, 5, 10).
Based upon the highest value each section has there own .asp include which is shown to the user.
i wanna connect front page forms with the database for searching and updation .. how can i do it.. in asp it ask to host the web it doesn't works on disk drive..any one help to solve this proplem..any alternative
View Replies View RelatedI have 2 webs under my default web running win2003
1. A front-page intranet
2. A asp (not .net) web is fine
Both allow anonomous access. My front page web always gets a BLANK Request.ServerVariables("Logon_User"). The asp web gets the logon_user OK. Both webs have a global.asa that has Code:
I have FrontPage 2003 on my XP laptop. I need to test some web pages with *.asp codes which worked perfectly well with my old Win95 computer in the past. Of course I had to install Personal Web Server to it in order to do the job.
The help files of FP, gives the clue that it has the facilities to behave like a server and test interactive web pages. But I haven't seen the use of ASP pages with it. I do not wish to install a server on my XP just to test ASP pages.
I m using front page. I have used some button and value of all button is different so its width show different. I want to equal width of all buttons. I dont want to use link button.
View Replies View RelatedI'm trying to put the 4 latest(by publication date) articles published in my press table on the front page of my site. What's the logic here:
Show only the 4 latest articles
and if there is no addition to the article db:
Show latest articles for 1 month.
I have installed Front page server Extention on IIS 5.0 it was working fine.
I was able to load project from Visual Interdav and doing well. Yesterday I
installed a security update from Microsoft and after that every thing stop
working and I am getting the error below when ever I am trying to connect to
server using V Interdev. Error Shows that FP Server Extention is not
installed but its there even I removed it and installed it back error is
still there.
"An HHTP error occured. The server could not complete your request. Contact
your Internet Service Provider or Web Server administrator to make sure that
the server has the FrontPage Server Extensions installed, and that the Web
application exists on that server" Code:
I m using front page. I have used some button and value of all button is different so its width show different. I want to equal width of all buttons. I dont want to use link button.
View Replies View RelatedI need to insert some number into database as text. My problem is if I insert the number (ie. 4.0), the value in the database only show (4). So, is it possible to convert a real number into text number using ASP?
View Replies View Relatedhere is the scenerio
in master batch table i have various master batch like
200701-0001
200701-0002
200701-0003
Now each master batch can have multiple final mixed batch like
200701-0001-01
200701-0001-02
200701-0001-03
and this record is inserted in to fmix table.
so i have a form in which i have a dropdown menu in which all the master batch is listed,
i select 200701-0001 and that value is passed to next page where i will enter other fields data and insertion to my fmix_no will be done automatic like 200701-0001-01, 200701-0001-02 and so on,
how to achieve this
so in short each master batch will have more than one final mixed batch.
pls help, also if u have any online contact in yahoo or msn pls send me, i am so confused and badly struck deadline is just couple of hours away. my yahoo id is(E-Mail address blocked: See forum rules) you can PM me i am online right now.
I want To handel the error messages by myself in one part in my script. I know that in VB I can Use the statment - On error resume next And I also know that I can retrive the Error Number In VB with Err.Number.
How can I handel the errors by myself in ASP? I heard about the ASPErr Object, Is it the same thing like the err object in VB?
There i seem to be having a problem when inserting certain characters into my access database using a form, mainly (') characters.
View Replies View RelatedI get the following error message
Microsoft VBScript compilation error '800a03ee'
Expected ')'
/weblinkup/chat.asp, line 1775
oConn.Execute("INSERT into chat (username,nametext,roomname,type,priv,thetime,msg) VALUES ('" & username & "', '" & username & "', '" & Roomname & "', 'msg', '0', '" & now() & "', '" & username & " has just said " & emotetarget & "." ')")
what the problem is with the code?
i have a database Access with Book Table and Author Table. now i have created a form which inserts info submitted into the Book Table, yet it keeps giving me this error "You cannot add or change a record because a related record is required in table 'Author' " while the names of the authors are all registered.
it works in Access but not in asp it doesn't make much sense. People just enter the names of the books which their authors are in the Author table. it keeps giving me error. how to know why this is so?
I have an error as follows:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not bulk insert. File 'c:mydata.csv' does not exist.
My mydata.csv file is inside the directory i stated. But why does the server complains that the file is not fould?
My codings:
strSQL = "BULK INSERT NAME FROM 'c:mydata.csv' WITH (FIELDTERMINATOR = ',',ROWTERMINATOR =
'
')"
Response.Write ("test")
Set oRS = conn.Execute(strSQL)
I had some Error when i write the update sqlp query
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/fyp/Quiz/updateQuiz.asp, line 21, column 77
SQL_query= "update Activity_Status set UserID = '" +Request.Form("username") "'" "where Score = '" +Request.Form("QuizScore" + "'")"
Code:
SQL_query= "update Activity_Status set UserID = '" +Request.Form("username") "'" "where Score = '" +Request.Form("QuizScore" + "'")"
I'm using ASP + MS SQL. I wrote a simple insert into command but nothing is happening... it gave no error and no information is stored in the db. When I response.write my SQL, I got the following:
INSERT INTO [blog_entries](title,user,entry,date) VALUES('test','admin','test','Tuesday, December 25, 2007')
I'm wondering if it's possible to create an instance of an ADO Recordset and add values to it by ASP ??
Ex :
I have 2 arrays :
arr1 = Array(1,"allo")
arr2 = Array(2,"bonjour")
Is it possible to add these 2 arrays into a Recordset to manipulate de data more easily?
If yes, could you provide me with a little example to see the synthax, because I tried almost everything and it didn't worked at all
how do i design my site interface such that users can insert smilies along with text in the form field just like it is here on sitepoint...
View Replies View Related