Find Jobs
Hire Freelancers

Classic ASP Insert, Update or delete Form 2 issues.

€8-30 EUR

Dokončeno
Zveřejněno před více než rokem

€8-30 EUR

Zaplaceno při doručení
Hi, Two issues: ISSUE #1: About MSSQL database... and classic ASP... I have a issue by a webpage Form insert or update a numeric value with a comma. In Microsoft SQL Server Management Studio I can put nummeric (field as decimal(18, 3)) values with a comma. like "14,3" or even "14,344" No problem. It stores this value in database correct. By insert or update trough my webpage Form the database refuse the comma! It will only accept "14.3" or "14.344". And write it good as "14,3" or "14,344" When I set in the form the nummeric value separated with a point "." then it's writing the value correct with a comma separated value in my database. How can I solve this out? It's must be normal like by putting "14,3" or "14,333" and write it correct in the table field... with the comma. I do not allow FTP or Database access. This is my actual code from textfield in insert or update form: +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ <input name="inflation" type="text" class="tekstveld" id="inflation" value="<%= [login to view URL]("inflatie").Value)" /> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ I need only (I think) a snippet of code in my webpage. BTW: It's not possible to change the collation from the database cause I use it for years for other projects. ISSUE #2: It seems that update, insert or delete form my sessions kill's! By submit form (POST) the update works (dispute issue with comma issue#1). So i must pass a variable in to GET but that doesn't work. Ik try now to go back to POST but I must add session variable to MM_redirect URL This is a the piece code where the redirect URL is written. ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ <% ' *** Update Record: set variables If (CStr(Request("MM_update")) = "form200" And CStr(Request("MM_recordId")) <> "") Then MM_editConnection = MM_mainconnect_STRING MM_editTable = "dbo.LGTBL_LOGIN" MM_editColumn = "ID" MM_recordId = "" + [login to view URL]("MM_recordId") + "" MM_editRedirectUrl = "[login to view URL]" & "?dc=" & ""Session("dc")"" MM_fieldsStr = "btwtarief|value|inflation|value|korting|value" MM_columnsStr = "btwtarief|none,none,NULL|inflatie|none,none,NULL|korting|none,none,NULL" ' create the MM_fields and MM_columns arrays MM_fields = Split(MM_fieldsStr, "|") MM_columns = Split(MM_columnsStr, "|") ' set the form values For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_fields(MM_i+1) = CStr([login to view URL](MM_fields(MM_i))) Next ' append the query string to the redirect URL If (MM_editRedirectUrl <> "" And [login to view URL] <> "") Then If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And [login to view URL] <> "") Then MM_editRedirectUrl = MM_editRedirectUrl & "?" & [login to view URL] Else MM_editRedirectUrl = MM_editRedirectUrl & "&" & [login to view URL] End If End If End If %> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ It's give me a error: Microsoft VBScript compilation error '800a0401' Expected end of statement /[login to view URL], line 48 MM_editRedirectUrl = "[login to view URL]" & "?dc=" & ""Session("dc")"" ------------------------------------------------^ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Thanks in advance.
IČ projektu: 35954813

O projektu

3 nabídky
Vzdálený projekt
Aktivní před rokem

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
Uděleno:
Avatar uživatele
Hi I will solve both the issues as i have 6+ years of experience in CLASSIC ASP and sql server etc let us discuss Regards Paul
€25 EUR v 7 dnech
0,0 (0 recenze)
0,0
0,0
3 freelanceři nabízejí v průměru €22 EUR za tuto práci
Avatar uživatele
Hello, I'm a professional in C#NET, ASP.NET MVC, and MSQL Server, and I'm sure I can do this. I am looking forward to working with You! Thanks, Noman M.
€19 EUR v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Hi, I read through the job details extremely carefully and I am very sure I can do the project very well. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. Please let me know more about the project so I can starts works on time. I would love to work on your project. I have more than 9 years of experience in. Management Software: School, Learning, Matrimonial, Online Auction, Load, Advocate, Tour & Travel, Inventory, Stock, Accounting, Pharmacy, Invoice, Affiliate, Real, Human, Gym, Job, Business , Business Accounting Management Software. Website Design & Development: JAVA, Wordpress, Shopify, E-commerce, PHP, Laravel, Javascript, Jquery, codeigniter, MySQL, Mongodb, MVC, HTML, Bootstrap. Hoping for a positive reply. Thanks & Regards
€21 EUR v 1 dni
0,0 (0 recenze)
0,0
0,0

O klientovi

Pochází z BELGIUM
Mechelen, Belgium
5,0
22
Ověřená platební metoda
Členem od bře 29, 2017

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.